The meeting point between computer software and the person using it.
What is a user interface?
100
The cell you are working in; the cell where information or data will be input.
What is an active cell?
100
Page orientation is wider than it is long, resembling a landscape scene.
What is landscape orientation?
100
Every formula must begin with this symbol.
What is the equal sign (=)?
100
The function that adds or sums numeric entries within a range of cells and then displays the result in the cell containing the function.
What is the Sum function?
200
A memory location that holds up to 24 items for you to paste into the current document, another file, or another application.
What is the clipboard?
200
The intersection of a column and row designated by a column letter and a row number
What is a cell reference?
200
A user should use this feature before printing to view the margins and layout of a worksheet.
What is print preview?
200
A cell reference that stays the same no matter where you copy a formula.
What is absolute cell referencing?
200
The function that determines the arithmetic mean, or average, for the values in a range of cells.
What is the AVERAGE function?
300
The process of making a duplicate copy of the text or object leaving the original intact.
What is the copy method?
300
A single spreadsheet consisting of columns and rows that may contain formulas, functions, values, text, and graphics.
What is a worksheet?
300
By pressing this key combination, a worksheet displays the actual formulas rather than the results of formulas.
What is the Ctrl + ~?
300
A cell reference that changes relative to the direction in which the formula is being copied.
What is relative referencing?
300
The function that is a date-related function that places the current date in a cell.
What is the TODAY function?
400
The operation that transfers the content of a cell or cell range from one location in the worksheet to another with the cells where the move originated becoming empty.
What is the move command?
400
A collection of related worksheets contained within a single file.
What is a workbook?
400
By selecting this option before printing, lines appear around each cell when the worksheet contents are printed.
What are gridlines?
400
small black solid square in the bottom-right corner of a selected cell. It is used to duplicate formulas.
What is the Fill Handle?
400
The table that Excel searches using a lookup function.
What is a lookup table?
500
This command is used to save a workbook with a new filename or in a new location.
What is Save As command?
500
Feature that enables you to copy existing text formats to other text to ensure consistency.
What is format painter?
500
By selecting this option before printing, the column letters and row numbers appear when the worksheet contents are printed.
What are row/column headings?
500
The combination of constants, cell references, arithmetic operations, and/or functions displayed in a calculation that produce a calculated result.
What is a formula?
500
Calculates a periodic loan payment given a constant interest rate, term, and original value.