Q: A data analyst at an e-commerce company is working with a spreadsheet containing last month’s sales. The most expensive product their company sells costs $49.99, so they want to quickly confirm that all of the data in the Sales column is $49.99 or less. What function can they use?
or
Q: An e-commerce company’s data analyst is examining a spreadsheet that shows the sales for the previous month. Their company’s most costly product is $49.99, therefore they need to make sure right away that every piece of information in the Sales column is $49.99 or less. What purpose are they able to serve?
- SUMIF
- COUNT
- SUM
- COUNTIF
Explanation: To rapidly verify if all of the information included in the Sales column is equal to or lower than $49.99, the data analyst might make use of the “MAX” function. The MAX function returns the value that is the highest among a group of numbers; if the maximum value is $49.99 or below, it shows that all of the values are within the range that was supplied.
