| A | B |
|---|
| The horizontal and vertical lines that define the cells in a worksheet area are referred as this. | Gridlines |
| Columns in a worksheet are labeled with these. | Letters |
| Rows in a worksheet are labeled with these. | Numbers |
| Press this key on the keyboard to move the insertion point to the next cell. | Tab |
| Press these 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 this location. | Formula Bar |
| If a number entered in a cell is too long to fit inside the cell, the number is changed to this. | Hash Tags, Number Signs, Pound Signs, ##### |
| This feature automatically inserts words, numbers, or formulas in a series. | Auto Fill |
| This is the name of the small black square that displays in the bottom right corner of the active cell. | Fill Handle |
| Use this button in the Editing group on the HOME tab to find the total or average of data in columns or rows. | Auto Sum |
| With this function, a range of cells are added together and then divided by the number of cell entries. | Average, AVG |
| To select nonadjacent columns using the mouse, hold down this key on the keyboard while clicking the column headers. | Ctrl, Control |
| Click this button to merge selected cells and center data within the merged cells. | Merge & Center |
| The Accounting Number Format button is located in this group on the HOME tab. | Number |
| Press this function key to display the Excel help window. | F1 |
| When typing a formula, begin the formula with this sign. | Equal Sign, = |
| This is the operator for division that is used when writing a formula. | Forward Slash, / |
| This is the operator for multiplication that is used when writing a formula. | Asterisk, * |
| This is the operator for subtraction that is used when writing a formula. | Dash, - |
| This is the operator for addition that is used when writing a formula. | Plus, + |
| =B6+D9 is an example of what sort of cell reference? | Relative |
| =B6+D$9 is an example of what sort of cell reference? | Mixed |
| =B6+$D$9 is an example of what sort of cell reference? | Absolute |
| You can select all cells in a row by clicking this header. | Row |
| You can select all cells in a column by clicking this header. | Column |
| This function returns the smallest value in a set of values. | Minimum, MIN |
| You can change this width by dragging or double-clicking the column boundary. | Column |
| Select all cells in a worksheet by clicking this button located immediately to the left of the column headers. | Select All |
| This function returns the largest value in a set of values. | Maximum, MAX |
| This function returns the current date and time. | Now |
| This function returns the current date. | TODAY |
| This function indicates the number of cells containing numbers within the list of arguments. | COUNT |
| To identify an absolute cell reference, type this symbol before the column and row. | Dollar Sign, $ |
| Use this button in the Alignment group on the Home tab to rotate data in a cell. | Orientation |
| Do you have the option of printing Excel with gridlines on and/or off? | Yes |
| By default, a column is inserted on this side of the column containing the active cell. | Left |
| The Themes button is located on this tab. | Page Layout |
| By default, numbers are aligned at this side of a cell. | Right |
| You can display up to this many decimal places in Microsoft Excel. | 30 |
| You can name a workbook file name with this many characters in Microsoft Excel. | 255 |
| Can you sort data by color in Microsoft Excel? | Yes |
| If you type a number with a dollar sign, such as $34.87, Excel will apply what type of number formatting? | Currency |
| Is it possible to create various charts such as Bar, Column, Pie, Line, And Bubble charts in Microsoft Excel? | Yes |
| Identifies the current worksheet in the workbook. | Sheet Tab |
| Displays the active cell address or name assigned to the active cell. | Name Box |
| Contains buttons for commonly used commands that can be executed with a single mouse click. | Quick Access Toolbar |
| When clicked, removes the ribbon from the screen. | Collapse the Ribbon Button |
| Displays the workbook name followed by the application name. | Title Bar |
| Click to open a dialog box with more options for that group. | Dialog Box Launcher |
| Contains the cells used to create a worksheet. | Worksheet Area |
| Displays the contents stored in the active cell. | Formula Bar |
| Click to insert a new sheet in the workbook. | New Sheet Button |
| Area containing the tabs with commands and buttons. | Ribbon |
| Location in the worksheet that will display typed data or that will be affected by a command. | Active Cell |
| Display the backstage area that contains options for working with and managing files. | File Tab |
| When this icon appears, select cells by clicking or dragging the mouse. | Cell Pointer |
| Contains commands and buttons organized into groups. | Tab |
| Used to view various parts of the worksheet beyond the current screen. | Scroll Bars |
| Displays the current mode, action messages, view buttons, and Zoom slide bar. | Status Bar |
