9) Microsoft Excel is widely used in many businesses due to its versatility and usefulness. Which of the following is a function of Excel? a) Create charts and reports b) Analyze and sort through data c) Perform calculations quickly especially with large data sets d) a &b e) a.b&c Question 10 An online streaming service has increased their stock price over the years. In their most recent year ending 2019, their stock price change were 60%, 50%, 25%, 10% for Q1, Q2, Q3.94 respectively. True or False: The online streaming service experienced a decline in stock price during 2019. (Hint: knowing the beginning stock price is not necessary to answer this question. If you insist or for more peace of mind, use round numbers for easier calculation (ex. $10] b) True False Question 11 Which of the following is TRUE of a company's market capitalization (or "market cap")? Calculated by the book value found in financial statements Calculated by the past three full years of revenue Calculated by the current shares outstanding multiplied by current share price Not a popular way to rank size of publicly traded companies Question 12 On a new assignment at work, your team asked to analyze how Product A, B, and Care performing. The CEO indicated there is only budget for two products. As part of the data collection process, your team was able to collect data from your three retail locations in NYC, San Francisco, and Dallas. The data was then broken down into profit, revenue, and expenses for each location, each product, and each quarter. After working on this project, your team uncovered the following: *Most profitable categories: Product-B, Location-Dallas, Quarter-1 Which Excel tool/formula would be the most efficient to uncover the findings above? a) COUNTIF formula b) LOOKUP formula c) Pivot table d) function ABC O