Flashcards in Excel Exam Deck (30)
This area contains commands and buttons for performing actions divided into tabs and groups.
This area displays the formula stored within the cell (not the result).
The cell pointer changes to this when pointing at the small green square in the bottom right corner of the active cell.
Thin black cross, fill hanger
This would be the formula entry to divide the contents of cell C6 by the contents in cell C12.
This is the term for the method used to create a formula by typing the equals sign and operator symbol while clicking reference cells between the typed symbol.
This term is used to refer to the values identified within parentheses in the SUM function.
The AutoSum button is located
In this group on the HOME tab.
Do this action if Excel suggests the wring range after you click the AutoSum button.
Correct the range of cells that you want to add.
This button appears after copied cells are pasted into the destination range.
Paste option button.
This is the term for the formulas entered beside or below a worksheet that are designed to verify the worksheet's accuracy.
This format adds a dollar sign, a comma in the thousands place, and two decimal places to each value in the selected range.
Accounting number format
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.
This keyboard shortcut will open the Excel Help window when pointing to a button.
Display this backstage area to change the page orientation.
This keyboard command displays formulas in a worksheet.
Open this dialog box to type a cell reference to which you want to move the active cell.
Use this feature to remove everything from a cell including text and formats.
Make a cell active anywhere in this row to insert a new row between 11 & 12.
Make a cell active anywhere in this column to insert a new column between E & F.
This is the term for adjusting a column width to the length of the longest entry.
This term refers to the feature that shows the result of a format option while pointing to the option in a drop-down gallery.
By default, cells Are initially set to this numerical style format.
Clock this button in the Alignment group on the HOME tab to center cells vertically between the top and bottom cell boundaries.
Click this button in the Clipboard group on the HOME tab to copy the formats of the active cell.
This feature stores predefined format options.
This feature stores a set of colors, fonts, and effects that can be applied to the entire worksheet.
Make this cell active to freeze rows 1 through 5.
List two methods for changing the zoom magnification to view more cells in the current window.
Zoom dialog box
Click this tab and button to search for clip art at Office.com.