Easy
Formulas
Breaks and Views
Lesson 3
Challenging
100
To place a copy of selected text on the Clipboard or Office Clipboard.
What is copy?
100
An equation that calculates a new value from values currently in the worksheet.
What is a formula?
100
This is a page break Excel inserts whenever it runs out of room on a page.
What is automatic page break?
100
A special Clipboard available only to Microsoft Office programs, on which you can collect up to 24 items.
What is the Office Clipboard?
100
This is a cell reference that adjusts to its new location when copied or moved.
What is relative cell reference?
200
To remove selected text and place it on the Clipboard or the Office Clipboard.
What is cut?
200
This lets you determine when Excel calculates formulas in the worksheet.
What is manual calculation?
200
This is the black square in the lower-right corner of the active cell or range that you drag over the cells you want to fill.
What is fill handle?
200
These are designated rows and/or columns in a worksheet that print on each page.
What are print titles?
200
This is a symbol that indicates what mathematical operation to perform on the numbers such as a plus sign for addition.
What is an operator?
300
This is blank space around the top, bottom, left, and right sides of a page.
What is the margin?
300
This inserts the SUM function to add long columns or rows of numbers.
What is the Sum button?
300
The worksheet view best for entering and formatting data in a worksheet.
What is normal view?
300
This keeps selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.
What are freeze panes?
300
This is the sequence used to calculate the value of a formula.
What is order of evaluation?
400
To copy an item stored on the Clipboard or the Office Clipboard to a location in a file.
What is paste?
400
This is a cell reference that does not change when copied or moved to a new cell.
What is an absolute cell reference?
400
The worksheet view for adjusting page breaks in a worksheet.
What is page break preview?
400
This means to copy a cell's contents and/or formatting into an adjacent cell or range.
What is filling?
400
In a formula, this means to click a cell rather than type its cell reference.
What is the point-and-click method?
500
Cells and ranges designated for printing.
What is the print area?
500
This is a cell reference that contains both relative and absolute references.
What is a mixed cell reference?
500
The worksheet view that shows how the worksheet will appear on the paper.
What is page layout view?
500
This means to resize a worksheet to print on a specific number of pages.
What is scale?
500
This is a constant (text or number) or cell reference used in a formula.
What is an operand?
M
e
n
u