WallStreetPrep: Excel Crash Exam | 246 Questions and Verified Answers (2023/ 2024 Update)

WallStreetPrep: Excel Crash Exam | 246 Questions and Verified Answers (2023/ 2024 Update) 1. Keyboard Versus the Mouse: 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: 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 5. Moving Between Worksheets: Ctrl + PageDown/PageUp (Option + RightArrow/LeftArrow) 6. Adding Worksheets: (Fn Shift F11) 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: Ctrl Fn F2