Wall Street Prep Excel Exam Complete
Questions And Correct Answers
\Q\.All of the following are keyboard shortcut that allow the user input
to add more sheets to a workbook EXCEPT: - ANSWERS✔-Alt h i w
\Q\.What is a keyboard shortcut to open a file? - ANSWERS✔-Ctrl o
\Q\.What is the recommended workbook calculation setting for Excel? -
ANSWERS✔-Automatic except for Data Tables
\Q\.To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps: -
ANSWERS✔-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
\Q\.Alt h o i - ANSWERS✔-exact column width
, \Q\.Alt h o w - ANSWERS✔-identical column widths
\Q\.Alt h o h - ANSWERS✔-identical column height
\Q\.Control + Space - ANSWERS✔-highlight column
\Q\.Shift + Space - ANSWERS✔-highlight row
\Q\.Command + B - ANSWERS✔-bold
\Q\.Command + I - ANSWERS✔-italicize
\Q\.Alt e s / control command v - ANSWERS✔-paste special
\Q\.What is the keyboard shortcut to move sheets within a workbook? -
ANSWERS✔-Alt H O M
\Q\.What is the keyboard shortcut to open the formatting cells dialog
box? - ANSWERS✔-Ctrl 1
Questions And Correct Answers
\Q\.All of the following are keyboard shortcut that allow the user input
to add more sheets to a workbook EXCEPT: - ANSWERS✔-Alt h i w
\Q\.What is a keyboard shortcut to open a file? - ANSWERS✔-Ctrl o
\Q\.What is the recommended workbook calculation setting for Excel? -
ANSWERS✔-Automatic except for Data Tables
\Q\.To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps: -
ANSWERS✔-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
\Q\.Alt h o i - ANSWERS✔-exact column width
, \Q\.Alt h o w - ANSWERS✔-identical column widths
\Q\.Alt h o h - ANSWERS✔-identical column height
\Q\.Control + Space - ANSWERS✔-highlight column
\Q\.Shift + Space - ANSWERS✔-highlight row
\Q\.Command + B - ANSWERS✔-bold
\Q\.Command + I - ANSWERS✔-italicize
\Q\.Alt e s / control command v - ANSWERS✔-paste special
\Q\.What is the keyboard shortcut to move sheets within a workbook? -
ANSWERS✔-Alt H O M
\Q\.What is the keyboard shortcut to open the formatting cells dialog
box? - ANSWERS✔-Ctrl 1
