True/False
Indicate whether the sentence or statement is true
or false.
|
|
1.
|
A
workbook is different from a spreadsheet.
|
|
2.
|
A
spreadsheet is a grid of rows and columns containing only numbers.
|
|
3.
|
When
data is too wide to fit in a cell, the part that does not fit will be deleted.
|
|
4.
|
To
remove cell data, you can simply press the Delete key.
|
|
5.
|
The
AutoCheck feature automatically corrects common typing mistakes as you enter text.
|
|
6.
|
You
can use multiple fonts in one document.
|
|
7.
|
By
default, Excel aligns text at the right of the cell and numbers at the left of the
cell.
|
|
8.
|
All
cells in a range touch each other and form a rectangle.
|
|
9.
|
Dates
are automatically formatted in the default style dd-mm-yy.
|
|
10.
|
When
you insert or delete a column or a row in Excel, it affects the entire worksheet.
|
|
11.
|
If
you undo an action and then change your mind, you cannot reverse the undo action.
|
|
12.
|
If
you undo an action from the Undo list, Excel will also undo all actions listed above it on the
list.
|
|
13.
|
You
can delete more than one row or column at a time.
|
|
14.
|
When
you delete the contents of a cell using the Delete or Backspace keys, the formats for the cell remain
in the cell.
|
|
15.
|
Text
in an Excel spreadsheet automatically wraps within the cell.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
16.
|
In
the Excel worksheet, the mouse pointer displays as a(n) ____. a. | pointer
finger | c. | thick plus
sign | b. | arrow | d. | crosshair | | | | |
|
|
17.
|
Columns are identified by ____. a. | numbers | c. | column names | b. | field
names | d. | letters | | | | |
|
|
18.
|
The
intersection of a single row and a single column is called a ____. a. | cell | c. | field | b. | cell reference | d. | frame | | | | |
|
|
19.
|
In
Excel, a heavy black border designates the ____. a. | main cell | c. | default cell | b. | active
cell | d. | cell
reference | | | | |
|
|
20.
|
The
____ feature corrects common mistakes as you enter data. a. | AutoCorrect | c. | AutoComplete | b. | AutoFill | d. | AutoCheck | | | | |
|
|
21.
|
The
____ tab in the Format Cells dialog box offers options for outlining a cell or range of
cells. a. | Patterns | c. | Border | b. | Gridline | d. | Alignment | | | | |
|
|
22.
|
The
____ feature compares the first few characters you key in a cell with existing entries in the same
column. If the characters match an existing entry, Excel proposes the existing
entry. a. | AutoCorrect | c. | AutoComplete | b. | AutoFill | d. | AutoCheck | | | | |
|
|
23.
|
When
the data is too wide for the cell, Excel ____. a. | displays a series of number signs
(####) | b. | allows the data to run outside of the
column | c. | cuts off the data displayed | d. | all of the
above | | |
|
|
24.
|
To
change the column width, you can ____. a. | open the Format menu, choose Column, and then choose AutoFit
Selection | b. | drag the right edge of the column
heading | c. | open the Format menu, choose Column, and then choose
Width | d. | all of the above | | |
|
|
25.
|
When
you add a new column, the data shifts to the ____. a. | left | c. | top | b. | right | d. | bottom | | | | |
|
|
26.
|
____
is a quick way to copy identical values to a series of adjacent cells. a. | Filling | c. | AutoInsert | b. | AutoCell | d. | Insert | | | | |
|
|
27.
|
To
move the insertion point to the last cell with data in a row, you would ____. a. | press Ctrl +
right arrow | c. | triple-click | b. | press F5 | d. | either a or b | | | | |
|
|
28.
|
If
you choose not to enter data you have keyed, you can ____. a. | click the Cancel
button in the Formula Bar | b. | press the Esc key | c. | click the No
Data button on the Standard toolbar | d. | either a or b | | |
|
|
29.
|
The
default unit of measurement for row height in Excel is ____. a. | centimeters | c. | pixels | b. | inches | d. | points | | | | |
|
|
30.
|
To
select an entire row, you would ____. a. | click the Select Row button on the Standard
toolbar | b. | double-click in any cell in the row | c. | click the row
number at the left of the screen | d. | press Ctrl + right arrow | | |
|
Completion
Complete each sentence or
statement.
|
|
31.
|
In
Excel, the small square in the bottom-right corner of the selected cell is called the
____________________.
|
|
32.
|
To
remove both the contents and the formats, you must ____________________ the cell.
|
|
33.
|
The
____________________ identifies the column letter and row number.
|
|
34.
|
The
selected cell where you can enter data is called the ____________________ cell.
|
|
35.
|
____________________ in a worksheet are identified by numbers.
|
|
36.
|
When
you enter data in a cell in a worksheet, it also appears in the ____________________
Bar.
|
|
37.
|
A(n)
____________________ may contain several worksheets.
|
|
38.
|
To
accept an entry proposed by Excels AutoComplete feature, you press the ____________________
key.
|
|
39.
|
To
allow Excel to find the best column width for the data in the column, choose the
_________________________ option from the Column submenu on the Format menu.
|
|
40.
|
When
you copy data in a worksheet, you temporarily store it on the ____________________ before you paste
it in another location.
|
|
41.
|
To
quickly fill data down in a column, click in the destination cell and press the shortcut key
combination ____________________.
|
|
42.
|
To
change the color of the type font in a cell, click the ____________________ button on the Formatting
toolbar.
|
|
43.
|
You
access the ____________________ tab in the Format Cells dialog box to add a shading pattern to
selected cells.
|
|
44.
|
To
display numbers with a currency format, you select the ____________________ tab in the Format Cells
dialog box.
|
|
45.
|
A
selected group of cells is called a(n) ____________________.
|
|
46.
|
You
can use the ___________________ to copy the format of a worksheet cell without copying the
contents.
|
|
47.
|
The
default view of an Excel worksheet is a magnification of ____________________ percent.
|
|
48.
|
There
is a limit of ____________________ actions you can undo and redo.
|
|
49.
|
When
you open Excel, a new worksheet appears named ____________________.
|
|
50.
|
A(n)
____________________ is used to gather, organize, and summarize text and numeric data.
|