| Flap 1 | Flap 2 |
| What action temporarily removes a row or column from the workbook screen? | hiding |
| Frozen rows are indicated by a darkened ____ that separates the frozen and unfrozen areas. | gridline |
| The Page Setup dialog box has four tabbed sections. Under which tab do you designate whether the page will be printed in portrait or landscape orientation? | Page |
| The Page Setup dialog box has four tabbed sections. Under which tab can you designate the title of the worksheet? | Sheet |
| Under which tab in the Page Setup dialog box can you add or remove gridlines from your printed worksheet? | Sheet |
| Which is not an order by which a range of data may be sorted? | cell size |
| To prevent Excel from including the column headings in the sort, select the ____ button in the Sort dialog box. | Header row |
| What operation displays a subset of the data in a worksheet that meet certain criteria? | AutoFilter |
| Which worksheet operation is used to display the 10 largest items in a worksheet column? | AutoFilter |
| Which function determines the payment needed each period to repay a loan? | PMT |
| To go to a named range, press the ____ key, click the range name in the Go to box, and click OK. | F5 |
| The formula =MIN(Range1)+MIN(Range2) will | add the lowest number in Range 1 to the lowest number in Range 2. |
| A ____ identifies a range instead of its cell references (such as B2:B8). | range name |
| A ____ searches a large range for data that meets a specific criterion. | lookup table |
| The formula =SUM(B2:B12)-MIN(B2:B12) | subtracts the lowest number in B2:B12 from the sum of the values in values in B2:B12. |
| To resize a picture, you must select it and then drag one of its sizing ____________________. | handles |
| ____________________ are a collection of fonts, patterns, and alignments that can be applied to a range of data. | AutoFormats |
| The ____________________ tab in the Page Setup dialog box contains page orientation options. | Page |
| Text printed at the top of each page is known as a(n) ____________________. | header |
| The ____________________ tab in the Page Setup dialog box contains options for setting the print area, plus printing gridlines, row headings, and column headings. | Sheet |
| To alter margins, choose Page Setup on the File menu and then click the ____________________ tab. | Margins |
| To print the gridlines, choose Page Setup on the File menu and then click the ____________________ tab | Sheet |
| To set the area to be printed, choose Page Setup on the File menu and then click the ____________________ tab. | Sheet |
| To access the Sort dialog box, you must open the ____________________ menu. | Data |
| A(n) ____________________ is a message that explains or identifies information contained in the cell. | cell comment |
| To find and replace data in a spreadsheet, choose ____________________ on the Edit menu. | (blank) |
| To find and replace formats in a spreadsheet, choose Replace in the Edit menu and then click the ____________________ button. | Options |
| ____________________ functions find cell contents so that they may be used in another part of the worksheet. | Lookup |
| Application of a font, border, style, or color to a cell or range when the contents meet certain criteria is called a(n) ____________________ format. | conditional |
| ____________________ analysis anticipates other alternatives by changing the original conditions of a spreadsheet solution. | What if |
