2024 EXCEL CRASH COURSE EXAM 3 FROM WALL STREET PREP WALL STREET PREP ACTUAL QUESTIONS AND CORRECT ANSWERS (CORRECT VERIFIED SOLUTIONS) A NEW UPDATED VERSION

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