Microsoft Excel Lesson 1
Which of the following is a Dialog Box Launcher?
A
Which of the following could you use to find instructions on how to use the Open command?
A Help feature
If you want to learn how to use a particular built-in formula, you can enter that formula's name the Help
A Search
The individual buttons on a tab are also called ____.
A commands
To access the Font Color button, click the ____ tab.
A home
If you want to see the formula stored in a specific cell, click the cell and then ____.
A look in the formula bar
Which of the following is not a tab on the Excel Ribbon?
A print
If you want a worksheet to take up the entire screen, which of these buttons would you click
B
The ____ contains a command that lets you minimize the Ribbon.
B QAT
Which of the following buttons would you click to add together a row of numbers?
B auto sum
Worksheets are made up of boxes called ____.
B cells
Which of the following steps lets you calculate the total of the numbers in cells c1 through c10?
B click c11 and choose Formulas>Function Library>AutoSum.
To see a greater amount of a worksheet on your screen at one time, you can ____.
B decrease zoom
If the last row you can see on your screen is row 26 and you want to see row 27, click ____.
B down arrow
The Open dialog box lets you ____.
B specify the name of the workbook to be opened
Another name for a worksheet is a ____.
B spread sheet
If you want to quickly see what percentage of zoom the screen is at, look at the ____.
B status bar
By default, a new workbook contains how many worksheets?
C 3
When you first start Excel, what is the name of the workbook that appears?
C Book1
If you want to create a workbook from scratch, choose ____.
C Office>New
The following is the ____.
C QAT
Which of the following contains the Undo button?
C QAT
When you choose Office>Open, ____.
C a dialog box appears
You can exit the Excel program by ____.
C choosing Office>Exit Excel
Which of the following steps lets you create a new folder?
C open the save as dialod box and click the new folder button
A worksheet's row heads ____.
C run down the left edge of the worksheet
Which of the following is a reason you might want to minimize the Ribbon?
C to allow more room for a worksheet to be displayed
The formula ____ will add together the contents of cells A5 through A8
D =SUM(A5:A8)
Which cells are used in calculating the results of "=SUM(G14:G18)"?
D G14 through G18
You can print a worksheet by choosing ____.
D Office-Print
If you have chosen Undo by mistake, you can bring back your previous action by choosing ____.
D Redo
The Help button is located on the ____.
D Ribbon
The Zoom command is located on the ____ tab.
D View
Which of the following buttons closes Print Preview?
D X
How must the pointer appear before you can increase the width of a column?
D double sided arrow
As you key data into a cell, the data appears both in the cell itself and in the ____.
D formula bar
This screen shows the ____.
D left arrow
Label "A" is pointing to the ____.
DSelect All button
A worksheet cell cannot contain letters
F
Scroll bars let you move up and down in a worksheet, but not to the right and left.
F
The primary purpose of spreadsheet software is to let users create documents such as business letters.
F
When you print a workbook, you always must print every one of its worksheets
F
Worksheets can contain several workbooks.
F
A synonym for the verb "to illustrate" is "to show."
T
A worksheet can contain data such as numbers and formulas.
T
If you want to display a worksheet named Fourth Quarter Sales on the screen, click that worksheet's tab.
T
One reason that Excel is so popular is its accuracy when performing calculations.
T
You can undo multiple actions by clicking the Undo button multiple times.
T
If you want to permanently store your workbook so that you can modify it again at a later time, choose ____.
office- save as