| A | B |
|---|
| The Accounting Number Format button is located in the _______ group on the HOME tab. | Number |
| Use the _______ button in the Editing group on the Home tab to find the total or average of data in columns or rows. | AutoSum |
| Click the _______ & _______ button to merge selected cells and center data within the merged cells. | Merge & Center |
| Select all cells in a column by clicking the _______ header. | Column |
| To select nonadjacent columns using the mouse, hold down the _______ key on the keyboard while clicking the column headers. | Control |
| Location in the worksheet that will display typed data or that will be affected by a command | Active Cell |
| Displays the contents stored in the active cell. | Formula Bar |
| When this icon appears, select cells by clicking or dragging the mouse. | Cell Pointer |
| Click to open a dialog box with more options for that group. | Dialog Box Launcher |
| Displays the backstage area that contains options for working with and managing files. | File Tab |
| =A4+B4 is an example of a(n) _______ cell reference | Relative |
| Click the _______ button in the Alignment group on the HOME tab to rotate data in a cell | Orientation |
| =A4+B$4 is an example of a(n) _______ cell reference. | Mixed |
| Use the Themes button in the Themes group on the _______ _______ tab to apply a theme to cells in a worksheet that applies formatting such as color, font, and effects. | Page Layout |
| =A4+$B$4 is an example of a(n) _______ cell reference. | Absolute |
| By default, numbers are aligned at the _______ side of a cell. | Right |
| By default, a column is inserted on the _______ side of the column containing the active cell. | Left |
| The _______ function returns the current date and time. | Now |
| The _______ function indicates the number of cells containing numbers within the list of arguments. | Count |
| The _______ function returns the smallest value in a set of values. | Min |
| The _______ function returns the largest value in a set of values. | Max |
| The _______ function returns the current date. | Today |
| Divide Symbol | / |
| Greater than Symbol | > |
| Addition Symbol | + |
| Multiply Symbol | * |
| Less than Symbol | < |
| Subtraction Symbol | - |
| The _______ function returns the arithmetic mean of the arguments. | Average |
| Use the keyboard to enter the commonly used operator symbol for addition. | + |
| Press the _______ function key to display the Excel Help window. | F1 |
| Select all cells in a row by clicking the _______ header. | Row |
| Change _______ width by dragging or double-clicking the column boundary. | Column |
| Select all cells in a worksheet by clicking the _______ _______ button located immediately to the left of the column headers. | Select All |
| Area containing the tabs with commands and buttons. | Ribbon |
| Displays the active cell address or name assigned to the active cell. | Name Box |
| Used to view various parts of the worksheet beyond the current screen. | Scroll Bars |
| Contains buttons for commonly used commands that can be executed with a single mouse click. | Quick Access Toolbar |
| Click to insert a new sheet in the workbook. | New Sheet Button |
| _______ _______ is the name of the small black square that displays in the bottom right corner of the active cell. | Fill Handle |
| With the _______ function, a ranges of cells are added together and then divided by the number of cell entries. | Average |
| Press the _______ + _______ keys on the keyboard to move the insertion point to the previous cell. | Shift & Tab |
| Data being typed in a cell displays in the cell as well as in the ________ ______ | Formula Bar |
| The _______________ feature automatically inserts words, numbers, or formulas in a series. | Auto Fill |
| The horizontal and vertical lines that define the cells in a worksheet area are referred to as this _____________. | Gridlines |
| Rows in a worksheet are labeled with these _______. | Numbers |
| Columns in a worksheet are labeled with these ________. | Letters |
| Contains the cells used to create a worksheet. | Worksheet Area |
| Press the ________ key on the keyboard to move the insertion point to the next cell. | Tab |
| Displays the current mode, action messages, view buttons, and Zoom slide bar. | Status Bar |
| When clicked, removes the ribbon from the screen. | Collapse the Ribbon Button |
| Displays the workbook name followed by the application name. | Title Bar |
| Identifies the current worksheet in the workbook. | Sheet Tab |
| Contains commands and buttons organized into groups. | Tab |
