M&A Modeling Exam Answers from Wall Street Prep
All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook
EXCEPT: - ANSWERAlt h i w
What is a keyboard shortcut to open a file? - ANSWERCtrl o
What is the recommended workbook calculation setting for Excel? - ANSWERAutomatic 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: - ANSWER1. 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 EnterAlt
h o i - ANSWERexact column width
Alt h o w - ANSWERidentical column widths
Alt h o h - ANSWERidentical column height
Control + Space - ANSWERhighlight columnShift + Space - ANSWERhighlight row
Command + B – ANSWERbold
Command + I - ANSWERitalicizeAlt e s / control command v - ANSWERpaste special
What is the keyboard shortcut to move sheets within a workbook? - ANSWERAlt H O M
What is the keyboard shortcut to open the formatting cells dialog box? - ANSWERCtrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? - ANSWER1) 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) - ANSWER1) Ctrl Tab
2) Shift Tab
3) Spacebaralt w f f - ANSWERfreeze panealt w s - ANSWERsplit paneF6 - ANSWERjump between
panesAlt H E A - ANSWERdelete everything about a cellControl Shift + - ANSWERinsert new rowControl
Shift ! - ANSWERnumber format; 2 decimalsControl Shift $ - ANSWERcurrency format; 2 decimalsControl
Shift % - ANSWERpercentage format with no decimal pointsControl Shift _ - ANSWERremove all
bordersAlt H I S - ANSWERnew worksheetAlt e l - ANSWERdelete worksheetAlt h o r - ANSWERrename
worksheetTo Group Columns - ANSWER1. Ctrl Space to select desired columns
All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook
EXCEPT: - ANSWERAlt h i w
What is a keyboard shortcut to open a file? - ANSWERCtrl o
What is the recommended workbook calculation setting for Excel? - ANSWERAutomatic 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: - ANSWER1. 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 EnterAlt
h o i - ANSWERexact column width
Alt h o w - ANSWERidentical column widths
Alt h o h - ANSWERidentical column height
Control + Space - ANSWERhighlight columnShift + Space - ANSWERhighlight row
Command + B – ANSWERbold
Command + I - ANSWERitalicizeAlt e s / control command v - ANSWERpaste special
What is the keyboard shortcut to move sheets within a workbook? - ANSWERAlt H O M
What is the keyboard shortcut to open the formatting cells dialog box? - ANSWERCtrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? - ANSWER1) 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) - ANSWER1) Ctrl Tab
2) Shift Tab
3) Spacebaralt w f f - ANSWERfreeze panealt w s - ANSWERsplit paneF6 - ANSWERjump between
panesAlt H E A - ANSWERdelete everything about a cellControl Shift + - ANSWERinsert new rowControl
Shift ! - ANSWERnumber format; 2 decimalsControl Shift $ - ANSWERcurrency format; 2 decimalsControl
Shift % - ANSWERpercentage format with no decimal pointsControl Shift _ - ANSWERremove all
bordersAlt H I S - ANSWERnew worksheetAlt e l - ANSWERdelete worksheetAlt h o r - ANSWERrename
worksheetTo Group Columns - ANSWER1. Ctrl Space to select desired columns
