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 | | |
|
|
|
38.
|
The document
you produce when you use Excel is a ____. a. | Database | b. | Worksheet | c. | Slide show presentation | d. | Publication | | |
|
|
|
39.
|
A
decision-making feature of Excel is the ____. a. | What-if analysis | b. | Office
Assistant | c. | Ask-me analysis | d. | None of the
above | | |
|
|
|
40.
|
If an Excel
user wants to use data from someone else's worksheet, he/she can ____. a. | Use another person's
files on a network | b. | Use another person's files by obtaining a
disk | c. | Both a and
b | d. | Cannot use another
person's Excel files | | |
|
|
|
41.
|
Which of the
following is NOT an example of Excel's versatility? a. | Proprietary
authorship | b. | Creating charts | c. | Sharing
information | d. | What-if analysis | | |
|
|
|
42.
|
Spreadsheets
are commonly used in business to ____. a. | Organize data | b. | Analyze
data | c. | Represent values
visually | d. | All the above | | |
|
|
|
43.
|
If you don't
see a Microsoft Excel icon in the All Programs menu, what should you do? a. | Look for a group called
Microsoft Programs. | b. | Telephone Microsoft Office Help. | c. | Consult your instructor
or a technical support person. | d. | Restart your computer. | | |
|
|
|
44.
|
The
intersection of a row and a column is called a ____. a. | Title | b. | Cell | c. | Formula | d. | Tab | | |
|
|
|
45.
|
Buttons for
frequently used Excel commands that perform actions within the worksheet are located on the
____. a. | Status
bar | b. | Menu
bar | c. | Standard
toolbar | d. | Sheet tabs | | |
|
|
|
46.
|
A cell can
contain ____. a. | Numbers | b. | Text | c. | Formulas | d. | All the above | | |
|
|
|
47.
|
The area of
the worksheet window that contains the menus from which you choose Excel commands is called the
____. a. | Name
box | b. | Menu
bar | c. | Formula
bar | d. | Status
bar | | |
|
|
|
48.
|
The area of
the worksheet window that displays the active cell address is called the ____. a. | Name
box | b. | Main menu
bar | c. | Formula
bar | d. | Toolbar | | |
|
|
|
49.
|
The dark
rectangle that highlights the cell you are working in is called the ____. a. | Cell
surrounder | b. | Cell pointer | c. | Activator | d. | Formula bar | | |
|
|
|
50.
|
Excel groups
worksheets together and calls them a ____. a. | Binder | b. | Workbook | c. | Notebook | d. | Folder | | |
|
|
|
51.
|
The status
bar tells you ____. a. | The number of pages in your workbook | b. | The active command or
task in progress | c. | Which Windows program is currently running | d. | The status of your
disk | | |
|
|
|
52.
|
The cell
address is identified by ____. a. | Its sheet tab | b. | Its location on the
status bar | c. | The coordinates of the intersecting column and
row | d. | Its location on the
cell pointer | | |
|
|
|
53.
|
The cell you
are working in is called the ____. a. | Active cell | b. | Status cell | c. | Menu cell | d. | Worksheet cell | | |
|
|
|
54.
|
Cells
contain all the following EXCEPT ____. a. | Text | b. | Numbers | c. | Formulas | d. | Online Help | | |
|
|
|
55.
|
You can move
from sheet to sheet by clicking the ____. a. | Sheet tab scrolling buttons | b. | Sheet button
toolbar | c. | Status bar twice | d. | Name
box | | |
|
|
|
56.
|
Worksheet
data can be entered and edited in the ____. a. | Formula bar | b. | Sheet tab | c. | Menu bar | d. | Title bar | | |
|
|
|
57.
|
Which of the
following is NOT an example of an Excel cell address?
|
|
|
|
|
|
58.
|
In the figure above, item 1 points to the ____. a. | Menu
bar | b. | Standard
toolbar | c. | Name box | d. | Status bar | | |
|
|
|
59.
|
When a cell
contains both text and numbers, Excel recognizes the entry as a ____. a. | Value | b. | Label | c. | Formula | d. | Figure | | |
|
|
|
60.
|
Labels are
used in a worksheet ____. a. | To identify the data in the rows | b. | To identify the data in
the columns | c. | To make it understandable | d. | All the
above | | |
|
|
|
61.
|
Using the
arrow keys on the keyboard is one way to ____. a. | Reposition a cell | b. | Navigate a
worksheet | c. | Edit worksheet data | d. | None of the
above | | |
|
|
|
62.
|
To move to a
particular cell in the worksheet, ____. a. | Click the desired cell | b. | Press
[Esc.] | c. | Key the cell address | d. | None of the
above | | |
|
|
|
63.
|
Which of the
following methods can be used to navigate a worksheet? a. | Click the desired cell
address. | b. | Use the Go To command. | c. | Press the arrow keys
until the desired cell is active. | d. | All the above | | |
|
|
|
64.
|
Which of the
following is NOT a method of navigating the worksheet? a. | Press
[Ctrl][Home]. | b. | Click the Formatting toolbar. | c. | Press [Page
Up]. | d. | Press [Page
Down]. | | |
|
|
|
65.
|
In Print
Preview, you can make the image of a page larger by clicking the ____. a. | Sheet
display | b. | Zoom button | c. | Mouse pointer | d. | Sheet
button | | |
|
|
|
66.
|
Excel
features an extensive ____ system that gives you immediate access to definitions, explanations, and
useful tips. a. | Referral | b. | Phone | c. | Help | d. | None of the above | | |
|
|
|
67.
|
The Office
Assistant provides ____. a. | Information using a question and answer
format | b. | Tips indicated by a light bulb you can click | c. | Both a and
b | d. | None of the
above | | |
|
|
|
68.
|
To exit
Excel, ____. a. | Click Exit on the File
menu | b. | Click Exit on the Edit
menu | c. | Click Close on the File
menu | d. | Click Close on the Edit
menu | | |
|
Completion
Complete each sentence or
statement.
|
|
|
69.
|
A(n)
____________________ is another name for an electronic spreadsheet.
|
|
|
70.
|
Using a
worksheet to calculate the possible effects of a change in revenues is an example of a
____________________ analysis.
|
|
|
71.
|
A collection
of worksheets is called a(n) ____________________.
|
|
|
72.
|
The cell
____________________ is identified by the coordinates of the intersecting column and
row.
|
|
|
73.
|
The name of
an open worksheet appears in the ____________________ bar of the worksheet.
|
|
|
74.
|
The active
cell address appears in the ____________________ box.
|
|
|
75.
|
Worksheet
information, such as a description of the active commands, is located on the ____________________
bar.
|
|
|
76.
|
The program
name appears in the ____________________ bar.
|
|
|
77.
|
The
____________________ toolbar contains buttons for the most common commands used for improving a
worksheet's appearance.
|
|
|
78.
|
The cell
____________________ highlights the active cell.
|
|
|
79.
|
The
____________________ cell is the cell in which you are currently working.
|
|
|
80.
|
Buttons for
the most frequently used Excel operation commands are located on the ____________________
toolbar.
|
|
|
81.
|
____________________ tabs below the worksheet grid enable you to keep your work in a
collection called a workbook.
|
|
|
82.
|
The
____________________ bar allows you to enter or edit data in the worksheet.
|
|
|
83.
|
____________________ contain buttons for the most frequently used Excel
commands.
|
|
|
84.
|
The
intersection of a row and a column is called a(n) ____________________.
|
|
|
85.
|
Every cell
has its own unique location or cell ____________________.
|
|
|
|
|
|
86.
|
In the
figure above, item 4 points to the ____________________ cell.
|
|
|
87.
|
You can
create a new folder from within the ____________________ dialog box.
|
|
|
88.
|
Labels are
____________________-aligned by default.
|
|
|
89.
|
Numbers,
formulas, and functions used in calculations are called ____________________.
|
|
|
90.
|
A(n)
____________________ consists of two or more adjacent selected cells.
|
|
|
91.
|
Values are
____________________-aligned by default.
|
|
|
92.
|
To return to
cell A1 in the worksheet, press [Ctrl][____________________] on the keyboard.
|
|
|
|
|
|
93.
|
In the
figure above, item 5 points to the ____________________ pointer in the Print Preview
window.
|
|
|
94.
|
Click the
Microsoft Excel Help button to display the Help ____________________.
|
|
|
95.
|
Click the
_________________________ in the Help task pane to find topics related to your query.
|
|
|
|
|
|
96.
|
In the
figure above, item 3 is pointing to the list of available ____________________
programs.
|
|
|
97.
|
In the
figure above, item 2 points to the ____________________ button.
|