A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.
What is Autosum?
100
A function that counts the number of blank cells in a range.
What is the Countblank function?
100
A function that determines the minimum value in a range of cells.
What is a MIN function?
100
Cells that run from top to bottom in a worksheet and are identified by letters.
What is a column?
100
Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.
What is name box?
200
A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.
What is the Average function?
200
A predefined formula that performs a calculation.
What is a function?
200
A function that totals all of the cells in a range.
What is a SUM function?
200
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
What is a command group?
200
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
What is the Quick Access toolbar?
300
A function that determines how many cells in a range contain a number.
What is the Count function?
300
A function that returns the largest value in a set of values.
What is the MAX function?
300
A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.
What is an active cell?
300
Task-oriented tabs that are organized on the ribbon.
What is command tabs?
300
A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface.
What is a ribbon?
400
Two or more cells combined into a single cell.
What are merged cells?
400
A box on the grid identified by the intersection of a column and a row.
What is a cell?
400
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
What is a row?
400
A collection of worksheets in a single file.
What is a workbook?
500
A function that returns the number of cells in the selected range that contain text or values, but not blank cells.
What is the CountA function?
500
A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.
What is backstage view?
500
The loudest person in the class?
Who is Jamesha Bracken?
500
A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.