1|Page
EXCEL CRASH COURSE FROM WALLSTREET PREP
EXAM AND PRACTICE EXAM NEWEST ACTUAL
EXAM QUESTIONS AND CORRECT DETAILED
ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+
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"
, 2|Page
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
Command + B - .....ANSWER ...✔✔ bold
Command + I - .....ANSWER ...✔✔ italicize
Alt e s / control command v - .....ANSWER ...✔✔
paste special
EXCEL CRASH COURSE FROM WALLSTREET PREP
EXAM AND PRACTICE EXAM NEWEST ACTUAL
EXAM QUESTIONS AND CORRECT DETAILED
ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+
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"
, 2|Page
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
Command + B - .....ANSWER ...✔✔ bold
Command + I - .....ANSWER ...✔✔ italicize
Alt e s / control command v - .....ANSWER ...✔✔
paste special
