Formula and Chart Generation Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Data Analysis

What you'll be asked

  1. Which spreadsheet function is most appropriate for calculating the average value of a range of cells while ignoring empty cells or text?
  2. When creating a chart to visualize the trend of monthly sales revenue over the course of a fiscal year, which chart type is the industry standard?
  3. You have a dataset where you need to look up a customer's email address based on their unique Customer ID located in the first column. Which function should you use?
  4. What is the primary purpose of using absolute cell references (e.g., $A$1) in a spreadsheet formula?
  5. You are analyzing a dataset with 50,000 rows. You need to calculate the total sales for a specific product category, but only if the sales amount exceeds $500. Which function is required?

Answers and explanations come after you submit.