standard formulas

array formula

complex formulas

smart formula

**Which area in an Excel window allows entering values and formulas?****How do you rearrange the data in ascending or descending order?****To center worksheet titles across a range of cells, you must****The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…****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…****Excel displays the current cell address in the ........****Long text can be broken down into many lines within a cell. You can do this through****In help menu of Excel, which of the following tabs are found?****Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…****Which of the following is invalid statement?****The short cut key Ctrl + R is used in Excel to****Which would you choose to create a bar diagram?****Multiple calculations can be made in a single formula using .......****Excel worksheet cells work very similarly to what common element of the windows graphical user interface****To remove the content of selected cells you must issue ______ command****Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?****The autofill feature****What will be the output if you format the cell containing 5436.8 as #,##0.00'?****We can save and protect the workbook by****To return the remainder after a number is divided by a divisor in EXCEL we use the function?****MS Excel provides the default value for step in Fill Series dialog box****Which of the cell pointer indicates you that you can make selection?****Which function is not available in the Consolidate dialog box?****Multiple calculations can be made in a single formula using****How do you select an entire column?****Tab scroll buttons are place on Excel screen****Which of the following is not a basic step in creating a worksheet?****What is the short cut key to highlight the entire column?****To view a cell comment**