Spreadsheet Modeling Test Questions And Answers

Spreadsheet Modeling Test Questions
And Answers
AbsolutetCelltReferencingt-tCORRECTttANSWER-
Keepingtcelltreferencestfromtchangingtistachievedtusingtabsolutetcelltreferencing.tThetsynt
axtExceltusesttotindicatetthattatcelltreferencetistabsolutetistatdollartsignt($).tThetdollartsigntca
ntbetplacedtbeforetthetcolumntletter,tthetrowtnumber,tortboth.tOnlytincludet$twhentnecessary
.

AccountingtNumbertFormatt-tCORRECTttANSWER-
atformattthattdisplaystthetdollartsignt($)tattthetlefttedgetoftthetcell,tinsertstthetcommatseparato
rtiftneeded,tandtdisplaysttwotdecimaltplacestwithtthetvaluestalignedtontthetdecimaltpoint.tCan
tbetaccessedtbytHOMEttabt->tNumbertgroup




Alertt-tCORRECTttANSWER-Thettriangletintthetupper-
lefttcornertoftthetcelltistantalert.tIftyoutselecttthistcell,tthetErrortAlerttbuttontappearst.tClickingt
thistbuttontdisplaystatmenutwithtinformationtregardingtwhattthetproblemtmighttbetandthowtitt
mighttbetresolved.

Algorithmt-tCORRECTttANSWER-
Atsettoftrulestthatthavetbeentprogrammedtintotatparticulartfunction

AnalyticstProcesst-tCORRECTttANSWER-1.tGathertUnstructuredtData
2.tDatatManagement/Modeling
3.tPerformtAnalytics
4.tDescribe,tDiagnose,tPredict,tPrescribet***

Argumentst-tCORRECTttANSWER-
Syntaxtthattcreatetrequiredtinputstintatspecifictorderttotcalltuptatfunction

, AutoSumt-tCORRECTttANSWER-
ExceltinsertstthetSUMtfunction,tprecededtbytantequaltsign,tandtsuggeststatrangetoftcellsttotin
cludetintthetcalculation,tbasedtontrowstortcolumnstoftnumberstnearestttotthetselectedtcell.

CharttTypest-tCORRECTttANSWER-SeetTablet3.1

CommatStyletButtont-tCORRECTttANSWER-TotChangetthetNumbertFormat

COUNTIFtfunctiont-tCORRECTttANSWER-
countstthetnumbertoftitemstintatrangetthattmeettspecifiedtcriteria.

COUNTIF(range,criteria)

Thetrangetargumenttmusttbetatcontiguoustsettoftcellstdowntatcolumn
Thetcriteriatargumenttistessentiallytattesttthattthetdatatmusttmeettintordertfortitttotbetcountedti
ntthetgrouping.

ExamplestoftCriteriatParameterstallowed
COUNTIF(A1:A100,t24)
COUNTIF(A1:A100,t"Dog")
COUNTIF(A1:A100,tTRUE)
COUNTIF(A1:A100,tB12)
COUNTIF(A1:A100,t">10")
COUNTIF(A1:A100,t"??31?3")tThetquestiontmarktwildcardt(?)tspecifiestthattatsingletcharac
tertcantbetsubstituted.
COUNTIF(A1:A100,t"*a??")tThetasterisktwildcardt(*)tspecifiestthattanytnumbertoftcharacter
stcantbetsubstituted.


WhentworkingtwithtNoncontiguoustRanges,tyoutcantjusttaddttwotCOUNTIFtstatements

CreatingtCustomtHeader/Footert-tCORRECTttANSWER-PagetLayouttButton,tor
VIEWttabt->tPagetLayouttViewtButton
INSERTttabt->tHeadert&tFootertButton

DatatMarkerst-tCORRECTttANSWER-
atdatatmarkertistatgraphicaltrepresentationtoftdatatintatdatatseriestoftatchart.

Datest(Numerictvaluetformat)t-tCORRECTttANSWER-
ExceltstorestdatestastsequentialtnumberstbeginningtwithtJanuaryt1,t1900.tBecausetdatesth
avetatnumerictvalue,tyoutcantperformtcalculationstontcellstcontainingtdates.tTimetoftdaytistst
oredtbytdecimaltfractions.t(0.1tistonettenthtoftat24hrtday)

NotetthattyoutcannottentertatdatetdirectlytintatformulatbecausetExceltinterpretstthetdatetastatc
alculation.tFortexample,tiftthetformulat=1/10/2017+10tweretenteredtintatcell,tExceltwouldtinte