Spreadsheet modeling for business decisions Questions And Answers

Spreadsheet modeling for business
decisions Questions And Answers
____tistthetamounttaddedttotthetprinicpaltoftatloantbytthetlendert-tCORRECTttANSWER-
Interest

"AZ"tistantexampletoftat____.t-tCORRECTttANSWER-columntheading

=ROUND(AVERAGE(A1:A100),2)tistantexampletofta(n)t____tfunctiont-
tCORRECTttANSWER-nested




Atconditionaltformattcantmaketnegativetnumberstredtandtpositivetnumberstblack.t-
tCORRECTttANSWER-true




Atdatat____ttabletdescribestthetfieldstyoutplanttotmaintaintintattable.t-tCORRECTttANSWER-
definition

Atmixedtreferencet"locks"tonetparttoftthetcelltreferencetwhiletthetothertparttcantchanget-
tCORRECTttANSWER-true




Atpietslicetistatdatatmarkertthattrepresentst____tfromtatdatatseriest-tCORRECTttANSWER-
onlytonetvalue

Atthemetistatcollectiontoftformattingtoptionstthattincludetatspecifiedtfont,tfonttsize,tfonttstyles,t
fonttcolor,tfilltcolor,tandtborders.t-tCORRECTttANSWER-false

Attrial-and-
errortmethodtletstyoutexploretthetimpacttthattchangingtinputtvaluesthastontthetcalculatedtval
uestintthetworkbookt-tCORRECTttANSWER-false

AnterrortvaluetindicatestthattsometparttoftatfunctiontistpreventingtExceltfromtreturningtatcalcu
latedtvalue.t-tCORRECTttANSWER-false

AntExceltformulatalwaystbeginstwithta(n)t____.
parenthesest-tCORRECTttANSWER-equalstsign

, Bytdefault,tExceltinsertstatcharttastantembeddedtchartt-tCORRECTttANSWER-true

Bytdefault,tExceltsetstthetpagetmarginsttot0.5tontthetlefttandtrighttmarginstandt0.75tontthettopt
andtbottomtmargin.t-tCORRECTttANSWER-false

Calculatedtvaluesttootlargettotfittintotthetcelltaretdisplayedtintscientifictnotation.t-
tCORRECTttANSWER-true




Caset2-1
Haroldthastbeentworkingtastatrealtestatetagent.tHethastatlottofthousingtdatattotreporttandtnee
dsthelptorganizingthistdatatsheettfortanteffectivetpresentation.


Haroldtneedsttotformattseveraltcellstwitht11pttCalibritfont,ttwotdecimaltplaces,tright-
aligned,tandtatbluetfonttcolor.tThetmosttefficienttwayttotaccomplishtthistwouldtbettot_____.t-
tCORRECTttANSWER-usetformattpainter




Changingtthetnumbertoftdecimaltplacestdisplayedtintatcelltdoestnottchangetthetvaluetstoredti
ntthetcellt-tCORRECTttANSWER-true

Eachtheadertandtfooterthastthreetsections—
atlefttsection,tatcentertsection,tandtatrighttsection.t-tCORRECTttANSWER-true

Eachtslicetintatpietcharttrepresentstatsingletvaluetfromtatdatatseriest-tCORRECTttANSWER-
True

Ellentistatrecenttcollegetgraduate.tShethastdecidedttotopentatT-
ShirttbusinesstandtwouldtlikettotcreatetbudgettworksheettusingtMicrosofttExcelt2016.tShetne
edttotkeepttracktofthertexpensestandtincometfortthetyear.


EllentopenstExcelt2016tandtentersthertmonthlytincometfortonetyeartbeginningtwithtJanuary.t
Totcreatetatseriestoftmonths,tshetcant____.t-tCORRECTttANSWER-
TypetJanuarytintcelltA1tandtthentdragtthetfillthandle

Ellentistatrecenttcollegetgraduate.tShethastdecidedttotopentatT-
ShirttbusinesstandtwouldtlikettotcreatetbudgettworksheettusingtMicrosofttExcelt2016.tShetne
edttotkeepttracktofthertexpensestandtincometfortthetyear.


Ellentwantsttotfindtouttwhatthertmediantmonthlytspendingtis.tThetmonthlyttotalstforthertspend
ingtappeartintthetrangetA10:L10.tWhichtoftthetfollowingtistNOTtatwayttotentertthetMEDIANtfu
nctiontintothertdatabase?t-tCORRECTttANSWER-
SelecttthetrangetA10:L10,tclicktthetQuicktAnalysistbutton,tclicktTOTALS,tandtthentclicktMedi
an.