Where can you change automatic or manual calculation mode in Excel?
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
- You can set Page Border in Excel from
- If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
- In Excel, a Data Series is defined as what?
- Tab scroll buttons are place on Excel screen
- A circular reference is
- MS Excel provides the default value for step in Fill Series dialog box
- Which of the following format you can decide to apply or not in AutoFormat dialog box?
- Which of the cell pointer indicate that you can move the content to other cell?
- Which symbol must all formula begin with?
- B7:B9 indicates:
- How do you delete a column?
- What is the short cut key to highlight the entire column?
- Which button do you click to add up a series of numbers?
- Ctrl + D shortcut key in Excel will
- How can you delete a record?
- Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
- What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
- If you need to remove only the formatting done in a range (numbers and formula typed there should not…
- You can check the conditions against __________ when applying conditional formatting
- Which tool you will use to join some cells and place the content at the middle of joined cell?
- Which key do you press to check spelling?
- Each excel file is called a workbook because
- In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
- You can convert existing excel worksheet data an charts to an HTML document by using
- To center worksheet titles across a range of cells, you must
- How do you display current date only in MS Excel?
- To copy cell contents using drag and drop press the
- Concatenation of text can be done using
- The auto calculate feature
- You can activate a cell by