True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
You can only have one Excel workbook open at a time.
|
|
|
2.
|
Usually the top row of a worksheet is used for explanatory text or column
headings that identify the type of data in each column.
|
|
|
3.
|
The arrow keys move the insertion point one cell in any direction.
|
|
|
4.
|
When you insert or delete a row or a column in Excel, it affects the entire
worksheet.
|
|
|
5.
|
Using AutoFill is not as fast as copying and pasting.
|
|
|
6.
|
All cells in a range touch each other and form a rectangle.
|
|
|
7.
|
Computer software engineer is one of the fastest growing occupations.
|
|
|
8.
|
When a cell is selected, the column and row headings for the selected cell are
highlighted.
|
|
|
9.
|
When you add a new row, the data shifts up a row.
|
|
|
10.
|
Copying data saves you from having to enter the same data into another
location.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
Excel refers to a spreadsheet as a ____.
a. | spreadsheet | c. | workbook | b. | worksheet | d. | range |
|
|
|
12.
|
____ of the worksheet appear vertically and are identified by letters at the top
of the worksheet window.
a. | Columns | c. | Cells | b. | Rows | d. | Headings |
|
|
|
13.
|
A1 and B4 are examples of ____.
a. | column headings | c. | cell references | b. | row headings | d. | ranges |
|
|
|
14.
|
When a cell is selected, it is called the ____.
a. | worksheet | c. | active cell | b. | range | d. | cell reference |
|
|
|
15.
|
The Name box shows the ____.
a. | cell contents | c. | status bar | b. | active cell | d. | formula bar |
|
|
|
16.
|
Which view separates the column and row labels from the worksheet cells?
a. | Normal | c. | Page Break Preview | b. | Page Layout | d. | Full Screen |
|
|
|
17.
|
The ____ shows the cell contents.
a. | status bar | c. | cell reference | b. | Name box | d. | formula bar |
|
|
|
18.
|
If you enter hte, which feature will automatically change the text to
the?
a. | AutoComplete | c. | AutoCorrect | b. | ScreenTip | d. | AutoFill |
|
|
|
19.
|
The Undo and Redo commands are available on the ____.
a. | status bar | c. | formula bar | b. | Quick Access Toolbar | d. | Data tab |
|
|
|
20.
|
A ____ is identified by the cell in the upper-left corner and the cell in the
lower-right corner, separated by a colon.
a. | worksheet | c. | value | b. | cell reference | d. | range |
|
|
|
21.
|
Press the ____ key to move the insertion point to the first cell in a
row.
a. | Page Up | c. | Page Down | b. | Home | d. | Tab |
|
|
|
22.
|
Which view hides the Ribbon, the formula bar, and the status bar?
a. | Normal | c. | Page Break Preview | b. | Page Layout | d. | Full Screen |
|
|
|
23.
|
A1:D4 is an example of a ____.
a. | cell reference | c. | column heading | b. | range | d. | row heading |
|
|
|
24.
|
When using the AutoComplete feature, you can press ____ to accept a proposed
entry.
a. | Home | c. | Enter | b. | Delete | d. | Tab |
|
|
|
25.
|
Where are the zoom controls located?
a. | Quick Access Toolbar | c. | Formula bar | b. | Upper right corner of the document
window | d. | status
bar |
|
|
|
26.
|
When you enter text in a cell, it also appears in the ____.
a. | status bar | c. | row heading | b. | formula bar | d. | name box |
|
|
|
27.
|
Where are the sizing buttons that control the application and worksheet
windows?
a. | Lower left corner of the status bar | c. | Upper left corner of the
window | b. | Lower right corner of the status bar | d. | Upper right corner of the
window |
|
|
|
28.
|
The Ribbon, tabs, and command groups are part of the ____.
a. | Quick Access Toolbar | c. | Microsoft Office Fluent user interface | b. | Excel document
window | d. | formula
bar |
|
|
|
FIGURE 17-1 
|
|
|
29.
|
The arrows in Figure 17-1 above are pointing to ____.
a. | active cells | c. | Ribbon tabs | b. | cell references | d. | worksheet tabs |
|
|
|
FIGURE 17-2 
|
|
|
30.
|
What is the arrow pointing to in Figure 17-2 above?
a. | Cancel, Enter, and Insert Function buttons | c. | Status bar | b. | Quick Access
Toolbar | d. | Formula
bar |
|
|
|
Case 17-1
Kristin is new to spreadsheets. She was asked to create a
worksheet for her business club’s fundraiser.
|
|
|
31.
|
Kristin is entering data in cells. Why does she see ### in some of the
cells?
a. | She entered more numbers than can fit in the cell | c. | She entered eight numbers in the
cell | b. | She entered text instead of numbers in the cell | d. | She entered too few numbers in the
cell |
|
|
|
32.
|
Kristin wants to insert three new columns. What should she do before executing
the Insert Sheet Columns command?
a. | Select one column | c. | Select three columns | b. | Select two columns | d. | She doesn’t need to select any
columns |
|
|
|
Case 17-2
Lino is creating a project schedule for the construction
company where he works. He needs to list the tasks that need to be completed each day and show which
employees will complete the work.
|
|
|
33.
|
Which feature can Lino use to quickly fill in a series of dates?
a. | AutoCorrect | c. | ScreenTip | b. | AutoComplete | d. | AutoFill |
|
|
|
34.
|
What should Lino click to select an entire column so that he can change its
formatting?
a. | Row heading | c. | Range | b. | Column heading | d. | Formula bar |
|
Matching
|
|
|
Identify the letter of the choice that best
matches the phrase or definition.
a. | AutoFill | b. | AutoComplete | c. | AutoCorrect | d. | AutoFit Column
Width | e. | Marquee |
|
|
|
35.
|
Compares the first few characters you enter in a cell with existing entries in
the same column.
|
|
|
36.
|
Adjusts the column width automatically to fit the cell with the most
content.
|
|
|
37.
|
Enables you to repeat the same data in a column or row.
|
|
|
38.
|
An animated border that appears around the selected cell.
|
|
|
39.
|
Corrects common mistakes as you enter data.
|