WALL STREET PREP : EXCEL
CRASH COURSE COMPLETE
EXAM BANK / 250+ QUESTIONS
AND CORRECT ANSWERS
2024/2025 GRADED A+ ( BEST FOR
REVISION ).
2 / 43
on)
the cell will
1. KeyboardVersustheMouse ANSWER Almost everything that can be done in Excel using a mouse can also be
done using the keyboard ...
WALL STREET PREP : EXCEL
CRASH COURSE COMPLETE
EXAM BANK / 250+ QUESTIONS
AND CORRECT ANSWERS
2024/2025 GRADED A+ ( BEST FOR
REVISION ).
,1. Keyboard Versus the Mouse ANSWER 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 Excel using only the keyboard
2. Name Box ANSWER Tells you what cell you are in (top left below the ribb
on)
3. Formula Bar ANSWER When you insert a formula into a cell and hit return, show you the the cell will
output
The formula bar, however, will show you the formula Next to "fx" right below the
ribbon
4. Worksheets ANSWER 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
9. Main tabs ANSWER 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 ANSWER
(1) Home
(2) Insert
(3) Draw
(4) Page Layout
,(5) Formulas
(6) Data
(7) Review
(8) View
(9) Developer
10. How to Access Ribbon on Mac ANSWER Ctrl Fn F2 Use
arrow keys to peruse the Mac ribbon
11. Mac Settings to Disable ANSWER (1) Function Keys ANSWER Settings - Keyboard - Use F1, F2, etc. keys as
standard function keys
(2) Mission Control ANSWER System Preferences - Keyboard - Shortcuts - Mission Control - Disable "Move a space
left" and "Move a space right" to use Ctrl RightArrow or Ctrl LeftArrow
12. Using Function Keys ANSWER Hit Fn and then the function key to use the function keys themselves on a Mac
13. Open a New Workout ANSWER Ctrl N
Cmnd N
14. The File Tab ANSWER 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 of these features Open a File ANSWER Ctrl O (Cmnd
O)
Save a File ANSWER Ctrl S (Cmnd S)
Print a File ANSWER Ctrl P (Cmnd P)
15. Save a File ANSWER
Ctrl S Cmnd S
16. Print a File ANSWER
Ctrl P Cmnd P
17. Open a File ANSWER
Ctrl O Cmnd O
18. Toolbars ANSWER Within each of the main tabs you will find all of Excel's features, grouped by
commands
19. Navigating to the Toolbars Without the Mouse ANSWER 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
20. Bold Command ANSWER Ctrl
B Cmnd B
21. The Home Tab ANSWER Includes most formatting properties ANSWER
Font type, size, and color
, Background color Text/cell
alignment
Changing currency, decimal, percent formats
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Tutor23. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
