Question 9 Microsoft Excel is widely used in many businesses due to its versatility and usefulness. Which of the following is a function of Excel? 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 1.22,23,24 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. $101) True False Question 11 From the income statement below, what happens to "Gross profit" of $10,500 if income taxes decrease from 25% to 10%? Income Statement $15.000 Net Sales 4.500. Cost of Goods Sold $10,500 Gross Profit 1.2.590. Operating Expense $ 7,000 Net Income Before Tax $X.XXX. Income Tax @ 25% $ XXXX Net Income (Loss) Increase d) Decrease b) Stays the same d) Increase first and then decrease Question 12 On a new assignment work, your team is asked to analyze how Product A, B, and C are 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) Sorting function