1
For Expert help and assignment solutions, +254707240657
WallStreetPrep: Excel Crash course
Questions and Answers (100% Correct
Answers) Already Graded A+
All of the following are keyboard shortcut that allow the user input
to add more sheets to a workbook EXCEPT:[ ANS: ]Alt h i w
What is a keyboard shortcut to open a file?`[ ANS: ]Ctrl o
© 2025 Assignment Expert
What is the recommended workbook calculation setting for
Excel?[ ANS: ]Automatic Except for Data Tables
To add a cell reference from a different worksheet into an existing
Guru01 - Stuvia
formula with your keyboard, you should follow the following steps:[
ANS: ]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?[
ANS: ]Alt H O M
What is the keyboard shortcut to open the formatting cells dialog
box?[ ANS: ]Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of
columns?[ ANS: ]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.
, 2
For Expert help and assignment solutions, +254707240657
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)[ ANS:
]1) Ctrl Tab 2) Shift Tab 3) Spacebar
© 2025 Assignment Expert
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?[ ANS: ]1. Group the
Guru01 - Stuvia
wroksheets by hitting Ctrl Shift and use the PageUp/Down keys to
select the worksheets. 2. In the active sheet type in "Company
Financials" in A1 and apply the desired width to all columns 3.
Remember to hit Ctrl Pageup or Pagedown to make sure that
future edits only apply to active sheet.
What is the keyboard sequence to
1) Group highlighted columns (but not to hide group)
2) Hide the group (will show a + sign above the column)
3) Show the group (will show a + sign above the column)[ ANS: ]1.
Shift Alt Right Arrow 2. Alt a h 3. Alt a j
For Expert help and assignment solutions, +254707240657
WallStreetPrep: Excel Crash course
Questions and Answers (100% Correct
Answers) Already Graded A+
All of the following are keyboard shortcut that allow the user input
to add more sheets to a workbook EXCEPT:[ ANS: ]Alt h i w
What is a keyboard shortcut to open a file?`[ ANS: ]Ctrl o
© 2025 Assignment Expert
What is the recommended workbook calculation setting for
Excel?[ ANS: ]Automatic Except for Data Tables
To add a cell reference from a different worksheet into an existing
Guru01 - Stuvia
formula with your keyboard, you should follow the following steps:[
ANS: ]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?[
ANS: ]Alt H O M
What is the keyboard shortcut to open the formatting cells dialog
box?[ ANS: ]Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of
columns?[ ANS: ]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.
, 2
For Expert help and assignment solutions, +254707240657
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)[ ANS:
]1) Ctrl Tab 2) Shift Tab 3) Spacebar
© 2025 Assignment Expert
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?[ ANS: ]1. Group the
Guru01 - Stuvia
wroksheets by hitting Ctrl Shift and use the PageUp/Down keys to
select the worksheets. 2. In the active sheet type in "Company
Financials" in A1 and apply the desired width to all columns 3.
Remember to hit Ctrl Pageup or Pagedown to make sure that
future edits only apply to active sheet.
What is the keyboard sequence to
1) Group highlighted columns (but not to hide group)
2) Hide the group (will show a + sign above the column)
3) Show the group (will show a + sign above the column)[ ANS: ]1.
Shift Alt Right Arrow 2. Alt a h 3. Alt a j
