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?**