Excel Crash Course

EXCEL CRASH COURSE



Allpoofpothepofollowingpoarepokeyboardposhortcutpothatpoallowpothepouserpoinputpotopoaddpo
moreposheetspotopoapoworkbookpoEXCEPT:
Altpoipow
Altpohpoipos
ShiftpoF11
AltpoShiftpoF1
Altpohpoipow
Incorrectpo-poans--
Altpoipow,poAltpohpoipos,poShiftpoF11poandpoAltpoShiftpoF1poarepoallpokeyboardposhortcutspofo
rpoaddingpomoreposheetspotopoapoworkbook.
Altpohpoipowpoisponotpoapovalidposhortcut.

Whatpoispoapokeyboardposhortcutpotopoopenpoapofile?
Ctrlpoo
Ctrlpof
Altpoo
Ctrlponpo-poans--ThepocorrectpoanswerpoispoCtrlpoo.
Ctrlpofpoispotheposhortcutpotopofind,poorpofindpoandporeplace,potextpoonpothepoworksheet.poAl
tpoopoisponotpoapocommand.poCtrlponpoispotheposhortcutpotopoopenpoaponewpoworkbook.

WhatpoispotheporecommendedpoworkbookpocalculationposettingpoforpoExcel?
Automatic
Manual
AutomaticpoexceptpoforpoDatapoTables
Iteratepo-poans--Thepocorrectpoanswerpoispo"AutomaticpoexceptpoforpoDatapoTables".
DatapotablespocanposignificantlyposlowpodownpoExcelpoandpootherpoprograms.po"Automati
c",pothepodefaultposetting,powillpoautomaticallypocalculatepoeverythingpoinpothepoworkbook,
poincludingpodatapotables,powhichpowillpomakepothepoprogramporunpomoreposlowly.poThepo
Manualposettingpowillporequirepothepouserpotopofrequentlyporecalculatepothepoworkbookpoin
poorderpotopodisplaypocorrectly.po"Iterate"poisponotpoaposettingpoforpoworkbookpocalculationp
oinpoExcel;poiterativepocalculationpoispoapotogglepoforpouserspotoposetpoforpoworkbookspotha
tpomaypohavepocircularpocalculations.q

Topoaddpoapocellporeferencepofrompoapodifferentpoworksheetpointopoanpoexistingpoformulapo
withpoyourpokeyboard,poyouposhouldpofollowpothepofollowingposteps:
1.poHitpoF2potopogetpointopothepoexistingpoformula;podeletepoanypoincorrectpoformulaspoorpo
operatorspo2.poHitpoF2poagainpotopoenablepo"Enter"pomodepoonpothepobottom-
leftpocornerpoofpothepoExcelposheetpo3.poHoldingpodownpoCtrl,pousepoPageUppoorpoPageD

, ownpotopofindpothepodesiredpoworksheetpo4.poLetpogopoofpothepoCtrlpoandpoPageUp/
Downpokeyspo5.poUsepothepoarrowpokeyspotopolocatepothepodesiredpocellporeferencepo6.po
HitpoEnter
1.poHitpoF2potopogetpointopothepoexistingpoformula;podeletepoanypoincorrectpoformulaspoorpo
operatorspo2.poHitpoF2poagainpotopoenablepo"Enter"pomodepoonpothepobottom-
leftpocornerpoofpothepoExcelposheetpo3.poHoldingpodownpoAlt,pousepoPageUppoorpoPageDo
wnpotopofindpothepodesiredpoworksheetpo4.poLetpogopoofpothepoCtrlpoandpoPageUp/
Downpokeyspo5.poUsepothepoarrowpokeyspotopolocatepothepodesiredpocellporeferencepo6.po
HitpoEscapepo-poans--Thepocorrectpoanswerpois:
HitpoF2potopogetpointopothepoexistingpoformula;podeletepoanypoincorrectpoformulaspoorpoope
rators
HitpoF2poagainpotopoenablepo"Enter"pomodepoonpothepobottom-
leftpocornerpoofpothepoExcelposheet
HoldingpodownpoCtrl,pousepoPageUppoorpoPageDownpotopofindpothepodesiredpoworksheet
LetpogopoofpothepoCtrlpoandpoPageUp/Downpokeys
Usepothepoarrowpokeyspotopolocatepothepodesiredpocellporeference
HitpoEnter
Inpothepoincorrectpooption,po3.poAltpoPagepoUppo/
poDownpowillponotpoallowpothepouserpotoponavigatepotopoapodifferentpoworksheet;po6.poHitpo
Escapepowillponotposavepoanypocellporeferences,pobutpowillpodeletepoanyponewpodatapoorpof
ormulapothatpohaspobeenpoenteredpointopothepocell.

Whatpoispothepokeyboardpocommandpotopoautofitpotheporowpoheight?
Altpoopocpoa
Altpoopocpow
Altpohpoopoh
Altpohpoopoapo-poans--Thepocorrectpoanswerpoispo"Altpohpoopoa"
Altpoopocpoapoispousedpotopoautofitpocolumnpowidth.poAltpoopocpowpoispousedpotopoassignpoth
epocolumnpowidth.poAltpohpoopohpoispousedpotopoassignpotheporowpoheight.

Whatpoispothepocommandpotopochangepothepozoomposize?
Altpovpoz
Altpotpoopov
Altpohpoopoi
Altpohpovpotpo-poans--Thepocorrectpoanswerpoispo"Altpovpoz".
Altpotpoopovpoisponotpoapovalidposhortcut.poAltpohpoopoIpoispotheposhortcutpotopoautofitpothepoc
olumnpowidth.poAltpohpovpotpoisponotpoapovalidposhortcut.

Whatpoispothepokeyboardposhortcutpotopoopenpothepoformattingpocellspodialogpobox?
Ctrlpo1
Ctrlpo2
CtrlpoShiftpo1
CtrlpoShiftpo2po-poans--Thepocorrectpoanswerpois:poCtrlpo1.
Ctrlpo2poisponotpoapovalidposhortcut.poCtrlpoShiftpo1poispotheposhortcutpotopocyclepothroughpo
differentponumberpoformats.poCtrlpoShiftpo2poispotheposhortcutpotopocyclepothroughpodiffere
ntpodatepoformats.