Wall Street Prep: Excel Crash Course Exam Questions (246 Terms) With Verified Definitions Updated 2024

Save As Shortcut {Ans: Alt F A}Pivot Tables {Ans: An efficient, visual tool for analyzing, exploring, and presenting large amounts of data It is particularly useful when your data needs to be sliced and diced in a variety of ways Answers Questions Like: (1) Which property type is most expensive/most common in a specific region? (2) Which REIT had the greatest sales within a specific region or for a specific property type? Has the ability to pivot, or quickly swap out different row and column parameters to observe data in different ways}SUMIF {Ans: =SUMIF(range, criteria, sum range) adds the cells specified by a given criteria The range is the range that you want to evaluate with the criteria, whereas the sum range is what is actually summed Criteria can either be hardcoded which requires quotation marks as you see in the picture, or a direct cell reference (which would not need quotes around it)}Basic Excel Drills {Ans: Most keyboard shortcuts involves Alt or Ctrl keys Alt: Press each key and let go (do you NOT need to hold to the Alt key) Ctrl: Ctrl key must be held down as you press the other key in