Exam 2 spreadsheets for business
Questions And Answers
atcelltwithtatformulatthattwilltbetsolvedtfortspecifictresultstistcalledtant-tCORRECTttANSWER-
objectivetcell
atcollectiontofttablestandtqueriestintatworkbooktistcalledtat-tCORRECTttANSWER-
datatmodel
atcolumntcharttthattillustratestthetfrequencytofteachtdatatpointtintatdatatsettistcalledtant-
tCORRECTttANSWER-histogram
atCOMtadd-
intthattenablestyouttotusetmillionstoftrecordstintthetdatatmodeltfortatpivottabletistant-
tCORRECTttANSWER-powertpivot
atforecasttsheettcalculatest-tCORRECTttANSWER-futuretvalues
atforecasttsheettinsertstfunctionstintotitsttablestfromtwhichtfunctiontcategoryt-
tCORRECTttANSWER-...
atforecasttsheettinsertstfunctionstintotitsttablestfromtwhichtfunctiontcategoryt-
tCORRECTttANSWER-statistical
atgeneratedtworksheettthattdisplaystvaluestfortchangingtandtresulttcellstforteachtscenariotint
atworkbooktistcalledtant-tCORRECTttANSWER-scenariotsummarytreport
atproblem-
solvingtmethodtthattstartstwithtatresulttandtcalculatestthetvaluettotreachtthattresulttist-
tCORRECTttANSWER-backsolving
atrangetoftcellstthattshowtcalculatedtresultstoftonetortmoretformulastistcalledt-
tCORRECTttANSWER-atdatattable
Questions And Answers
atcelltwithtatformulatthattwilltbetsolvedtfortspecifictresultstistcalledtant-tCORRECTttANSWER-
objectivetcell
atcollectiontofttablestandtqueriestintatworkbooktistcalledtat-tCORRECTttANSWER-
datatmodel
atcolumntcharttthattillustratestthetfrequencytofteachtdatatpointtintatdatatsettistcalledtant-
tCORRECTttANSWER-histogram
atCOMtadd-
intthattenablestyouttotusetmillionstoftrecordstintthetdatatmodeltfortatpivottabletistant-
tCORRECTttANSWER-powertpivot
atforecasttsheettcalculatest-tCORRECTttANSWER-futuretvalues
atforecasttsheettinsertstfunctionstintotitsttablestfromtwhichtfunctiontcategoryt-
tCORRECTttANSWER-...
atforecasttsheettinsertstfunctionstintotitsttablestfromtwhichtfunctiontcategoryt-
tCORRECTttANSWER-statistical
atgeneratedtworksheettthattdisplaystvaluestfortchangingtandtresulttcellstforteachtscenariotint
atworkbooktistcalledtant-tCORRECTttANSWER-scenariotsummarytreport
atproblem-
solvingtmethodtthattstartstwithtatresulttandtcalculatestthetvaluettotreachtthattresulttist-
tCORRECTttANSWER-backsolving
atrangetoftcellstthattshowtcalculatedtresultstoftonetortmoretformulastistcalledt-
tCORRECTttANSWER-atdatattable