5 Written Questions

1. an Excel file containing one or more related worksheets
2. a window that contains a set of options for one or more Excel commands
3. displays the data the user has entered into the active cell
4. an element of an Excel worksheet that is created by the intersection of a row and column
5. used to classify similar commands that perform related tasks on each tab. The name of each group is displayed across the bottom of the group

5 Matching Questions

1. ribbon
2. excel help
3. live preview
4. shortcut keys
5. tabs

1. a allow the user to activate a command using specified keys on the keyboard rather than pressing the command button on the Ribbon or a toolbar
2. b provides the user with assistance on how to work in Excel and how to use Excel features and functions
3. c the area above an Excel worksheet that contains all of the Excel commands, which allow users to perform tasks as they work with data in Excel
4. d used to organize the commands by category on the Ribbon. The default tabs displayed on the Ribbon in Excel are: File, Home, Insert, Page Layout, Formulas, Data, Review, and View
5. e a special Excel feature that allows the user to move the mouse pointer over an option and see the effect it would have on the worksheet before selecting that option

5 Multiple Choice Questions

1. is located at the very bottom of the Excel workbook, indicates what mode you are in, provides summary information about selected cells containing data, allows you to change the view of your worksheet, and provides zoom options
   1. dialog box
   2. tabs
   3. formula bar
   4. status bar
2. dialog box containing all of the options available for formatting cells in an Excel worksheet
   1. dialog box
   2. format painter
   3. format cells dialog box
   4. formula bar
3. light blue lines on an Excel worksheet that show users the boundaries for each cell
   1. groups
   2. ribbon
   3. gridlines
   4. gallery
4. pops up when you right-click on a cell in an Excel worksheet and contains the command buttons for several commonly used formatting commands to reduce mouse movement
   1. dialog box
   2. number
   3. mini toolbar
   4. status bar
5. displays the cell address of the active cell or the name of a selected cell or range of cells that has been named
   1. number
   2. ribbon
   3. dialog box
   4. name box

5 True/False Questions

1. currency → number formatting option used for monetary values to line up the currency symbols and decimal points, with the currency symbols displayed just to the left of the monetary value in each cell

   True        False

2. dialog box launcher → a window that contains a set of options for one or more Excel commands

   True        False

3. active cell → the cell that is currently selected on an Excel worksheet. The active cell has a dark black border around it

   True        False

4. quick access toolbar → pops up when you right-click on a cell in an Excel worksheet and contains the command buttons for several commonly used formatting commands to reduce mouse movement

   True        False

5. excel worksheet → a single spreadsheet in an Excel workbook that can be used to display various types of data and/or graphics

   True        False