Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
Which
of the following is not a part of a function formula? a. | equal
sign | c. | function
name | b. | Formula
Palette | d. | argument | | | | |
|
|
|
2.
|
When
Excel starts, a blank worksheet titled ____ appears on the screen. a. | Excel1 | c. | Book1 | b. | Worksheet1 | d. | Spreadsheet1 | | | | |
|
|
|
3.
|
The
____ sign in Excel represents the action exponentiation.
|
|
|
4.
|
In
Excel, a collection of worksheets is referred to as a a. | spreadsheet. | c. | notebook. | b. | work area. | d. | workbook. | | | | |
|
|
|
5.
|
Which
of the following do you press to switch between displaying formulas and displaying
values? a. | Ctrl+> | c. | Ctrl+` | b. | Shift+# | d. | Shift+* | | | | |
|
|
|
6.
|
Which
of the following will clear data from a highlighted cell? a. | pressing the
Delete key | c. | choosing Clear
from the Edit menu | b. | pressing the Backspace key | d. | all of the above | | | | |
|
|
|
7.
|
What
is the purpose of the COUNT function? a. | It determines the number of cells in a
range. | b. | It determines the number of empty cells in a
range. | c. | It determines the number of filled cells in a
range. | d. | It determines the number of columns in a
range. | | |
|
|
|
8.
|
A
group of cells that touch each other and form a rectangle are a a. | cell. | c. | highlight. | b. | range. | d. | name box. | | | | |
|
|
|
9.
|
Which
type of cell reference adjusts to its new location when copied or moved? a. | absolute | c. | relative | b. | adapted | d. | stable | | | | |
|
|
|
10.
|
Suppose that the value in B3 is equal to 3 and the value in C3 is 4. Which of the
following formulas would display the value of 24? a. | =B3*C3+4 | c. | =B3*(C3+4) | b. | =(B3*C3)+4 | d. | =(B3*C3+4) | | | | |
|
|
|
11.
|
Which
operation will be performed first in a formula that does not contain parentheses? a. | addition | c. | multiplication | b. | exponentiation | d. | subtraction | | | | |
|
|
|
12.
|
What
term describes a cell that is ready for data entry? a. | active
cell | c. | name
box | b. | cell
reference | d. | bordered
cell | | | | |
|
|
|
13.
|
Which
tab in the Format Cells dialog box contains the options for wrapping and rotating
text? a. | Wrapping | c. | Orientation | b. | Alignment | d. | Position | | | | |
|
|
|
14.
|
Which
operator represents exponentiation?
|
|
|
15.
|
The
intersection of a worksheet column and row is a a. | cell. | c. | highlight. | b. | range. | d. | name
box. | | | | |
|
|
|
16.
|
Which
menu contains the Save As command? a. | File | c. | View | b. | Edit | d. | Window | | | | |
|
|
|
17.
|
What
happens if data are copied in cells that have existing data? a. | An error message
will appear. | b. | The old data will be placed on the
Clipboard. | c. | The new data will not be copied. | d. | The old data
will be replaced by the new data. | | |
|
|
|
18.
|
The
____ function is the most frequently used type of function formula.
|
|
|
19.
|
Which
of the following functions shows the square root of the number identified in the
argument?
|
|
|
20.
|
The
drag-and-drop method is the same for moving data as it is for copying data except you do not hold
down the ____ key. a. | Shift | c. | Alt | b. | Ctrl | d. | Insert | | | | |
|
|
|
21.
|
Suppose that the value in B3 is equal to 12 and the value in C3 is 3. Which of the
following formulas would display the value of 3? a. | =B3/C3+1 | c. | =B3/(C3+1) | b. | =(B3/C3)+1 | d. | =(B3/C3+1) | | | | |
|
|
|
22.
|
Which
of the following would you use to copy a cell’s format to another cell? a. | Format
Painter | c. | Format
Copier | b. | Conditional formatting | d. | Cell Painter | | | | |
|
|
|
23.
|
The
Page Setup dialog box has four tabbed sections. Under which tab do you designate whether the page
will be printed in portrait or landscape? a. | Page | c. | Header/Footer | b. | Margins | d. | Sheet | | | | |
|
|
|
24.
|
Which
type of cell reference does not change when it is moved or copied to a new cell? a. | absolute | c. | relative | b. | mixed | d. | stable | | | | |
|
|
|
25.
|
To
add a cell, row, or column to a worksheet, you should use commands on the ____ menu. a. | Edit | c. | File | b. | View | d. | Insert | | | | |
|
|
|
26.
|
Which
of the following occurs when a format is painted in a cell or range? a. | The data, but
not the format, of the source cell is copied to the destination cell. | b. | The format, but
not the data, of the source cell is copied to the destination cell. | c. | The format and
data of the source cell is copied to the destination cell. | d. | Color is added
to all cells that have been selected. | | |
|
|
|
27.
|
The
Page Setup dialog box has four tabbed sections. Under which tab do you designate the title of the
worksheet? a. | Page | c. | Header/Footer | b. | Margins | d. | Sheet | | | | |
|
|
|
28.
|
Data
stored on the ____ will remain until it is replaced with new data. a. | worksheet | c. | Clipboard | b. | toolbar | d. | border | | | | |
|
|
|
29.
|
Which
key would you press to remove data from the selected cell? a. | Ctrl | c. | Alt | b. | Shift + End | d. | Delete | | | | |
|
|
|
30.
|
When
data is wider than the column, Excel will display which of the following symbols in the
cell? a. | ##### | c. | &&&&& | b. | $$$$$ | d. | ***** | | | | |
|
|
|
31.
|
Which
of the following is not a method for copying data to another part of the
worksheet? a. | Drag-and-Drop | c. | Inserting | b. | Fill Down | d. | Copy and Paste | | | | |
|
|
|
32.
|
Which
menu contains the command to open the Options dialog box in which you can define features, including
those applied to formulas? a. | Window | c. | View | b. | Format | d. | Tools | | | | |
|
|
|
33.
|
The
____ button on the Formatting toolbar is represented by a bucket of paint. a. | Format
Painter | c. | Fill
Color | b. | Drawing | d. | Font Color | | | | |
|
|
|
34.
|
Frozen rows are indicated by a darkened ____ that separates the frozen and unfrozen
areas. a. | column | c. | row | b. | gridline | d. | title bar | | | | |
|
|
|
35.
|
The
____ tab in the Page Setup dialog box allows you to add or remove gridlines from your printed
worksheet. a. | Page | c. | Header/Footer | b. | Margins | d. | Sheet | | | | |
|
|
|
36.
|
Which
of the following is not a choice for aligning cell contents in Excel? a. | align
left | c. | middle | b. | align right | d. | merge and center | | | | |
|
|
|
37.
|
What
type of cell reference contains both relative and absolute references? a. | mixed | c. | dual | b. | combination | d. | double | | | | |
|
|
|
38.
|
What
are formats that have already been created within Excel called? a. | TextFormats | c. | GeneralFormats | b. | NumberFormats | d. | AutoFormats | | | | |
|
|
|
39.
|
To
move to the last cell containing data, you should press a. | Ctrl +
Home. | c. | Ctrl + Page
Up. | b. | Ctrl +
End. | d. | Ctrl + Down
Arrow. | | | | |
|
|
|
40.
|
The
____ function displays the number of cells with numerical values in the argument
range. a. | VAR | c. | MAX | b. | AVERAGE | d. | COUNT | | | | |
|
True/False
Indicate whether the sentence or statement is true
or false. Mark A for True and B for False.
|
|
|
41.
|
The
Merge and Center alignment button is commonly used to center a title across the top of a
worksheet.
|
|
|
42.
|
You
can change the type of calculation using options on the Edit tab of the Options dialog
box.
|
|
|
43.
|
The
delayed calculation feature of Excel improves the accuracy of calculations made in the worksheet by
slowing the computer speed.
|
|
|
44.
|
Rotating will move text from the right side of the cell to the left side of the
cell.
|
|
|
45.
|
In
order to change a cell’s appearance, you must first select the cell you want to
change.
|
|
|
46.
|
Fill
Right and Fill Left copies data into the cell(s) to the right or left of the original
cell.
|
|
|
47.
|
Text
in a cell may be aligned by clicking toolbar buttons or by choosing the Cells command on the Format
menu.
|
|
|
48.
|
Function formulas are special formulas that do not use operators to calculate a
result.
|
|
|
49.
|
The
Sheet tab in the Page Setup dialog box contains options for setting the print area, and printing
gridlines, row headings, and column headings.
|
|
|
50.
|
In
order to freeze a title row, place the highlight above the row you want to freeze.
|