EXCEL CRASH COURSE FROM WALL STREET EXAM
LATEST 2025 ACTUAL EXAM WITH COMPLETE
QUESTIONS AND CORRECT DETAILED ANSWERS
(100% VERIFIED ANSWERS) |ALREADY GRADED A+|
||LATEST EXAM!!!||
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
, 2|Page
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
What is the keyboard shortcut to move sheets within a
workbook? - Answer-Alt H O M