1
For Expert help and assignment solutions, +254707240657
Wall Street Prep: Excel Crash Course
Questions and Answers (100% Correct
Answers) Already Graded A+
Keyboard Versus the Mouse[ ANS: ]Almost everything that can be
done in Excel using a mouse can also be done using the keyboard
shortcuts
Best way to learn is to disconnect the mouse and work through
© 2025 Assignment Expert
Excel using only the keyboard
Name Box[ ANS: ]Tells you what cell you are in (top left below the
ribbon)
Guru01 - Stuvia
Formula Bar[ ANS: ]When you insert a formula into a cell and hit
return, the cell will show you the output
The formula bar, however, will show you the formula
Next to "fx" right below the ribbon
Worksheets[ ANS: ]An Excel file is called a workbook;
You start with 1 worksheet but you can add/delete more
The active worksheet is highlighted in Excel
Moving Between Worksheets[ ANS: ]Ctrl + PageDown/PageUp
(Option + RightArrow/LeftArrow)
Adding Worksheets[ ANS: ](Fn Shift F11)
, 2
For Expert help and assignment solutions, +254707240657
Columns[ ANS: ]Alphabetically labeled (A, B, C, etc.)
Rows[ ANS: ]Numerically labeled (1, 2, 3, etc.)
Main tabs[ ANS: ]Although we focus on shortcuts, virtually all
commands, functions, and Excel features can be accessed
through the task-oriented tabs which organize them into nine
logical categories:
(1) Home
© 2025 Assignment Expert
(2) Insert
(3) Draw
Guru01 - Stuvia
(4) Page Layout
(5) Formulas
(6) Data
(7) Review
(8) View
(9) Developer
How to Access Ribbon on Mac[ ANS: ]Ctrl Fn F2
Use arrow keys to peruse the Mac ribbon
Mac Settings to Disable[ ANS: ](1) Function Keys: Settings -
Keyboard - Use F1, F2, etc. keys as standard function keys
, 3
For Expert help and assignment solutions, +254707240657
(2) Mission Control: System Preferences - Keyboard - Shortcuts -
Mission Control - Disable "Move a space left" and "Move a space
right" to use Ctrl RightArrow or Ctrl LeftArrow
Using Function Keys[ ANS: ]Hit Fn and then the function key to use
the function keys themselves on a Mac
Open a New Workout[ ANS: ]Ctrl N
Cmnd N
© 2025 Assignment Expert
The File Tab[ ANS: ]Many Excel features (Open file, Save file, Print
file, etc.) are located in this tab
Excel also has alternative keyboard shortcuts (using Ctrl) for many
Guru01 - Stuvia
of these features
Open a File: Ctrl O (Cmnd O)
Save a File: Ctrl S (Cmnd S)
Print a File: Ctrl P (Cmnd P)
Save a File[ ANS: ]Ctrl S
Cmnd S
Print a File[ ANS: ]Ctrl P
Cmnd P
Open a File[ ANS: ]Ctrl O
Cmnd O
, 4
For Expert help and assignment solutions, +254707240657
Toolbars[ ANS: ]Within each of the main tabs you will find all of
Excel's features, grouped by commands
Navigating to the Toolbars Without the Mouse[ ANS: ]Hit Alt and
the appropriate letter (or use the right/left arrow keys) to get to
the desired tab
Once there, use the Tab and Shift Tab keys to navigate around,
the Space to open a drop down, and Enter to select
Bold Command[ ANS: ]Ctrl B
© 2025 Assignment Expert
Cmnd B
The Home Tab[ ANS: ]Includes most formatting properties:
Guru01 - Stuvia
Font type, size, and color
Background color
Text/cell alignment
Changing currency, decimal, percent formats
Inserting, deleting, and hiding rows and columns
Adjusting columns and rows width
Inserting, deleting, and renaming worksheets
The Insert Tab[ ANS: ]Important Features: Pivot Table, Charts,
Header & Footer
Page Layout Tab[ ANS: ]Important Features: Print Area, Fonts,
Gridlines
For Expert help and assignment solutions, +254707240657
Wall Street Prep: Excel Crash Course
Questions and Answers (100% Correct
Answers) Already Graded A+
Keyboard Versus the Mouse[ ANS: ]Almost everything that can be
done in Excel using a mouse can also be done using the keyboard
shortcuts
Best way to learn is to disconnect the mouse and work through
© 2025 Assignment Expert
Excel using only the keyboard
Name Box[ ANS: ]Tells you what cell you are in (top left below the
ribbon)
Guru01 - Stuvia
Formula Bar[ ANS: ]When you insert a formula into a cell and hit
return, the cell will show you the output
The formula bar, however, will show you the formula
Next to "fx" right below the ribbon
Worksheets[ ANS: ]An Excel file is called a workbook;
You start with 1 worksheet but you can add/delete more
The active worksheet is highlighted in Excel
Moving Between Worksheets[ ANS: ]Ctrl + PageDown/PageUp
(Option + RightArrow/LeftArrow)
Adding Worksheets[ ANS: ](Fn Shift F11)
, 2
For Expert help and assignment solutions, +254707240657
Columns[ ANS: ]Alphabetically labeled (A, B, C, etc.)
Rows[ ANS: ]Numerically labeled (1, 2, 3, etc.)
Main tabs[ ANS: ]Although we focus on shortcuts, virtually all
commands, functions, and Excel features can be accessed
through the task-oriented tabs which organize them into nine
logical categories:
(1) Home
© 2025 Assignment Expert
(2) Insert
(3) Draw
Guru01 - Stuvia
(4) Page Layout
(5) Formulas
(6) Data
(7) Review
(8) View
(9) Developer
How to Access Ribbon on Mac[ ANS: ]Ctrl Fn F2
Use arrow keys to peruse the Mac ribbon
Mac Settings to Disable[ ANS: ](1) Function Keys: Settings -
Keyboard - Use F1, F2, etc. keys as standard function keys
, 3
For Expert help and assignment solutions, +254707240657
(2) Mission Control: System Preferences - Keyboard - Shortcuts -
Mission Control - Disable "Move a space left" and "Move a space
right" to use Ctrl RightArrow or Ctrl LeftArrow
Using Function Keys[ ANS: ]Hit Fn and then the function key to use
the function keys themselves on a Mac
Open a New Workout[ ANS: ]Ctrl N
Cmnd N
© 2025 Assignment Expert
The File Tab[ ANS: ]Many Excel features (Open file, Save file, Print
file, etc.) are located in this tab
Excel also has alternative keyboard shortcuts (using Ctrl) for many
Guru01 - Stuvia
of these features
Open a File: Ctrl O (Cmnd O)
Save a File: Ctrl S (Cmnd S)
Print a File: Ctrl P (Cmnd P)
Save a File[ ANS: ]Ctrl S
Cmnd S
Print a File[ ANS: ]Ctrl P
Cmnd P
Open a File[ ANS: ]Ctrl O
Cmnd O
, 4
For Expert help and assignment solutions, +254707240657
Toolbars[ ANS: ]Within each of the main tabs you will find all of
Excel's features, grouped by commands
Navigating to the Toolbars Without the Mouse[ ANS: ]Hit Alt and
the appropriate letter (or use the right/left arrow keys) to get to
the desired tab
Once there, use the Tab and Shift Tab keys to navigate around,
the Space to open a drop down, and Enter to select
Bold Command[ ANS: ]Ctrl B
© 2025 Assignment Expert
Cmnd B
The Home Tab[ ANS: ]Includes most formatting properties:
Guru01 - Stuvia
Font type, size, and color
Background color
Text/cell alignment
Changing currency, decimal, percent formats
Inserting, deleting, and hiding rows and columns
Adjusting columns and rows width
Inserting, deleting, and renaming worksheets
The Insert Tab[ ANS: ]Important Features: Pivot Table, Charts,
Header & Footer
Page Layout Tab[ ANS: ]Important Features: Print Area, Fonts,
Gridlines
