Wall Street Prep: Excel questions with accurate answers (verified)Graded A+
Number formatting - Answer-Ctrl shift ! Anchoring a cell - Answer-F4 Group columns - Answer-Ctrl space; shift alt right; hide: alt a-h && show: alt a-j Group rows - Answer-Shift space; shift alt right; hide: alt a-h && show: alt a-j Auditing Cell - Answer-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 - Answer-Better than merge; effectively does same thing Go to special - Answer-F5 alt s Conditional Formatting - Answer-Custom: alt o-d Native: alt h-l
Written for
- Institution
- Wall Street Prep: Excel
- Course
- Wall Street Prep: Excel
Document information
- Uploaded on
- October 17, 2023
- Number of pages
- 4
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
wall street prep excel questions with accurate an
-
select entire columnrow answer ctrl shift arrow
-
split panes answer alt w s
-
get in cell and navigate to others while inside
Also available in package deal