Excel Crash Course Exam from Wall Street Prep Newest
Version - Wall Street Prep Questions And
Answers(VERIFIED ANSWERS)|Brand New Version!!
2025/2026
All of the following are keyboard shortcut that allow the user input to add more
sheets to a workbook EXCEPT: - Answer-Alt h i w
What is a keyboard shortcut to open a file? - Answer-Ctrl o
What is the recommended workbook calculation setting for Excel? - Answer-
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: - Answer-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
Alt h o i - Answer-exact column width
Alt h o w - Answer-identical column widths
, Alt h o h - Answer-identical column height
Control + Space - Answer-highlight column
Shift + Space - Answer-highlight row
To Group Columns - Answer-1. Ctrl Space to select desired columns
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the columns
4. Alt A J will unhide the columns
5. Shift Alt Left Arrow Key to remove group
To Group Rows - Answer-1. Shift Space to select desired rows
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the rows
4. Alt A J will unhide the rows
5. Shift Alt Left Arrow Key to remove group
Ctrl [ or Ctrl ] - Answer-formula audit
F5 - Answer-go to special
Version - Wall Street Prep Questions And
Answers(VERIFIED ANSWERS)|Brand New Version!!
2025/2026
All of the following are keyboard shortcut that allow the user input to add more
sheets to a workbook EXCEPT: - Answer-Alt h i w
What is a keyboard shortcut to open a file? - Answer-Ctrl o
What is the recommended workbook calculation setting for Excel? - Answer-
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: - Answer-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
Alt h o i - Answer-exact column width
Alt h o w - Answer-identical column widths
, Alt h o h - Answer-identical column height
Control + Space - Answer-highlight column
Shift + Space - Answer-highlight row
To Group Columns - Answer-1. Ctrl Space to select desired columns
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the columns
4. Alt A J will unhide the columns
5. Shift Alt Left Arrow Key to remove group
To Group Rows - Answer-1. Shift Space to select desired rows
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the rows
4. Alt A J will unhide the rows
5. Shift Alt Left Arrow Key to remove group
Ctrl [ or Ctrl ] - Answer-formula audit
F5 - Answer-go to special
