WALL STREET PREP QUESTIONS AND ANSWERS UPDATED 2026 | ASSURED SUCCESS GRADED A+

WALL STREET PREP QUESTIONS AND
ANSWERS UPDATED 2026 | ASSURED
SUCCESS
GRADED A+
QUESTIONS AND ANSWERS
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


What is the keyboard shortcut to move sheets within a workbook? ANSWER - Alt H
OM


What is the keyboard shortcut to open the formatting cells dialog box? ANSWER -
Ctrl 1


What are the keyboard shortcuts for auto-fitting a range of columns? 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.