WALL STREET PREP- EXCEL CRASH COURSE QUESTIONS & STEP BY STEP RATIONALE NEWEST VERSION

WALL STREET PREP- EXCEL CRASH COURSE
QUESTIONS & STEP BY STEP RATIONALE NEWEST
VERSION
1. Keyboard
Almost everything that can be done in Excel using a mouse can also be
Versus the
done using the keyboard shortcuts
Mouse
Best way to learn is to disconnect the mouse and work through Excel
using only the keyboard

2. Name Box Tells you what cell you are in (top left below the ribbon)




3. Formula Bar 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




4. Worksheets 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






,WALL STREET PREP- EXCEL CRASH COURSE
QUESTIONS & STEP BY STEP RATIONALE NEWEST
VERSION
5. Moving Ctrl + PageDown/PageUp
Between (Option +
Worksheets RightArrow/LeftArrow)

6. (Fn Shift F11)






,WALL STREET PREP- EXCEL CRASH COURSE
QUESTIONS & STEP BY STEP RATIONALE NEWEST
VERSION
Adding Work-
sheets

7. Columns Alphabetically labeled (A, B, C, etc.)




8. Rows Numerically labeled (1, 2, 3, etc.)




9. Main tabs 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
(2) Insert
(3) Draw
(4) Page Layout
(5) Formulas
(6) Data
(7) Review
(8) View
(9) Developer


10. How to Access Ribbon on Mac


,WALL STREET PREP- EXCEL CRASH COURSE
QUESTIONS & STEP BY STEP RATIONALE NEWEST
VERSION
Ctrl Fn F2 Use arrow keys to peruse the Mac ribbon

11.