Question 1 options:
semi-colon (;)
colon (:)
period (.)
none of the above
Question 2
How many chart types does Excel offer?
Question 2 options:
5
11
29
50
Question 3
In Excel, a number can contain the characters _____.
Question 3 options:
0 1 2 3 4 5 6 7 8 9
+ - ( ) , /
. $ % E e
all of the above
Question 4
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or
you can type _____.
Question 4 options:
6,000T
6K000
6Q
6E15
Question 5
What effect does the Comma Style format have on the selected cells?
Question 5 options:
Converts decimals to commas within a cell
Converts decimals to commas within merged cells
Displays cell contents with two decimal places and commas as thousands separators
Allows for substitution of selected characters
Question 6
To enter data in a cell, you must first select or activate the _____.
Question 6 options:
row
worksheet
column
cell
Question 7
Pressing the _____ key to complete an entry activates the adjacent cell to the right.
Question 7 options:
RIGHT ARROW
LEFT ARROW
UP ARROW
DOWN ARROW
Question 8
Clicking the _____ box completes an entry.
Question 8 options:
Cancel
Formula
Enter
Tab
Question 9
By default, text is _____ in a cell.
Question 9 options:
left-aligned
centered
justified
right-aligned
Question 10
The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.
Question 10 options:
selection handle
sizing handle
fill handle
copy handle
Question 11
nar005-1.jpg
In the accompanying figure, the _____ identifies the colors assigned to each bar in the chart on a worksheet.
Question 11 options:
color code
identifier
explanation
legend
Question 12
To cancel an entire entry before entering it into the cell, press the _____ key.
Question 12 options:
ALT
ESC
CTRL
TAB
Question 13
nar004-1.jpg
A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
Question 13 options:
range
bunch
nearby cell
neighbor
Question 14
What effect does the Accounting Number Format have on the selected cells?
Question 14 options:
Converts alphabetic characters to numbers
Displays cell contents with two decimal places that align vertically
Performs tax calculations
Copies the numbers of one cell to another
Question 15
The first step in creating an effective worksheet is to make sure you _____.
Question 15 options:
apply font formatting
understand what is required
insert a chart
enter the data
Question 16
Which of the following calculations multiplies 23 by 0.01?
Question 16 options:
=23%
=23
=23+.01
=24-.01
Question 17
Which of the following happens when you enter the formula =G15 into a cell?
Question 17 options:
Excel recalculates all formulas in the worksheet
Excel assigns the sum of the values in the previous 15 cells to the active cell
Excel assigns the value in cell G15 to the active cell
Nothing; =G15 is an invalid formula
Question 18
To start a new line in a cell, press the _____ keys.
Question 18 options:
CTRL+ENTER
TAB+ENTER
ALT+ENTER
SHIFT+ENTER
Question 19
To copy cell contents, you can select the cell and then press the _____ keys.
Question 19 options:
CTRL+V
CTRL+X
CTRL+B
CTRL+C
Question 20
When you enter a two-digit year that is less than 30, Excel changes the year to _____.
Question 20 options:
20xx
30xx
18xx
19xx
Question 21
Which of the following is the path to the Conditional Formatting button?
Question 21 options:
(Home tab | Editing group)
(Styles tab | Formatting group)
(Formatting tab | Styles group)
(Home tab | Styles group)
Question 22
You can select a range using the keyboard by pressing the _____ key and then an ARROW key.
Question 22 options:
F2
F4
F6
F8
Question 23
Which of the following is the path to the Spelling button?
Question 23 options:
(Home tab | Proofing group)
(Proofing tab | Spelling group)
(Review tab | Proofing group)
(Review tab | Checking group)
Question 24
All of the following are valid Excel arithmetic operators except _____.
Question 24 options:
^
*
%
>
Question 25
The adjusted cell references in a copied and pasted formula are called _____ references.
Question 25 options:
related
relative
pasted
alternative
Question 26
Which of the following is not a valid format symbol?
Question 26 options:
semi-colon (;)
percent sign (%)
dollar sign ($)
comma (,)
Question 27
_____ refers to cells not wide enough to display the entire entry.
Question 27 options:
#####
&&&&&
$$$
+++++
Question 28
Which of the following formulas contains an absolute cell reference?
Question 28 options:
=$B4
=B$4
=$B$4
=B4
Question 29
nar005-1.jpg
In the accompanying figure, the split double arrow mouse pointer _____.
Question 29 options:
indicates a hidden column
allows text to be entered at that location
is the result of moving the mouse pointer to the boundary between column heading A and column heading B
indicates the proposed width of column A
Question 30
The _____ function is useful when you want to assign a value to a cell based on a logical test.
Question 30 options:
IF
NOW
AND
OR
Question 31
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values.
Question 31 options:
logical
constant
consistent
calculated
Question 32
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the _____ error message.
Question 32 options:
#NULL!
#DIV/0!
#N/A
#REF!
Question 33
You can press the _____ keys to open the Format Cells dialog box.
Question 33 options:
CTRL+1
CTRL+2
CTRL+3
CTRL+4
Question 34
Pressing the _____ key(s) removes the marquee from the source area.
Question 34 options:
TAB
CTRL+X
CTRL+V
ESC
Question 35
Which of the following is the path to the Increase or Decrease Indent button?
Question 35 options:
(Home tab | Clipboard group)
(Home tab | Editing group)
(Home tab | Alignment group)
(Home tab | Number group)
Question 36
The _____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
Question 36 options:
MIN
SUM
AVERAGE
MAX
Question 37
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____.
Question 37 options:
40
26
48
13
Question 38
The _____ function determines the lowest number in a range.
Question 38 options:
MAX
AVERAGE
SUM
MIN
Question 39
The _____ function displays the highest value in a range.
Question 39 options:
MIN
SUM
MAX
AVERAGE
Question 40
The _____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
Question 40 options:
Comma style format
Accounting number format
Percent style format
Currency style format