Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
- Excel files have a default extension of
- Getting data from a cell located in a different sheet is called ......
- How do you insert a row?
- You can edit a cell by
- Documentation should include
- Which tool you will use to join some cells and place the content at the middle of joined cell?
- A worksheet range is a
- Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- A typical worksheet has . Number of columns
- Which of the following is not the correct method of editing the cell content?
- The Name box on to the left of formula bar
- Which of the following is a correct order of precedence in formula calculation?
- You can enter which types of data into worksheet cells?
- To activate the previous cell in a pre-selected range, press
- Which symbol must all formula begin with?
- Which function is not available in the Consolidate dialog box?
- To create a formula, you first:
- Multiple calculations can be made in a single formula using
- Comments can be added to cells using ......
- Concatenation of text can be done using
- Which of the following action removes a sheet from workbook?
- Which would you choose to create a bar diagram?
- Where can you change automatic or manual calculation mode in Excel?
- The spelling dialog box can be involved by choosing spelling from ________ menu.
- You can use the drag and drop method to
- The Paste Special command lets you copy and paste:
- An excel workbook is a collection of
- What is the correct way to refer the cell A10 on sheet3 from sheet1?
- Which language is used to create macros in Excel?
- Which menu option can be used to split windows into two?