Wall Street Prep Excel Crash Course 2026–2027 |
Complete Study Guide, Practice Questions & Exam Prep
All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook
EXCEPT: - correct answers -Alt h i w
What is a keyboard shortcut to open a file?` - correct answers -Ctrl o
What is the recommended workbook calculation setting for Excel? - correct answers -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: - correct answers -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? - correct answers -Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? - correct answers -Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? - correct answers -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):
1
Complete Study Guide, Practice Questions & Exam Prep
All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook
EXCEPT: - correct answers -Alt h i w
What is a keyboard shortcut to open a file?` - correct answers -Ctrl o
What is the recommended workbook calculation setting for Excel? - correct answers -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: - correct answers -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? - correct answers -Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? - correct answers -Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? - correct answers -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):
1
