| A | B |
|---|
| A function performs a calculation that results in | a single value |
| A cell reference that does not change when it is copied is called | absolute cell reference |
| Which key can be used to create an absolute cell reference | F4 |
| To enter a function into a formula without typing | click a button in the Function Library group on the Formulas tab |
| Which error value indicates the formula is trying to divide by zero | #DIV/0! |
| Which error value indicates the formula contains a reference that is not valid | #REF |
| How many arguments does the IF function have | 3 |
| Printing a worksheet in landscape orientation | fits more columns and fewer rows on a page |
| What can be used to control how a worksheet is divided into pages | page breaks |
| Page Layout->Print Area->Set Print Area is used to | print a selected part of a worksheet |
| To make a sheet active, | click the appropriate tab at the bottom of the Excel window |
| Sheet order can be changed by | dragging a sheet tab to a new location |
| Changing the data on one sheet automatically updates the data on the other sheet when the cells are | linked |
| Which key removes the dashed border around copied cells? | the Esc key |
| greater than sign | > |
| less than or equal to sign | <= |
| equal to sign | = |
| not equal to | <> |
| less than sign | < |
| greater than or equal to sign | >= |
