Wall Street Prep: Excel Exam 2023 with complete solution Graded A

Add/delete sheets - CORRECT ANS alt-i-w OR alt h-i-s Moving around task ribbon - CORRECT ANS Tab and shift (to select) Auto fit cell - CORRECT ANS alt-h-o-i Custom fit columns - CORRECT ANS alt h-o-w Custom fit rows - CORRECT ANS alt h-o-h Select entire column/row - CORRECT ANS ctrl shift-arrow key Format cells - CORRECT ANS ctrl 1 Paste special - CORRECT ANS alt e-s Freeze panes - CORRECT ANS alt w-f-f Split panes - CORRECT ANS alt w-s Move between panes - CORRECT ANS F6 Get in cell AND navigate to others while inside - CORRECT ANS F2 Edit a cell from the outside - CORRECT ANS alt h-e Add comments - CORRECT ANS Shift F2 Right (and down) fill - CORRECT ANS Ctrl (d) r Insert/delete row - CORRECT ANS alt i-r/h-d-r Insert/delete column - CORRECT ANS alt i-c/h-d-c Date formatting - CORRECT ANS Ctrl shift # Currency formatting - CORRECT ANS Ctrl shift $ Percentage formatting - CORRECT ANS Ctrl shift % Number formatting - CORRECT ANS Ctrl shift ! Anchoring a cell - CORRECT ANS F4 Group columns - CORRECT ANS Ctrl space; shift alt right; hide: alt a-h && show: alt a-j Group rows - CORRECT ANS Shift space; shift alt right; hide: alt a-h && show: alt a-j Auditing Cell - CORRECT ANS Ctrl [ = highlights precedent cell Ctrl ] highlights dependent cell alt m-p highlights precedent cell alt m-d highlights dependent cell alt m-a-a erases arrows Center across selection - CORRECT ANS Better than merge; effectively does same thing Go to special - CORRECT ANS F5 alt s Conditional Formatting - CORRECT ANS Custom: alt o-d Native: alt h-l Page breaks - CORRECT ANS alt enter =SUM() - CORRECT ANS Sums values; alt = is shortcut =AND() - CORRECT ANS True if all arguments are true =OR() - CORRECT ANS True if one of more arguments are true =IF() - CORRECT ANS Condition, output for true, output for false =IFS() - CORRECT ANS Better than nested IF, last argument is TRUE =IFERROR() - CORRECT ANS If there is an error, then a certain output is given Concatenation - CORRECT ANS Making dynamic headers with & =EOMONTH() - CORRECT ANS Gives date at end of month from specific start date =EDATE() - CORRECT ANS Gives exact date from specific start date