Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
- Which of the following is an absolute cell reference?
- To create a formula, you can use:
- Concatenation of text can be done using
- Which of the following options is not located in the Page Setup dialog box?
- Which of the following is not true regarding Conditional Formatting?
- Which key do you press to check spelling?
- Rounding errors can occur
- You can convert existing excel worksheet data an charts to an HTML document by using
- The command Edit >> Fill Across Worksheet is active only when
- Which of the following is not information you can specify using the solver?
- Status indicators are located on the
- When integrating word and excel, word is usually the
- What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
- A numeric value can be treated as a label value if it precedes with
- Which of the following is not a basic step in creating a worksheet?
- Hyperlinks can be
- Which command will you choose to convert a column of data into row?
- How can you delete a record?
- When you insert an excel file into a word document. The data are
- A __________ is a grid with labeled columns and rows.
- How can you print three copies of a workbook?
- What is the correct way to refer the cell A10 on sheet3 from sheet1?
- Which of the following is not a way to complete a cell entry?
- In Excel, a Data Series is defined as what?
- Which of following is Not one of Excels what-if function?
- Which of the following methods cannot be used to enter data in a cell
- Tab scrolling button
- When you link data maintained in an excel workbook to a word document
- You can activate a cell by
- Comments put in cells are called .....