Wall Street Prep Excel Crash Course Exam with correct detailed solutions

Wall Street Prep Excel Crash Course Exam with || || || || || || || ||




correct detailed solutions || ||




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
|| || || || || || || || || || || || || || || ||




Name Box ||




Tells you what cell you are in (top left below the ribbon)
|| || || || || || || || || || ||




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
|| || || || || ||




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
|| || || || || ||




Moving Between Worksheets || ||




Ctrl + PageDown/PageUp
|| ||

,(Option + RightArrow/LeftArrow)
|| ||




Adding Worksheets ||




(Fn Shift F11)
|| ||




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




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




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
||

,How to Access Ribbon on Mac
|| || || || ||




Ctrl Fn F2 || ||




Use arrow keys to peruse the Mac ribbon
|| || || || || || ||




Mac Settings to Disable
|| || ||




(1) Function Keys: Settings - Keyboard - Use F1, F2, etc. keys as standard function keys
|| || || || || || || || || || || || || || ||




(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 || ||




Hit Fn and then the function key to use the function keys themselves on a Mac
|| || || || || || || || || || || || || || ||




Open a New Workout || || ||




Ctrl N ||




Cmnd N ||




The File Tab || ||




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: Ctrl O (Cmnd O)|| || || || || ||




Save a File: Ctrl S (Cmnd S)
|| || || || || ||

, Print a File: Ctrl P (Cmnd P)
|| || || || || ||




Save a File || ||




Ctrl S ||




Cmnd S ||




Print a File || ||




Ctrl P ||




Cmnd P ||




Open a File || ||




Ctrl O ||




Cmnd O ||




Toolbars
Within each of the main tabs you will find all of Excel's features, grouped by commands
|| || || || || || || || || || || || || || ||




Navigating to the Toolbars Without the Mouse || || || || || ||




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
|| || ||