Wall Street Prep: Excel Crash Course: Updated A+ Score Guide

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 Excel using only the keyboard Name Box (Ans- Tells you what cell you are in (top left below the ribbon) 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) Columns (Ans- Alphabetically labeled (A, B, C, etc.)