Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
- Text formulas:
- Which function is not available in the Consolidate dialog box?
- How do you display current date and time in MS Excel?
- Which area in an Excel window allows entering values and formulas?
- Which of the following is invalid statement?
- A numeric value can be treated as label value if ...... precedes it.
- Which menu option can be sued to split windows into two
- You can edit a cell by
- An Excel Workbook is a collection of .......
- Which menu option can be used to split windows into two?
- To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
- You can use the formula pallette to
- How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
- In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
- Data can be arranged in a worksheet in a easy to understand manner using
- Excel probably considers the cell entry January 1, 2000 to be a
- Which of the following formulas will Excel Not be able to calculate?
- Comments can be added to cells using
- When a row of data is to be converted into columns
- It is acceptable to let long text flow into adjacent cells on a worksheet when
- Which button do you click to add up a series of numbers?
- What is the short cut key to highlight the entire column?
- The active cell:
- The Cancel and Enter buttons appear in the:
- What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
- A __________ is a grid with labeled columns and rows.
- Right clicking something in Excel:
- To save a workbook, you:
- You can check the conditions against __________ when applying conditional formatting
- Which setting you must modify to print a worksheet using letterhead?