1 | Page
WallStreetPrep: Excel Crash course
Questions and Correct Answers
All of the following are keyboard shortcut that allow the user
input to add more sheets to a workbook EXCEPT: Ans: — Alt h i w
What is a keyboard shortcut to open a file?` Ans: — Ctrl o
What is the recommended workbook calculation setting for Excel?
Ans: — Automatic Except for Data Tables
To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following
steps: Ans: — 1. Hit F2 to get into the existing formula; delete any
incorrect formulas or operators 2. Hit F2 again to enable "Enter"
mode on the bottom-left corner of the Excel sheet 3. Holding down
Ctrl, use PageUp or PageDown to find the desired worksheet 4. Let
go of the Ctrl and PageUp/Down keys 5. Use the arrow keys to
locate the desired cell reference 6. Hit Enter
What is the keyboard shortcut to move sheets within a workbook?
Ans: — Alt H O M
What is the keyboard shortcut to open the formatting cells dialog
box? Ans: — Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of
columns? Ans: — 1) Select the columns by hitting Ctrl Spacebar. 2)
Hold down the shift key and use left and right arrow keys to
highlight the range of columns. 3) Hit Alt H O I to auto fit the
columns.
When you are in the Format Cells dialog (Ctrl 1):
What is the keyboard shortcut for moving across tabs (Number,
Alignment, Font Border, Fill, Protection)?
How do you move counter clockwise across form elements?
© 2025 All rights reserved
WallStreetPrep: Excel Crash course
Questions and Correct Answers
All of the following are keyboard shortcut that allow the user
input to add more sheets to a workbook EXCEPT: Ans: — Alt h i w
What is a keyboard shortcut to open a file?` Ans: — Ctrl o
What is the recommended workbook calculation setting for Excel?
Ans: — Automatic Except for Data Tables
To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following
steps: Ans: — 1. Hit F2 to get into the existing formula; delete any
incorrect formulas or operators 2. Hit F2 again to enable "Enter"
mode on the bottom-left corner of the Excel sheet 3. Holding down
Ctrl, use PageUp or PageDown to find the desired worksheet 4. Let
go of the Ctrl and PageUp/Down keys 5. Use the arrow keys to
locate the desired cell reference 6. Hit Enter
What is the keyboard shortcut to move sheets within a workbook?
Ans: — Alt H O M
What is the keyboard shortcut to open the formatting cells dialog
box? Ans: — Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of
columns? Ans: — 1) Select the columns by hitting Ctrl Spacebar. 2)
Hold down the shift key and use left and right arrow keys to
highlight the range of columns. 3) Hit Alt H O I to auto fit the
columns.
When you are in the Format Cells dialog (Ctrl 1):
What is the keyboard shortcut for moving across tabs (Number,
Alignment, Font Border, Fill, Protection)?
How do you move counter clockwise across form elements?
© 2025 All rights reserved
