Spreadsheet for Business Modeling Questions And Answers

Spreadsheet for Business Modeling
Questions And Answers
Albatwantsttotusetatwatermarktimagetastatbackgroundtofthertworksheet.tShetgoesttotpagetse
tuptgrouptontpagetlayoutttab.tWhattoptiontshouldtshetclickttotbegintchoosingtthetimagetfilettot
usetastwatermark?t-tCORRECTttANSWER-Background

Currencytistantexampletoftatnumbertformatt-tCORRECTttANSWER-True

Howtcantyoutdistinguishtfromtatmanuallytaddedtpagetbreaktandtantautomatictpagetbreaktint
atworksheet?t-tCORRECTttANSWER-
Automatictpagetbreaktappearstastdashedtlinestwhiletmanualtpagetbreakstappeartastsolidtlin
es

Totapplytformatsttotdatatwhentittmeetstcriteriatyoutspecify,tyoutusetconditionaltformattingt-
tCORRECTttANSWER-True




Totchangetthetcolortoftcelltcontent,tyoutusetthet______tcolortlisttarrowt-
tCORRECTttANSWER-Font




Totformattatrangetsotthattalltvaluestgreatertthant$500tappeartintred,twhichtoftthetfollowingtca
ntyoutuse?t-tCORRECTttANSWER-conditionaltformatting

Totpastetatdatatrangetsotthattcolumntdatatappearstintrowstandtrowtdatatappearstintcolumn,ty
outcant_____tthetdatatthetpastetlinktarrowt-tCORRECTttANSWER-transpose

Totprinttatworksheet,tyoutbegintbytgoingttotbackstagetviewt-tCORRECTttANSWER-True

Totrotatetcelltcontentstyoutusetthetalignmentttabtintthetformattcellstdialogtboxt-
tCORRECTttANSWER-True




Whentyoutcopytcelltcontents,tthetdatatistremovedtfromtitstoriginaltlocationtandtplacedtintthetC
lipboard?t-tCORRECTttANSWER-False