WallStreetPrep: Excel Crash course Exam
Questions and Answers (Latest)
All of the following are keyboard shortcut that allow the user
input to add more sheets to a workbook EXCEPT: - Correct
Answer ✅Alt h i w
What is a keyboard shortcut to open a file?` - Correct
Answer ✅Ctrl o
What is the recommended workbook calculation setting for
Excel? - Correct 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: - Correct 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
What is the keyboard shortcut to move sheets within a
workbook? - Correct Answer ✅Alt H O M
, WallStreetPrep: Excel Crash course Exam
Questions and Answers (Latest)
What is the keyboard shortcut to open the formatting cells
dialog box? - Correct Answer ✅Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of
columns? - Correct Answer ✅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?
How do you select a checkbox (put a checkbox next to it) -
Correct Answer ✅1) Ctrl Tab 2) Shift Tab 3) Spacebar
If I want to add the title "Company Financials" in cell A1
ensure that all columns are the same width across all the
worksheets in my workbook, how would I do that? - Correct
Questions and Answers (Latest)
All of the following are keyboard shortcut that allow the user
input to add more sheets to a workbook EXCEPT: - Correct
Answer ✅Alt h i w
What is a keyboard shortcut to open a file?` - Correct
Answer ✅Ctrl o
What is the recommended workbook calculation setting for
Excel? - Correct 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: - Correct 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
What is the keyboard shortcut to move sheets within a
workbook? - Correct Answer ✅Alt H O M
, WallStreetPrep: Excel Crash course Exam
Questions and Answers (Latest)
What is the keyboard shortcut to open the formatting cells
dialog box? - Correct Answer ✅Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of
columns? - Correct Answer ✅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?
How do you select a checkbox (put a checkbox next to it) -
Correct Answer ✅1) Ctrl Tab 2) Shift Tab 3) Spacebar
If I want to add the title "Company Financials" in cell A1
ensure that all columns are the same width across all the
worksheets in my workbook, how would I do that? - Correct
