EXCEL CRASH COURSE ACTUAL EXAM WALL STREET PR
m m m m m m m
EP|| ACTUAL EXAM WITH QUESTIONS AND CORRECT ANS
m m m m m m m
WERS ALREADY GRADED A+|| LATEST AND COMPLETE V
m m m m m m m
ERSION 2024- m
2025 WITH VERIFIED SOLUTIONS|| ASSURD PASS!!!
m m m m m
1. Keyboard mVersusmthemMouse
Almost meverythingmthat mcanmbemdoneminmExcelmusingmammousemcanmalsombemdonemusingmthemkeyboardsh
ortcuts
Best mwaymtomlearnmismtomdisconnect mthemmousemand mworkmthroughmExcelmusingmonlymthemkeyboard
2. NamemBox
Tellsmyoumwhat mcellmyoumareminm(topmleft mbelow mthemribbon)
3. FormulamBar
Whenmyouminsert mamformulamintomamcellmand mhit mreturn,mthemcellmwillmshow myoumthemoutput
Themformulambar,mhowever,mwillmshow myoumthemformula
Next mtom"fx"mright mbelow mthemribbon
4. Worksheets
,2m|mPm am gm e
AnmExcelmfilemismcalled mamworkbook;
Youmstart mwithm1mworksheet mbut myoumcanmadd/deletemmore
Themactivemworksheet mismhighlighted minmExcel
5. MovingmBetweenmWorksheets
Ctrlm+mPageDown/PageUp
(Optionm+mRightArrow/LeftArrow)
6. AddingmWorksheets
(FnmShift mF11)
7. Columns
Alphabeticallymlabeled m(A,mB,mC,metc.)
8. Rows
Numericallymlabeled m(1,m2,m3,metc.)
,3m|mPm am gm e
9. Mainmtabs
Althoughmwemfocusmonmshortcuts,mvirtuallymallmcommands,mfunctions,mand mExcelmfeaturesmcanmbemac
cessedthroughmthemtask-oriented mtabsmwhichmorganizemthemmintomninemlogicalmcategories:
(1) Home
(2) Insert
(3) Draw
(4) PagemLayout
(5) Formulas
(6) Data
(7) Review
(8) View
(9) Developer
10. How mtomAccessmRibbonmonmMac
CtrlmFnmF2
Usemarrow mkeysmtomperusemthemMacmribbon
, 4m|mPm am gm e
11. MacmSettingsmtomDisable