EXCEL CRASH COURSE EXAM FROM WALL STREET
PREP 100% GUARANTEED PASS!!
Perfect Prep for Every Paper | Precision in Every Answer!
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
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
1
APPHIA - Crafted with Care and Precision for Academic Excellence.
, 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
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.
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) - Answer: 1) Ctrl Tab
2) Shift Tab
3) Spacebar
Alt w f f - Answer: freeze pane
Alt w s - Answer: split pane
F6 - Answer: jump between panes
Alt H E A - Answer: delete everything about a cell
Control Shift + - Answer: insert new row
2
APPHIA - Crafted with Care and Precision for Academic Excellence.
PREP 100% GUARANTEED PASS!!
Perfect Prep for Every Paper | Precision in Every Answer!
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
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
1
APPHIA - Crafted with Care and Precision for Academic Excellence.
, 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
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.
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) - Answer: 1) Ctrl Tab
2) Shift Tab
3) Spacebar
Alt w f f - Answer: freeze pane
Alt w s - Answer: split pane
F6 - Answer: jump between panes
Alt H E A - Answer: delete everything about a cell
Control Shift + - Answer: insert new row
2
APPHIA - Crafted with Care and Precision for Academic Excellence.
