Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
- The active cell:
- Where can you set the shading color for a range of cells in Excel?
- Paste Special allows some operation while you paste to new cell. Which of the following operation is…
- What are the tabs that appear at the bottom of each workbook called?
- To view a cell comment
- Text formulas:
- Which elements of worksheet can be protected from accidental modification
- You cannot link excel worksheet data to a word document
- You can use drag-and-drop to embed excel worksheet data in a word document
- Documentation should include
- Which of the following is not the correct method of editing the cell content?
- Which of the following formulas is not entered correctly?
- A worksheet can have a maximum of . Number of rows
- Which would you choose to create a bar diagram?
- You can move a sheet from one workbook into new book by
- You can use the formula pallette to
- Microsoft Excel is a powerful ...........
- A worksheet range is a
- Excel files have a default extension of
- An Excel Workbook is a collection of .......
- Data can be arranged in a worksheet in a easy to understand manner using
- Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- A numeric value can be treated as label value if ...... precedes it.
- Right clicking something in Excel:
- When you want to insert a blank imbedded excel object in a word document you can
- Comments can be added to cells using ......
- The spelling dialog box can be involved by choosing spelling from ________ menu.
- Concatenation of text can be done using
- It is acceptable to let long text flow into adjacent cells on a worksheet when
- When you link data maintained in an excel workbook to a word document