True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
With what-if
analysis, the user inputs new data into the spreadsheet and then uses a calculator or manually
recalculates the new results.
|
|
|
2.
|
Excel
creates and updates charts based on changes made to the worksheet.
|
|
|
3.
|
A chart can
be created based on information in a worksheet.
|
|
|
4.
|
Once a
spreadsheet is created, it cannot be changed.
|
|
|
5.
|
An
electronic spreadsheet uses a computer to perform numeric calculations.
|
|
|
6.
|
Excel does
NOT automatically update a chart when worksheet data changes.
|
|
|
7.
|
In the
worksheet window, columns are identified by numbers.
|
|
|
8.
|
A cell can
contain any combination of text, numbers, or formulas.
|
|
|
9.
|
Each toolbar
button has a picture of its function on its face.
|
|
|
10.
|
In a
worksheet window, columns are labeled alphabetically.
|
|
|
11.
|
The cell
address is identified by the coordinates of the intersecting column and row.
|
|
|
12.
|
The
intersection of a row and a column is called a sheet tab.
|
|
|
13.
|
The status
bar tells you the active command or task in progress.
|
|
|
14.
|
A task pane
appears on the left-side of the screen, by default.
|
|
|
15.
|
It is a good
idea to save your work every 10-15 minutes.
|
|
|
16.
|
The only way
to move around the worksheet is to use the vertical and horizontal scroll bars.
|
|
|
17.
|
To return to
cell A1 at the top of a worksheet, press [Ctrl][Home].
|
|
|
18.
|
You can use
[Page Down] and [Page Up] to navigate a worksheet.
|
|
|
19.
|
You can use
the arrow keys (on the keyboard) to move one cell at a time in a worksheet.
|
|
|
20.
|
Use the Help
feature to get assistance using Excel.
|
|
|
21.
|
You must
exit Excel before you can use the Office Assistant.
|
|
|
22.
|
You can
press the F1 key at any time to get immediate help.
|
|
|
23.
|
There is no
difference between closing a workbook and exiting Excel.
|
|
|
24.
|
When you
have finished working on a workbook, you DO NOT need to save the file and close it.
|
|
|
25.
|
You can use
a button on the default Standard toolbar to close a workbook and exit Excel.
|
|
|
26.
|
You
can copy a worksheet by pressing [Shift] while dragging the sheet tab.
|
|
|
27.
|
Add
color to a sheet tab by clicking Edit on the menu bar, then clicking Sheet Tab Color.
|
|
|
|
|
|
28.
|
In the
figure above, item 3 points to the cell pointer.
|
|
|
29.
|
In the
figure above, item 5 points to the Calculations bar.
|
|
|
|
|
|
30.
|
The figure
above illustrates the Print Preview screen.
|
|
|
31.
|
In the
figure above, item 1 points to buttons for moving between pages.
|
|
|
32.
|
In the
figure above, item 2 points to the Zoom button, which reduces the screen image.
|
|
|
33.
|
In the
figure above, item 3 points to the Setup button, which is used to create a worksheet.
|
|
|
34.
|
In the
figure above, item 4 points to the Close button, which is used to exit Excel.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
35.
|
Excel would
NOT be used to accomplish which one of the following activities? a. | Create
charts | b. | Quickly recalculate results | c. | Perform what-if
analysis | d. | Word processing | | |
|
|
|
36.
|
Which of the
following is TRUE about Excel? a. | It automatically recalculates results | b. | New worksheets can be
created from existing ones | c. | Both a and b | d. | None of the
above | | |
|
|
|
37.
|
An
electronic spreadsheet uses a computer to perform ____. a. | Scientific
experiments | b. | Numeric calculations | c. | A grammar
check | d. | Sophisticated word processing | | |
|
|
|