A. CTRL+ENTER B. TAB+ENTER
Date:
Name:
ADVANCED MICROSOFT EXCEL CIJ..z STUDY GUIDE Multiple Choice Identtfu the choice that best completes the statement or answers the question.
1. A
is a prewritten formula that is built into Excel'
C. task D. calculation
A. function B.- feature
2. 3. 4.
keys.
To start a new line in a cell, press the
A. CTRL+ENTER B. TAB+ENTER
-.
C.
P.
ALT+ENTER SHIFT+ENTER
When you enter a two-digit year that is less than 30, Excel changes the year to 18xx
A. 2Av,x B. 30xx
C. D. 1$or
-.
Which of the following happens whenyou enter the formula:G15 into a cell? C. Excel assigns the value in cell G15 to the Excel recalculates all formulas in the active cell worksheet B. Excel assigns the sum of the values in the D. Nothing; :G15 is an invalid formula previous 15 cells to the active cell
A.
5.
Point mode allows you to _, &S shown in the accompanying figure. A. select cells for use in a formula using the C. select cells for use in a formula using the keyboard mouse pointer B. select a function from the Sum button list D. edit cell contents directly in the cell
6.
The
Options button lists error-checking options following the assignment of an invalid formula to
cell.
A. B.
Find Error Explain Error
C. D.
Fix Error Trace Error
7.
Which of the following is the path to the Sum button? A. (Editing tab I Home group) C. (Home tab I Clipboard group) B. (Home tab lEditing group) D. (Calculation tab I Editing group)
8.
You
9.
A. B.
should double-click
click
C. D.
to select the function. right-click none of the above
function displays the highest value in a range.
The
A. B.
a function name in the Formula AutoComplete list
MIN SUM
C. D.
MAX AVERAGE
a
1
I
0. 1.
t2.
To copy cell contents, you can select the cell and then press the
A. B.
CTRL+V CTRL+X
To paste copied cell contents, you can press the
CTRL+B CTRL+C
C. D.
CTRL+V CTRL+X
_
keys.
keys.
A. B.
CTRL+C CTRL+P
A
is a predefined set ofcolors, fonts, chart styles, cell styles, and C. theme scheme gallery D. style
A. B.
13. You can open
A. B.
14.
C. D.
the Format Cells dialog box by pressing the
C.
SHIFT+TAB CTRL+1
D.
fill
effects.
keys.
ALT+1 SHIFT+F1
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. A. Comma style format C. Percent style format B. Accounting number format D. Currency style format
tffYlf.i
.. ffi
'?'is}#
rliti:.*':::::]:::::
elEF',
Yr"
:l$"
#
ffi p
istr
:
4
u" --
iltf&Ehtrr,m &.1 st .e:..!
I\'"i!
L{
.:\islkr"'*t! -"''-*-t
"
lriah+ :-'l'
"&
";d ,.*
t'i
:.'ta
ws
... i 2! ; rffur" , *1ts{9"
#,'
:
',r,,**i#,iEil*==**I .t"
E
= .S*w.
t"f
S*f{l,
i
.}$,,Fm
B{ii&.*r:f$
lsey *def,s, '{sx I {*gst#, t,ax &ss}"s*$ }&$$ffis $sbl
6'*nir QY,s,r{{BS : *ury U*mne &r*s**
{c5st t*.s*$ ,*ii
If **
:t:
{8.$ '?& ..s:.
^.'..ff'
?*F ,/. ry:
fr$& '\: I E
'{*3,,
:Lt:i":SS
[$$'$."8P+. .. ..
[H:;J"J":{J;I
&j:
3:[.5 'i {'&': 4BLr;
Ji'*:
{ t -6 J: f J
iJ
1""]
?ra 'I t6
SS::sS.}t,
rdl$ry, tI 5f! J
lg aSI r rl4g a u'
t-
tH,*U *GS$ ti,;s$.$*s
*"tfi
s*t.s**, ?*d q
4 r\i:
;r,L&:tl-t\')
*,mX.AS.l
U i J:,L!fJUi'
r$...
l cil:f+
rl f.:
.:sffiffi' f {M6\
ili..t$ {-1 :iixi-lrR
A. B.
fixed formaffed
ri
f
i
,$SI:.*ISSS S,}.SS $J:Str"#I r* iji:r'iii! iirr: 'Ji| ': t?,#r}*.fR fss4,$s *=,&W-f ,affis? 1ruS $in ?5'). 1P,!$33 Fr3 ii; ? r:1.N.t'i:*.e* ,7 S*,f*
ir
u-:l*s
.$*X,l*
15. In the accompanying
S
!*.i**
,$l::l:,',+;,$.ffit"*
tup*.**rie fi
.$grr,**St
.1ft: iry,dli *r,J-)&"iY
'Ei*E
SlGt $*sS
-:r *frfl ,-r.iJ-,Li
STtr&,;}..$ .3?5"r:*?S g{ii$.&,gt$ Lgr"j:H.fS
1r:1"
sss.Bi
T:
44dt ;15*t l-fG d'S+
J;,ir;
i)!C-t
{i{&.*
rq,
$
figure, the ranges E4:I4 and F13:I13 are formatted with
C. D. J
floating none of the above
a
dollar sign.
,.^. _
16. Which of the following
A. B.
17.
is the path to the Comma Style button? (Home tab I Alignment group) C. (Home tab I Cells group) (Home tab I Font group) D. (Home tab lNumber group)
When you decrease the row height to
A.0 8.1D.3
18. Which of the following
19.
_,
the row is hidden.
c.2
is the path to the Spelling button?
A. B.
(Home tab I Proofing $oup) (Proofing tab I Spelling
A. B.
view allows you to create or modifl, a worksheet while viewing how it will look in printed format. Normal C. Page Break Preview Page Layout D. Full Screen
C. D.
group)
...
u3" *t ;;X
:rliix '1-,r
(Review tab I Proofing group) (Review tab I Checking group)
EEi*i
-. i..rrt". r
...: ...
.
&"i,r,.
!*$ tajii${*r
[&te ICE,4F*i
ffi iffirIts
$ie,Ws
t
*rS
N)&
SS.
*l{in
*F &*,
M. *$.rr.
W *ts&
S.S fu:s
I#S ffi:p &*S, N.*$
$*fi$
ribF ,:;i tlpgE*r
20.
RlM
dB 65sN5 ry3M&6SN:*&$d&IMNS
su$ *xr* q $e *ws
i$ss *ss
Fj.*!
To print a range of cells in the active worksheet, click _ in the Settings area in the Print gallery, shown in the accompanying figure. A. Print Active Sheets C. Print Entire Workbook B. Print Selection D. none of the above
as
Name:
ADVANCED MICROSOFT EXCEL CIJ..z STUDY GUIDE Multiple Choice Identtfu the choice that best completes the statement or answers the question.
1. A
is a prewritten formula that is built into Excel'
C. task D. calculation
A. function B.- feature
2. 3. 4.
keys.
To start a new line in a cell, press the
A. CTRL+ENTER B. TAB+ENTER
-.
C.
P.
ALT+ENTER SHIFT+ENTER
When you enter a two-digit year that is less than 30, Excel changes the year to 18xx
A. 2Av,x B. 30xx
C. D. 1$or
-.
Which of the following happens whenyou enter the formula:G15 into a cell? C. Excel assigns the value in cell G15 to the Excel recalculates all formulas in the active cell worksheet B. Excel assigns the sum of the values in the D. Nothing; :G15 is an invalid formula previous 15 cells to the active cell
A.
5.
Point mode allows you to _, &S shown in the accompanying figure. A. select cells for use in a formula using the C. select cells for use in a formula using the keyboard mouse pointer B. select a function from the Sum button list D. edit cell contents directly in the cell
6.
The
Options button lists error-checking options following the assignment of an invalid formula to
cell.
A. B.
Find Error Explain Error
C. D.
Fix Error Trace Error
7.
Which of the following is the path to the Sum button? A. (Editing tab I Home group) C. (Home tab I Clipboard group) B. (Home tab lEditing group) D. (Calculation tab I Editing group)
8.
You
9.
A. B.
should double-click
click
C. D.
to select the function. right-click none of the above
function displays the highest value in a range.
The
A. B.
a function name in the Formula AutoComplete list
MIN SUM
C. D.
MAX AVERAGE
a
1
I
0. 1.
t2.
To copy cell contents, you can select the cell and then press the
A. B.
CTRL+V CTRL+X
To paste copied cell contents, you can press the
CTRL+B CTRL+C
C. D.
CTRL+V CTRL+X
_
keys.
keys.
A. B.
CTRL+C CTRL+P
A
is a predefined set ofcolors, fonts, chart styles, cell styles, and C. theme scheme gallery D. style
A. B.
13. You can open
A. B.
14.
C. D.
the Format Cells dialog box by pressing the
C.
SHIFT+TAB CTRL+1
D.
fill
effects.
keys.
ALT+1 SHIFT+F1
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. A. Comma style format C. Percent style format B. Accounting number format D. Currency style format
tffYlf.i
.. ffi
'?'is}#
rliti:.*':::::]:::::
elEF',
Yr"
:l$"
#
ffi p
istr
:
4
u" --
iltf&Ehtrr,m &.1 st .e:..!
I\'"i!
L{
.:\islkr"'*t! -"''-*-t
"
lriah+ :-'l'
"&
";d ,.*
t'i
:.'ta
ws
... i 2! ; rffur" , *1ts{9"
#,'
:
',r,,**i#,iEil*==**I .t"
E
= .S*w.
t"f
S*f{l,
i
.}$,,Fm
B{ii&.*r:f$
lsey *def,s, '{sx I {*gst#, t,ax &ss}"s*$ }&$$ffis $sbl
6'*nir QY,s,r{{BS : *ury U*mne &r*s**
{c5st t*.s*$ ,*ii
If **
:t:
{8.$ '?& ..s:.
^.'..ff'
?*F ,/. ry:
fr$& '\: I E
'{*3,,
:Lt:i":SS
[$$'$."8P+. .. ..
[H:;J"J":{J;I
&j:
3:[.5 'i {'&': 4BLr;
Ji'*:
{ t -6 J: f J
iJ
1""]
?ra 'I t6
SS::sS.}t,
rdl$ry, tI 5f! J
lg aSI r rl4g a u'
t-
tH,*U *GS$ ti,;s$.$*s
*"tfi
s*t.s**, ?*d q
4 r\i:
;r,L&:tl-t\')
*,mX.AS.l
U i J:,L!fJUi'
r$...
l cil:f+
rl f.:
.:sffiffi' f {M6\
ili..t$ {-1 :iixi-lrR
A. B.
fixed formaffed
ri
f
i
,$SI:.*ISSS S,}.SS $J:Str"#I r* iji:r'iii! iirr: 'Ji| ': t?,#r}*.fR fss4,$s *=,&W-f ,affis? 1ruS $in ?5'). 1P,!$33 Fr3 ii; ? r:1.N.t'i:*.e* ,7 S*,f*
ir
u-:l*s
.$*X,l*
15. In the accompanying
S
!*.i**
,$l::l:,',+;,$.ffit"*
tup*.**rie fi
.$grr,**St
.1ft: iry,dli *r,J-)&"iY
'Ei*E
SlGt $*sS
-:r *frfl ,-r.iJ-,Li
STtr&,;}..$ .3?5"r:*?S g{ii$.&,gt$ Lgr"j:H.fS
1r:1"
sss.Bi
T:
44dt ;15*t l-fG d'S+
J;,ir;
i)!C-t
{i{&.*
rq,
$
figure, the ranges E4:I4 and F13:I13 are formatted with
C. D. J
floating none of the above
a
dollar sign.
,.^. _
16. Which of the following
A. B.
17.
is the path to the Comma Style button? (Home tab I Alignment group) C. (Home tab I Cells group) (Home tab I Font group) D. (Home tab lNumber group)
When you decrease the row height to
A.0 8.1D.3
18. Which of the following
19.
_,
the row is hidden.
c.2
is the path to the Spelling button?
A. B.
(Home tab I Proofing $oup) (Proofing tab I Spelling
A. B.
view allows you to create or modifl, a worksheet while viewing how it will look in printed format. Normal C. Page Break Preview Page Layout D. Full Screen
C. D.
group)
...
u3" *t ;;X
:rliix '1-,r
(Review tab I Proofing group) (Review tab I Checking group)
EEi*i
-. i..rrt". r
...: ...
.
&"i,r,.
!*$ tajii${*r
[&te ICE,4F*i
ffi iffirIts
$ie,Ws
t
*rS
N)&
SS.
*l{in
*F &*,
M. *$.rr.
W *ts&
S.S fu:s
I#S ffi:p &*S, N.*$
$*fi$
ribF ,:;i tlpgE*r
20.
RlM
dB 65sN5 ry3M&6SN:*&$d&IMNS
su$ *xr* q $e *ws
i$ss *ss
Fj.*!
To print a range of cells in the active worksheet, click _ in the Settings area in the Print gallery, shown in the accompanying figure. A. Print Active Sheets C. Print Entire Workbook B. Print Selection D. none of the above
as
