| A | B |
| normal | Which view is the default view used in Microsoft Excel? |
| file | Which tab do you use to display the area that contains the print command? |
| exit | Which command do you use to close an open file and completely exit the Microsoft Excel program? |
| shortcut menu | What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet? |
| range | Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a: |
| cut | Which command on the "Home Ribbon" allows data to be moved from one worksheet location to another? |
| save as | Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location? |
| absolute | What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area? |
| accounting | Which quick-number style button formats numbers to display as currency in the worksheet? |
| orientation | Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet? |
| autoFit | Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem? |
| hyperlink | Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet? |
| margins | Which term describes the blank portions of a page that fall outside the main body of the printed document? |
| theme | Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance? |
| freeze Panes | John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do? |
| print Titles | Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change? |
| hide | Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose? |
| tab color | Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose? |
| move | Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose? |
| rename | Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose? |