Unit 2 Lesson 1
Where would you click to specify the folder in which this workbook should be stored?
B
Which of the following steps lets you calculate the total of the numbers in cells C1 through C10?
Click cell C11 and choose Formulas>Function Library>AutoSum.
A worksheet cell cannot contain letters.
FALSE
Scroll bars let you move up and down in a worksheet, but not to the right and left.
FALSE
The primary purpose of spreadsheet software is to let users create documents such as business letters.
FALSE
When you print a workbook, you always must print every one of its worksheets.
FALSE
Worksheets can contain several workbooks.
FALSE
Which cells are used in calculating the results of "=SUM(G14:G18)"?
G14 through G18
If you want to permanently store your workbook so that you can modify it again at a later time, choose ____.
Office> save as
If you want to create a workbook from scratch, choose ____.
Office>New
Which of the following steps lets you create a new folder?
Open the Save As dialog box and click the New Folder button.
The ____ contains a command that lets you minimize the Ribbon.
QAT
The following is the ____.
QAT
Which of the following contains the Undo button?
QAT
The Help button is located on the ____.
Ribbon
If you want to learn how to use a particular built-in formula, you can enter that formula's name the Help
Search
If you want to quickly see what percentage of zoom the screen is at, look at the ____.
Status bar
A synonym for the verb "to illustrate" is "to show."
TRUE
A worksheet can contain data such as numbers and formulas.
TRUE
If you want to display a worksheet named Fourth Quarter Sales on the screen, click that worksheet's tab
TRUE
One reason that Excel is so popular is its accuracy when performing calculations.
TRUE
You can undo multiple actions by clicking the Undo button multiple times.
TRUE
When you choose Office>Open, ____.
a dialog box appears
Another name for a worksheet is a ____.
b. spreadsheet
If you want a worksheet to take up the entire screen, which of these buttons would you click?
blue square with twohorozontalwhite lines
When you first start Excel, what is the name of the workbook that appears?
book 1
Worksheets are made up of boxes called ____.
cells
You can exit the Excel program by ____.
choosing Office>Exit Excel
The individual buttons on a tab are also called ____.
commands
The formula ____ will add together the contents of cells A5 through A8.
d. =SUM(A5:A8)
You can print a worksheet by choosing ____.
d. Office>Print
To see a greater amount of a worksheet on your screen at one time, you can ____.
decrease zoom precentage
If the last row you can see on your screen is row 26 and you want to see row 27, click ____.
down arrow
Which of the following is a Dialog Box Launcher?
expand toll button
As you key data into a cell, the data appears both in the cell itself and in the ____.
formula bar
Which of the following buttons would you click to add together a row of numbers?
greek letter
Which of the following could you use to find instructions on how to use the Open command?
help feature
To access the Font Color button, click the ____ tab.
home
How must the pointer appear before you can increase the width of a column?
line with arrow
If you want to see the formula stored in a specific cell, click the cell and then ____.
look in the formula bar
This screen shows the ____.
office menu
Which of the following is not a tab on the Excel Ribbon?
Which of the following buttons closes Print Preview?
red x button
If you have chosen Undo by mistake, you can bring back your previous action by choosing ____.
redo
A worksheet's row heads ____.
run down the left edge of the worksheet
Label "A" is pointing to the ____.
select all button
The Open dialog box lets you ____.
specify the name of the workbook to be opened
Which of the following is a reason you might want to minimize the Ribbon?
specify the name of the workbook to be opened
By default, a new workbook contains how many worksheets?
three
The Zoom command is located on the ____ tab.
view
