Wall Street Prep Excel Crash Course
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: - Correct Answers-Alt i w
What is a keyboard shortcut to open a file? - Correct Answers-ctrl o
What is the recommended workbook calculation setting for Excel? - Correct Answers-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: - Correct Answers-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 command to autofit the row height? - Correct Answers-Alt h o a
What is the command to change the zoom size? - Correct Answers-Alt v z
Format Cells - Correct Answers-ctrl 1
What is the keyboard shortcut to open the formatting cells dialog box? - Correct Answers-ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? - Correct Answers-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) - Correct Answers-1) Ctrl Tab 2) Shift
Tab 3) Spacebar
If I want to add the title "Company Financials" in cell A1 ensure that all columns are the same
width across all the worksheets in my workbook, how would I do that? - Correct Answers-1.
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: - Correct Answers-Alt i w
What is a keyboard shortcut to open a file? - Correct Answers-ctrl o
What is the recommended workbook calculation setting for Excel? - Correct Answers-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: - Correct Answers-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 command to autofit the row height? - Correct Answers-Alt h o a
What is the command to change the zoom size? - Correct Answers-Alt v z
Format Cells - Correct Answers-ctrl 1
What is the keyboard shortcut to open the formatting cells dialog box? - Correct Answers-ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? - Correct Answers-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) - Correct Answers-1) Ctrl Tab 2) Shift
Tab 3) Spacebar
If I want to add the title "Company Financials" in cell A1 ensure that all columns are the same
width across all the worksheets in my workbook, how would I do that? - Correct Answers-1.
