Excel Section 1 Knowledge Check
ribbon
This area contains commands and buttons for performing actions divided into tabs and groups.
Formula bar
This area displays the formula stored within the cell (not the result).
Paste Options (Ctrl)
This button appears after copied cells are pasted into the destination range.
Accounting
This format adds a dollar sign, a comma in the thousands place, and two decimal places to each value in the selected range.
proof formula
This is the term for the formulas entered beside or below a worksheet that are designed to verify the worksheet's accuracy.
pointing method
This is the term for the method used to create a formula by typing the equals sign and operator symbols while clicking reference cells between the typed symbols.
Ctrl + `
This keyboard command displays formulas in a worksheet.
F1
This keyboard shortcut will open the Excel Help window when pointing to a button.
argument
This term is used to refer to the values identified within parentheses in the SUM function.
=C6/C12
This would be the formula to divide the contents of cell C6 by the contents in cell C12.
Editing
The AutoSum button is located in this group on the HOME tab.
Custom Sort
Click the Sort & Filter button in the Editing group on the HOME tab and then click this option at the drop-down list to display the Sort dialog box.
Display this backstage area to change the page orientation.
drag to select the correct range
Do this action if Excel suggests the wrong range after you click the Sum button.
Go To
Open this dialog box to type a cell reference to which you want to move the active cell.
thin black cross
The cell pointer changes to this when pointing at the small green square in the bottom right corner of the active cell.
