Spreadsheet Modeling Final Exam Questions And Answers

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