Spreadsheet Modeling Final Exam
Questions And Answers
___tdisplaystonlytthetrowstthattmeettthetcriteriatortconditionstyoutspecifyttotlimittwhichtrecord
staretincludedtintthetresultst-tCORRECTttANSWER-filtering
____tfunctionstlooktuptatvaluetintatdefinedtrangetoftcellstlocatedtintanothertparttoftthetworkbo
okttotfindtatcorrespondingtvaluet-tCORRECTttANSWER-Lookup
____tistusedttotcontroltthettypetoftdatatortthetvaluestthattaretenteredtintotatcellt-
tCORRECTttANSWER-validationtlist
_____tistthetkeyboardtshortcutttotthetlasttcelltintthetlasttcolumntoftthetactivetareat-
tCORRECTttANSWER-Ctrlt+tEnd
At_____tintatpietcharttidentifiestthetpietslicest-tCORRECTttANSWER-Datatlabel
Atmethodttotfindtatspecifictvaluetfortatcelltbytadjustingtthetvaluetontonetothertcelltist____t-
tCORRECTttANSWER-Goaltseek
Atrangetoftcellstthattshowsthowtchangingtcertaintvaluestintyourtformulataffectstthetresultstoftt
hosetformulastandtthattmakestitteasyttotcalculatetmultipletversionstintonetoperationtistat-
tCORRECTttANSWER-Datattable
AlltoftthetfollowingtaretmethodsttotdefinetatnametfortatcelltortgrouptoftcellstEXCEPT.
a.tselecttthetrange,topentNametManager,tclicktnewtandtthenttypetthetname
b.tselecttthetrange,tclicktintthetformulatbar,tandtthenttypetthetname
c.tselecttthetrange,tclicktintthetnametbox,tandtthenttypetthetname
d.tselecttthetrange,tclicktthetdefinetnametbutton,tandtthenttypetthetnamet-
tCORRECTttANSWER-B.tselecttthetrange,tclicktintthetformulatbar,tandtthenttypetthetname
Antadvantagettotnamingtatrangetoftcellstistthattyoutcantusetthetnametintat-
tCORRECTttANSWER-formula
clickingtat_____twillttaketyouttotanothertlocationtintthetworksheet,tanothertfiletlocation,tatweb
pagetontthetinternet,torttotyourtorganization'stInternett-tCORRECTttANSWER-Hyperlink
Questions And Answers
___tdisplaystonlytthetrowstthattmeettthetcriteriatortconditionstyoutspecifyttotlimittwhichtrecord
staretincludedtintthetresultst-tCORRECTttANSWER-filtering
____tfunctionstlooktuptatvaluetintatdefinedtrangetoftcellstlocatedtintanothertparttoftthetworkbo
okttotfindtatcorrespondingtvaluet-tCORRECTttANSWER-Lookup
____tistusedttotcontroltthettypetoftdatatortthetvaluestthattaretenteredtintotatcellt-
tCORRECTttANSWER-validationtlist
_____tistthetkeyboardtshortcutttotthetlasttcelltintthetlasttcolumntoftthetactivetareat-
tCORRECTttANSWER-Ctrlt+tEnd
At_____tintatpietcharttidentifiestthetpietslicest-tCORRECTttANSWER-Datatlabel
Atmethodttotfindtatspecifictvaluetfortatcelltbytadjustingtthetvaluetontonetothertcelltist____t-
tCORRECTttANSWER-Goaltseek
Atrangetoftcellstthattshowsthowtchangingtcertaintvaluestintyourtformulataffectstthetresultstoftt
hosetformulastandtthattmakestitteasyttotcalculatetmultipletversionstintonetoperationtistat-
tCORRECTttANSWER-Datattable
AlltoftthetfollowingtaretmethodsttotdefinetatnametfortatcelltortgrouptoftcellstEXCEPT.
a.tselecttthetrange,topentNametManager,tclicktnewtandtthenttypetthetname
b.tselecttthetrange,tclicktintthetformulatbar,tandtthenttypetthetname
c.tselecttthetrange,tclicktintthetnametbox,tandtthenttypetthetname
d.tselecttthetrange,tclicktthetdefinetnametbutton,tandtthenttypetthetnamet-
tCORRECTttANSWER-B.tselecttthetrange,tclicktintthetformulatbar,tandtthenttypetthetname
Antadvantagettotnamingtatrangetoftcellstistthattyoutcantusetthetnametintat-
tCORRECTttANSWER-formula
clickingtat_____twillttaketyouttotanothertlocationtintthetworksheet,tanothertfiletlocation,tatweb
pagetontthetinternet,torttotyourtorganization'stInternett-tCORRECTttANSWER-Hyperlink
