advanced microsoft excel ch.3 multtple choice
Name:
ADVANCED MICROSOFT EXCEL CH.3 MULTTPLE CHOICE Multiple Choice Identifu the choice that best completes the statement or answers the question.
1.
The
fill
handle can be used to do which of the following?
a. Copy A Cell b. Copy A Range Of Cells 2.
Which of the following will decrease the indent by three spaces each time you click it?
a. b. 3.
Decrease Indent Button
c. d.
Format Cell Format Line
Office Clipboard Document Of Choice
c. d.
Destination Area
All Of The Above
Which of the following is a valid format symbol?
a. b. 5.
Increase Indent Button
The Copy button copies the contents and format of the source area to the
a. b. 4.
c. Create A Series Of Numbers Or Dates d. All Of The Above
c. d.
Comma Percent Sign
Excel displays the error
message
a. !*REF@ b. ######## 6. A cell reference of $B17 is a(n) _
a. b.
Absolute Relative
Dollar Sign
All Of The Above
in those cells that indicate a cell reference elror.
c. d.
#ERROR #REF!
cell reference.
c. d.
Mixed Invalid
,-. _
7
.
If you assign the value 42 to cell E5, the value
1 1 to cell F5, and cell G5 contains the function :IF(E5>4*F5,uoDeductions","No deductions"), then cell G5 displays the message,
_.
a. Deductions b. No Deductions 8.
Excel displays error messages that begin with
a.# b.
'&
9.
c. #REF! d. F5 _
to indicate when there is an eror.
c.! d. Error
Which of the following specifies an invalid intersection of two areas?
a. b.
#INTER! #NULL!
c. d.
!*ERROR*!
IINVAL#
10. If you know the result you want a formula to produce, you
can use
_
on which the formula depends.
a. b.
Goal Seeking
If Then Analysis
c. Assumption d. Offsetting
Tables
to determine the value a cell
ADVANCED MICROSOFT EXCEL CH.3 MULTTPLE CHOICE Multiple Choice Identifu the choice that best completes the statement or answers the question.
1.
The
fill
handle can be used to do which of the following?
a. Copy A Cell b. Copy A Range Of Cells 2.
Which of the following will decrease the indent by three spaces each time you click it?
a. b. 3.
Decrease Indent Button
c. d.
Format Cell Format Line
Office Clipboard Document Of Choice
c. d.
Destination Area
All Of The Above
Which of the following is a valid format symbol?
a. b. 5.
Increase Indent Button
The Copy button copies the contents and format of the source area to the
a. b. 4.
c. Create A Series Of Numbers Or Dates d. All Of The Above
c. d.
Comma Percent Sign
Excel displays the error
message
a. !*REF@ b. ######## 6. A cell reference of $B17 is a(n) _
a. b.
Absolute Relative
Dollar Sign
All Of The Above
in those cells that indicate a cell reference elror.
c. d.
#ERROR #REF!
cell reference.
c. d.
Mixed Invalid
,-. _
7
.
If you assign the value 42 to cell E5, the value
1 1 to cell F5, and cell G5 contains the function :IF(E5>4*F5,uoDeductions","No deductions"), then cell G5 displays the message,
_.
a. Deductions b. No Deductions 8.
Excel displays error messages that begin with
a.# b.
'&
9.
c. #REF! d. F5 _
to indicate when there is an eror.
c.! d. Error
Which of the following specifies an invalid intersection of two areas?
a. b.
#INTER! #NULL!
c. d.
!*ERROR*!
IINVAL#
10. If you know the result you want a formula to produce, you
can use
_
on which the formula depends.
a. b.
Goal Seeking
If Then Analysis
c. Assumption d. Offsetting
Tables
to determine the value a cell
