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