| Question |
Answer |
| 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 |