Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
- Comments can be added to cells using ......
- Which of the following is an absolute cell reference?
- Excel files have a default extension of
- To activate the previous cell in a pre-selected range, press
- Which elements of a worksheet can be protected from accidental modification?
- What will be the output if you format the cell containing 5436.8 as #,##0.00'?
- Which of the following is not a valid data type in excel
- B7:B9 indicates:
- When a row of data is to be converted into columns
- To create a formula, you first:
- A numeric value can be treated as a label value if it precedes with
- In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
- When you insert an excel file into a word document. The data are
- Which is used to perform what if analysis?
- What is represented by the small, black square in the lower-right corner of an active cell or range?
- A typical worksheet has . Number of columns
- We can save and protect the workbook by
- How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
- Which of the following is not the correct method of editing the cell content?
- You can auto fit the width of column by
- Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- Which would you choose to create a bar diagram?
- Which of the following is a correct order of precedence in formula calculation?
- What is the correct way to refer the cell A10 on sheet3 from sheet1?
- Which of the following is not a term of MS-Excel?
- To view a cell comment
- Which of the following is not a valid data type in Excel?
- To record a sequence of keystrokes and mouse actions to play back later we use:
- To save a workbook, you:
- Which of the following is a popular DOS based spreadsheet package?