CRASH COURSE RETAKE EXAM ANSWER SHEET 48/48
Allkofkthekfollowingkarekkeyboardkshortcutkthatkallowkthekuserkinputktokaddkmoreksheetsk
tokakworkbookkEXCEPT:k-kCORRECTkANSWER-Altkhkikw
Whatkiskakkeyboardkshortcutktokopenkakfile?`k-kCORRECTkANSWER-Ctrlko
WhatkiskthekrecommendedkworkbookkcalculationksettingkforkExcel?k-
kCORRECT kANSWER-AutomatickExceptkforkDatakTables
Tokaddkakcellkreferencekfromkakdifferentkworksheetkintokankexistingkformulakwithkyourkk
eyboard,kyoukshouldkfollowkthekfollowingksteps:k-kCORRECTkANSWER-
1.kHitkF2ktokgetkintokthekexistingkformula;kdeletekanykincorrectkformulaskorkoperatorsk2.k
HitkF2kagainktokenablek"Enter"kmodekonkthekbottom-
leftkcornerkofkthekExcelksheetk3.kHoldingkdownkCtrl,kusekPageUpkorkPageDownktokfindkt
hekdesiredkworksheetk4.kLetkgokofkthekCtrlkandkPageUp/Downkkeysk5.kUsekthekarrowkk
eysktoklocatekthekdesiredkcellkreferencek6.kHitkEnter
Whatkiskthekkeyboardkshortcutktokmoveksheetskwithinkakworkbook?k-
kCORRECT kANSWER-AltkHkOkM
Whatkiskthekkeyboardkshortcutktokopenkthekformattingkcellskdialogkbox?k-
kCORRECT kANSWER-Ctrlk1
Whatkarekthekkeyboardkshortcutskforkauto-fittingkakrangekofkcolumns?k-
kCORRECT kANSWER-
1)kSelectkthekcolumnskbykhittingkCtrlkSpacebar.k2)kHoldkdownkthekshiftkkeykandkusekleft
kandkrightkarrowkkeysktokhighlightkthekrangekofkcolumns.k3)kHitkAltkHkOkI ktokautokfitkthek
columns.
WhenkyoukarekinkthekFormatkCellskdialogk(Ctrlk1):
Whatkiskthekkeyboardkshortcutkforkmovingkacrossktabsk(Number,kAlignment,kFontkBorde
r,kFill,kProtection)?
Howkdokyoukmovekcounterkclockwisekacrosskformkelements?
Howkdokyoukselectkakcheckboxk(putkakcheckboxknextktokit)k-kCORRECTkANSWER-
1)kCtrlkTabk2)kShiftkTabk3)kSpacebar