Excel Review Questions
Answer the following questions on your own paper. If possible, also type your responses in an email to me.
My email address is:
Bring your hard-copy answers to class.
1) Excel provides the tools to create which type of documents?
a) letters
b) presentations
c) workbooks
d) emails
2) The tools to edit the workbook are located on the ______.
3) What is the procedure to launch Excel from the Windows desktop? (answer may include more than one)
a) Right-click the desktop and choose New, Microsoft Excel Worksheet.
b) Click the Start charm in the bottom left corner of the Windows 8 screen, right-click a blank area, select All apps, and click Excel 2013.
c) Click the Start button.
d) Click the Excel icon on the Windows taskbar.
e) Right-click a blank area, select All apps, and click Excel 2013.
4) Use the ______option for quick access to the Excel application from the Windows desktop.
5) Which toolbar is located in the upper left corner of the Excel window?
a) Charting
b) Quick Access
c) Page Setup
d) Printing
6) When you add ribbon commands to the Quick Access Toolbar, right-click the command and choose ______.
7) The Quick Access Toolbar can be moved ______. (answer may include more than one)
a) below the ribbon
b) to the bottom of the window
c) above the ribbon
d) to the right side of the window
e) into the ribbon
f) to the left of the window
8) Which key is used to display keyboard shortcuts (Keytips) on the ribbon?
a) Ctrl
b) Shift
c) Tab
d) Alt
9) The commands on each ribbon tab are organized into logical command ______.
a) rows
b) icons
c) groups
d) sizes
10) If you cannot find the command you need while working in the ribbon, where can you click to find more options?
a) the Group title at the bottom of the ribbon group
b) the File tab on the left side of the ribbon
c) the Options arrow in the bottom right corner of the group
d) the Help icon in the upper right corner above the ribbon
11) Which view shows the options to open, save, print, and manage your Excel file?
a) Print Preview
b) Page Layout
c) Backstage
d) Normal
12) How many worksheets are included in a new blank workbook?
a) 1
b) 3
c) 6
d) 10
13) A/An ______is the name of a box in a worksheet at the intersection of a row and column in which information is typed.
14) A/An ______, where you can type information, is outlined by a bold rectangle in your worksheet.
15) A ______displays descriptive text when you rest the pointer on a command or control in Excel.
16) In the Workbook Views group, click ______to display the active worksheet without rulers, headers, footers, or page breaks.
17) A ______is an Excel file made up of one or more worksheets.
18) Use the ______on the bottom right side of the Quick Access Toolbar to add additional commands.
19) To increase workspace you can ______so that only the tabs display at the top of the screen.
20) In order to see additional customization options, select ______from the Quick Access Toolbar drop-down list to display the Excel Options dialog box.
21) The ______command enables you to view large worksheets in two panes or four quadrants.
22) The ______command on the View tab in the Workbook Views group opens windows side by side to compare sections of a large worksheet.
23) The Close command on the File tab closes ______.
24) The ______tab contains the Open command.
25) What starts at the top of each worksheet, goes to the bottom, and is identified by a letter?
a) row
b) column
c) cell
d) range