2024hUPDATE
Excel Crash Course Latest Exam 2024 (
h h h h h h
Wall Street Preparation) Complete 250 Q
h h h h h
uestions Fully Solved 100% REAL
h h h h
EXAM |Score A+ h h
1. KeyboardhVersushthehMouse
AlmostheverythinghthathcanhbehdonehinhExcelhusinghahmousehcanhalsohbehdonehusinghthehkeyboardhshortcu
ts
BesthwayhtohlearnhishtohdisconnecththehmousehandhworkhthroughhExcelhusinghonlyhthehkeyboard
2. NamehBox
Tellshyouhwhathcellhyouharehinh(tophlefthbelowhthehribbon)
3. FormulahBar
Whenhyouhinserthahformulahintohahcellhandhhithreturn,hthehcellhwillhshowhyouhthehoutput
Thehformulahbar,hhowever,hwillhshowhyouhthehformula
Nexthtoh"fx"hrighthbelowhthehribbon
4. Worksheets
,2024hUPDATE
AnhExcelhfilehishcalledhahworkbook;
Youhstarthwithh1hworksheethbuthyouhcanhadd/deletehmore
ThehactivehworksheethishhighlightedhinhExcel
5. MovinghBetweenhWorksheets
Ctrlh+hPageDown/PageUp
(Optionh+hRightArrow/LeftArrow)
6. AddinghWorksheets
(FnhShifthF11)
7. Columns
Alphabeticallyhlabeledh(A,hB,hC,hetc.)
8. Rows
Numericallyhlabeledh(1,h2,h3,hetc.)
,2024hUPDATE
9. Mainhtabs
Althoughhwehfocushonhshortcuts,hvirtuallyhallhcommands,hfunctions,handhExcelhfeatureshcanhbehaccessedht
hroughhthehtask-orientedhtabshwhichhorganizehthemhintohninehlogicalhcategories:
(1) Home
(2) Insert
(3) Draw
(4) PagehLayout
(5) Formulas
(6) Data
(7) Review
(8) View
(9) Developer
10. HowhtohAccesshRibbonhonhMac
CtrlhFnhF2
UseharrowhkeyshtohperusehthehMachribbon
11. MachSettingshtohDisable
, 2024hUPDATE
(1) FunctionhKeys:hSettingsh-hKeyboardh-hUsehF1,hF2,hetc.hkeyshashstandardhfunctionhkeys
(2) MissionhControl:hSystemhPreferencesh-hKeyboardh-hShortcutsh-hMissionhControlh-
hDisableh"Movehahspacehleft"handh"Movehahspacehright"htohusehCtrlhRightArrowhorhCtrlhLeftArrow
12. UsinghFunctionhKeys
HithFnhandhthenhthehfunctionhkeyhtohusehthehfunctionhkeyshthemselveshonhahMac
13. OpenhahNewhWorkout
CtrlhN
CmndhN
14. ThehFilehTab
ManyhExcelhfeaturesh(Openhfile,hSavehfile,hPrinthfile,hetc.)harehlocatedhinhthishtab
Excelhalsohhashalternativehkeyboardhshortcutsh(usinghCtrl)hforhmanyhofhthesehfeatures
OpenhahFile:hCtrlhOh(CmndhO)
SavehahFile:hCtrlhSh(CmndhS)
PrinthahFile:hCtrlhPh(CmndhP)
15. SavehahFile
CtrlhS
CmndhS
16. PrinthahFile
CtrlhP
Excel Crash Course Latest Exam 2024 (
h h h h h h
Wall Street Preparation) Complete 250 Q
h h h h h
uestions Fully Solved 100% REAL
h h h h
EXAM |Score A+ h h
1. KeyboardhVersushthehMouse
AlmostheverythinghthathcanhbehdonehinhExcelhusinghahmousehcanhalsohbehdonehusinghthehkeyboardhshortcu
ts
BesthwayhtohlearnhishtohdisconnecththehmousehandhworkhthroughhExcelhusinghonlyhthehkeyboard
2. NamehBox
Tellshyouhwhathcellhyouharehinh(tophlefthbelowhthehribbon)
3. FormulahBar
Whenhyouhinserthahformulahintohahcellhandhhithreturn,hthehcellhwillhshowhyouhthehoutput
Thehformulahbar,hhowever,hwillhshowhyouhthehformula
Nexthtoh"fx"hrighthbelowhthehribbon
4. Worksheets
,2024hUPDATE
AnhExcelhfilehishcalledhahworkbook;
Youhstarthwithh1hworksheethbuthyouhcanhadd/deletehmore
ThehactivehworksheethishhighlightedhinhExcel
5. MovinghBetweenhWorksheets
Ctrlh+hPageDown/PageUp
(Optionh+hRightArrow/LeftArrow)
6. AddinghWorksheets
(FnhShifthF11)
7. Columns
Alphabeticallyhlabeledh(A,hB,hC,hetc.)
8. Rows
Numericallyhlabeledh(1,h2,h3,hetc.)
,2024hUPDATE
9. Mainhtabs
Althoughhwehfocushonhshortcuts,hvirtuallyhallhcommands,hfunctions,handhExcelhfeatureshcanhbehaccessedht
hroughhthehtask-orientedhtabshwhichhorganizehthemhintohninehlogicalhcategories:
(1) Home
(2) Insert
(3) Draw
(4) PagehLayout
(5) Formulas
(6) Data
(7) Review
(8) View
(9) Developer
10. HowhtohAccesshRibbonhonhMac
CtrlhFnhF2
UseharrowhkeyshtohperusehthehMachribbon
11. MachSettingshtohDisable
, 2024hUPDATE
(1) FunctionhKeys:hSettingsh-hKeyboardh-hUsehF1,hF2,hetc.hkeyshashstandardhfunctionhkeys
(2) MissionhControl:hSystemhPreferencesh-hKeyboardh-hShortcutsh-hMissionhControlh-
hDisableh"Movehahspacehleft"handh"Movehahspacehright"htohusehCtrlhRightArrowhorhCtrlhLeftArrow
12. UsinghFunctionhKeys
HithFnhandhthenhthehfunctionhkeyhtohusehthehfunctionhkeyshthemselveshonhahMac
13. OpenhahNewhWorkout
CtrlhN
CmndhN
14. ThehFilehTab
ManyhExcelhfeaturesh(Openhfile,hSavehfile,hPrinthfile,hetc.)harehlocatedhinhthishtab
Excelhalsohhashalternativehkeyboardhshortcutsh(usinghCtrl)hforhmanyhofhthesehfeatures
OpenhahFile:hCtrlhOh(CmndhO)
SavehahFile:hCtrlhSh(CmndhS)
PrinthahFile:hCtrlhPh(CmndhP)
15. SavehahFile
CtrlhS
CmndhS
16. PrinthahFile
CtrlhP
