Spreadsheet Modeling Exam 1
Questions And Answers
3tcomponentstoftBAt-tCORRECTttANSWER-DescriptivetAnalytics
PredictivetAnalytics
PrescriptivetAnalytics
3tcomponentstoftDSSt-tCORRECTttANSWER-DatatManagement
Modeltmanagement
CommunicationtSystem
3ttypestoftinputstintatDecisiontModelt-tCORRECTttANSWER-Data
UncontrollabletVariables
DecisiontVariables
AbsolutetReferencet-tCORRECTttANSWER-
Usestthetdollartsigntbeforeteithertthetrowtortcolumntlabeltortbotht$A$4
Algorithmt-tCORRECTttANSWER-Atsystematictproceduretthattfindstatsolutionttotatproblem
ANDtFunctiont-tCORRECTttANSWER-
AtlogicaltfunctiontthattreturnstTRUEtiftalltconditionstarettruetandtFALSEtiftnot
BigtDatat-tCORRECTttANSWER-
Thetmassivetamountstoftbusinesstdatatfromtatwidetvarietytoftsources,tmuchtoftwhichtistavail
abletintrealttime,tandtmuchtoftwhichtistuncertaintandtunpredictable
BigtDatatcharacteristicstbytIBMt(4)t-tCORRECTttANSWER-Volume
Variety
Velocity
Veracity
Branchest-tCORRECTttANSWER-Arrowstontantinfluencetdiagram
BusinesstAnalyticst-tCORRECTttANSWER-
Thetusetoftdata,tinformationttechnology,tstatisticaltanalysis,tquantitativetmethods,tandtmath
ematicaltortcomputer-
basedtmodelsttothelptmanagerstgaintimprovedtinsighttaboutttheirtbusinesstoperationstandt
maketbettertfact-
, basedtdecisions.t"Thetprocesstofttransformingtdatatintotactionstthroughtanalysistandtinsight
stintthetcontexttoftorganizationaltdecisiontmakingtandtproblem-solbing.
BusinesstIntelligencet-tCORRECTttANSWER-
Thetcollection,tmanagement,tanalysistandtreportingtoftdata,tattermtcoinedtbytIBMtresearche
rtLuhn.tBItcantanswertsimpletquestions.
CategoricaltDatat-tCORRECTttANSWER-
Sortedtintotcategoriest(manager,tsupervisor,tassociate).tCouldtalsotsorttbytregion
CommonttypestoftdecisionstbasedtontBAt(4)t-tCORRECTttANSWER-Pricing
CustomertSegmentation
Merchandising
Location
CommunicationtSystemt-tCORRECTttANSWER-
Providestthetinterfacetnecessarytfortthetuserttotinteracttwithtthetdatatandtmodeltmanagemen
ttcomponents
Continuoustmetrict-tCORRECTttANSWER-
Basedtontatcontinuoustscaletoftatmeasurement.tAnythingtwithtdollars,tlength,ttime,tvolumeto
rtweight
Datat-tCORRECTttANSWER-
Numericaltfactstandtfigurestthattaretcollectedtthroughtsomettypetoftmeasurementtprocess
Datatcantbetcategorizedtintot4tgroupst-tCORRECTttANSWER-Categorical
Ordinal
Interval
Ratio
DatatintDecisiontModelst-tCORRECTttANSWER-Constant
DatatManagementt-tCORRECTttANSWER-
Includestdatabasestfortstoringtdatatandtallowstthetuserttotinput,tretrieve,tupdatetandtmanipul
atetdata
DatatMiningt-tCORRECTttANSWER-
Bettertunderstandingtcharacteristicstandtpatternstamongtvariablestintlargetdatabasestusing
tatvarietytoftstatisticaltandtanalyticalttools
DatatSett-tCORRECTttANSWER-Atcollectiontoftdata
Databaset-tCORRECTttANSWER-
Atcollectiontoftrelatedtfilestcontainingtrecordstontpeople,tplaces,tortthingst(entities)
Questions And Answers
3tcomponentstoftBAt-tCORRECTttANSWER-DescriptivetAnalytics
PredictivetAnalytics
PrescriptivetAnalytics
3tcomponentstoftDSSt-tCORRECTttANSWER-DatatManagement
Modeltmanagement
CommunicationtSystem
3ttypestoftinputstintatDecisiontModelt-tCORRECTttANSWER-Data
UncontrollabletVariables
DecisiontVariables
AbsolutetReferencet-tCORRECTttANSWER-
Usestthetdollartsigntbeforeteithertthetrowtortcolumntlabeltortbotht$A$4
Algorithmt-tCORRECTttANSWER-Atsystematictproceduretthattfindstatsolutionttotatproblem
ANDtFunctiont-tCORRECTttANSWER-
AtlogicaltfunctiontthattreturnstTRUEtiftalltconditionstarettruetandtFALSEtiftnot
BigtDatat-tCORRECTttANSWER-
Thetmassivetamountstoftbusinesstdatatfromtatwidetvarietytoftsources,tmuchtoftwhichtistavail
abletintrealttime,tandtmuchtoftwhichtistuncertaintandtunpredictable
BigtDatatcharacteristicstbytIBMt(4)t-tCORRECTttANSWER-Volume
Variety
Velocity
Veracity
Branchest-tCORRECTttANSWER-Arrowstontantinfluencetdiagram
BusinesstAnalyticst-tCORRECTttANSWER-
Thetusetoftdata,tinformationttechnology,tstatisticaltanalysis,tquantitativetmethods,tandtmath
ematicaltortcomputer-
basedtmodelsttothelptmanagerstgaintimprovedtinsighttaboutttheirtbusinesstoperationstandt
maketbettertfact-
, basedtdecisions.t"Thetprocesstofttransformingtdatatintotactionstthroughtanalysistandtinsight
stintthetcontexttoftorganizationaltdecisiontmakingtandtproblem-solbing.
BusinesstIntelligencet-tCORRECTttANSWER-
Thetcollection,tmanagement,tanalysistandtreportingtoftdata,tattermtcoinedtbytIBMtresearche
rtLuhn.tBItcantanswertsimpletquestions.
CategoricaltDatat-tCORRECTttANSWER-
Sortedtintotcategoriest(manager,tsupervisor,tassociate).tCouldtalsotsorttbytregion
CommonttypestoftdecisionstbasedtontBAt(4)t-tCORRECTttANSWER-Pricing
CustomertSegmentation
Merchandising
Location
CommunicationtSystemt-tCORRECTttANSWER-
Providestthetinterfacetnecessarytfortthetuserttotinteracttwithtthetdatatandtmodeltmanagemen
ttcomponents
Continuoustmetrict-tCORRECTttANSWER-
Basedtontatcontinuoustscaletoftatmeasurement.tAnythingtwithtdollars,tlength,ttime,tvolumeto
rtweight
Datat-tCORRECTttANSWER-
Numericaltfactstandtfigurestthattaretcollectedtthroughtsomettypetoftmeasurementtprocess
Datatcantbetcategorizedtintot4tgroupst-tCORRECTttANSWER-Categorical
Ordinal
Interval
Ratio
DatatintDecisiontModelst-tCORRECTttANSWER-Constant
DatatManagementt-tCORRECTttANSWER-
Includestdatabasestfortstoringtdatatandtallowstthetuserttotinput,tretrieve,tupdatetandtmanipul
atetdata
DatatMiningt-tCORRECTttANSWER-
Bettertunderstandingtcharacteristicstandtpatternstamongtvariablestintlargetdatabasestusing
tatvarietytoftstatisticaltandtanalyticalttools
DatatSett-tCORRECTttANSWER-Atcollectiontoftdata
Databaset-tCORRECTttANSWER-
Atcollectiontoftrelatedtfilestcontainingtrecordstontpeople,tplaces,tortthingst(entities)
