WALL STREET PREP: EXCEL CRASH COURSE EXAM QUESTIONS
WITH CORRECT ANSWERS
Find or Find and Replace Shortcut - ✔✔ Ctrl F
(Cmnd F)
What is the recommended workbook calculation setting for Excel? - ✔✔ Automatic Except for
Data Tables
Add a Cell Reference From a Different Worksheet into an Existing Formula - ✔✔ Hit F2 to get
into the existing formula; delete any incorrect formulas or operators
Hit F2 again to enable "Enter" mode on the bottom-left corner of the Excel sheet
Holding down Ctrl, use PageUp or PageDown to find the desired worksheet
Let go of the Ctrl and PageUp/Down keys
Use the arrow keys to located the desired cell reference
Hit Enter
Autofit Row Height Command - ✔✔ Alt H O A
Autofit Column Height Command - ✔✔ Alt O C A
Assign Column Width Command - ✔✔ Alt H O W
(Home > Format > Column Width)
Assign Row Height Command - ✔✔ Alt H O H
,(Home > Format > Row Height)
Command to Change Zoom Size - ✔✔ Alt+V+Z
(Ctrl+MouseScroll)
Autofit the Column Width Command - ✔✔ Alt H O I
(Home > Format > Autofit Column Width)
Basic Excel Drills - ✔✔ Most keyboard shortcuts involves Alt or Ctrl keys
Alt: Press each key and let go (do you NOT need to hold to the Alt key)
Ctrl: Ctrl key must be held down as you press the other key in the shortcut sequence
Ctrl Commands - ✔✔ Most commands involving Ctrl are shortcuts that are automated by default
to make Excel more efficient and user friendly
Save As Shortcut - ✔✔ Alt F A
Alt Commands - ✔✔ Most commands involving Alt are shortcuts to the commands and
functions inside the default eight Main Tabs
Select Column & Range of Columns - ✔✔ Ctrl Space
Range: Ctrl Space Shift+RightArrow
Select Row & Range of Rows - ✔✔ Shift Space
,Range: Shift Space Shift+DownArrow
Undo - ✔✔ Ctrl Z
Excel Formulas - ✔✔ Start with the = sign
The = sign tells Excel that the info that will follow the = sign should be treated as a formula and
not as plain text
Once you type in the = sign, use the arrow keys to navigate around the Excel workbook to find
the cells you need for your formula
Operations in Excel - ✔✔
Copying Across Formulas - ✔✔ Ctrl + C to copy, Ctrl + V to paste
Open Format Cells Dialog - ✔✔ Ctrl+1
(Cmnd+1)
Navigating Format Cells Dialog - ✔✔ Using the Arrow keys to get around the tab
To get in a tab, either use Tab key or use Alt and the relevant letter
Use Space to toggle check boxes
Highlight a Contiguous Range - ✔✔ Ctrl + Shift + Arrows
(Cmnd + Shift + Arrows)
, Combining Data in Two Sheets into Another Sheet - ✔✔ (1) Copy and paste the relevant headers
into the third sheet
(2) Type "=" in the relevant column in the third sheet and then use Ctrl PageUp/Down (Option
Right/LeftArrow) to get to the first sheet and find the right data
(3) Press "+" and then find the relevant data in the second sheet and press "Enter"
(4) Ctrl+C to copy that formula and then apply it to the rest of the table
(5) Delete and retype any important formulas (ex. Net Profit)
(6) Add in formatting by Ctrl+C the table in sheet 1 or 2, moving to the upper corner of the table
in sheet 3 and using Paste Special and then format: Alt+E+S+T or Ctrl+Alt+V+T
(Ctrl+Cmnd+V+T)
Paste Special - ✔✔ Alt+E+S
(Ctrl+Cmnd+V+T)
Keyboard Versus the Mouse - ✔✔ Almost everything that can be done in Excel using a mouse
can also be done using the keyboard shortcuts
Best way to learn is to disconnect the mouse and work through Excel using only the keyboard
Name Box - ✔✔ Tells you what cell you are in (top left below the ribbon)
Formula Bar - ✔✔ When you insert a formula into a cell and hit return, the cell will show you
the output
The formula bar, however, will show you the formula
Next to "fx" right below the ribbon
WITH CORRECT ANSWERS
Find or Find and Replace Shortcut - ✔✔ Ctrl F
(Cmnd F)
What is the recommended workbook calculation setting for Excel? - ✔✔ Automatic Except for
Data Tables
Add a Cell Reference From a Different Worksheet into an Existing Formula - ✔✔ Hit F2 to get
into the existing formula; delete any incorrect formulas or operators
Hit F2 again to enable "Enter" mode on the bottom-left corner of the Excel sheet
Holding down Ctrl, use PageUp or PageDown to find the desired worksheet
Let go of the Ctrl and PageUp/Down keys
Use the arrow keys to located the desired cell reference
Hit Enter
Autofit Row Height Command - ✔✔ Alt H O A
Autofit Column Height Command - ✔✔ Alt O C A
Assign Column Width Command - ✔✔ Alt H O W
(Home > Format > Column Width)
Assign Row Height Command - ✔✔ Alt H O H
,(Home > Format > Row Height)
Command to Change Zoom Size - ✔✔ Alt+V+Z
(Ctrl+MouseScroll)
Autofit the Column Width Command - ✔✔ Alt H O I
(Home > Format > Autofit Column Width)
Basic Excel Drills - ✔✔ Most keyboard shortcuts involves Alt or Ctrl keys
Alt: Press each key and let go (do you NOT need to hold to the Alt key)
Ctrl: Ctrl key must be held down as you press the other key in the shortcut sequence
Ctrl Commands - ✔✔ Most commands involving Ctrl are shortcuts that are automated by default
to make Excel more efficient and user friendly
Save As Shortcut - ✔✔ Alt F A
Alt Commands - ✔✔ Most commands involving Alt are shortcuts to the commands and
functions inside the default eight Main Tabs
Select Column & Range of Columns - ✔✔ Ctrl Space
Range: Ctrl Space Shift+RightArrow
Select Row & Range of Rows - ✔✔ Shift Space
,Range: Shift Space Shift+DownArrow
Undo - ✔✔ Ctrl Z
Excel Formulas - ✔✔ Start with the = sign
The = sign tells Excel that the info that will follow the = sign should be treated as a formula and
not as plain text
Once you type in the = sign, use the arrow keys to navigate around the Excel workbook to find
the cells you need for your formula
Operations in Excel - ✔✔
Copying Across Formulas - ✔✔ Ctrl + C to copy, Ctrl + V to paste
Open Format Cells Dialog - ✔✔ Ctrl+1
(Cmnd+1)
Navigating Format Cells Dialog - ✔✔ Using the Arrow keys to get around the tab
To get in a tab, either use Tab key or use Alt and the relevant letter
Use Space to toggle check boxes
Highlight a Contiguous Range - ✔✔ Ctrl + Shift + Arrows
(Cmnd + Shift + Arrows)
, Combining Data in Two Sheets into Another Sheet - ✔✔ (1) Copy and paste the relevant headers
into the third sheet
(2) Type "=" in the relevant column in the third sheet and then use Ctrl PageUp/Down (Option
Right/LeftArrow) to get to the first sheet and find the right data
(3) Press "+" and then find the relevant data in the second sheet and press "Enter"
(4) Ctrl+C to copy that formula and then apply it to the rest of the table
(5) Delete and retype any important formulas (ex. Net Profit)
(6) Add in formatting by Ctrl+C the table in sheet 1 or 2, moving to the upper corner of the table
in sheet 3 and using Paste Special and then format: Alt+E+S+T or Ctrl+Alt+V+T
(Ctrl+Cmnd+V+T)
Paste Special - ✔✔ Alt+E+S
(Ctrl+Cmnd+V+T)
Keyboard Versus the Mouse - ✔✔ Almost everything that can be done in Excel using a mouse
can also be done using the keyboard shortcuts
Best way to learn is to disconnect the mouse and work through Excel using only the keyboard
Name Box - ✔✔ Tells you what cell you are in (top left below the ribbon)
Formula Bar - ✔✔ When you insert a formula into a cell and hit return, the cell will show you
the output
The formula bar, however, will show you the formula
Next to "fx" right below the ribbon
