WallStreetPrep: Excel Crash course
Exam Questions and Answers 100%
PASS
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
, 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 ANSWER-1. Group the wroksheets by hitting Ctrl Shift and
use the PageUp/Down keys to select the worksheets. 2. In the active sheet type in
"Company Financials" in A1 and apply the desired width to all columns 3.
COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED
Exam Questions and Answers 100%
PASS
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
, 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 ANSWER-1. Group the wroksheets by hitting Ctrl Shift and
use the PageUp/Down keys to select the worksheets. 2. In the active sheet type in
"Company Financials" in A1 and apply the desired width to all columns 3.
COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED
