melissa204
melissa204 1d ago β€’ 0 views

Multiple Choice Questions on Google Sheets Functions: SUM, AVERAGE, COUNT

Hey there! πŸ‘‹ Learning Google Sheets functions like SUM, AVERAGE, and COUNT can seem tricky, but it's totally doable. I've put together a quick study guide and a practice quiz to help you nail it. Let's get started! πŸš€
πŸ’» Computer Science & Technology

1 Answers

βœ… Best Answer

πŸ“š Quick Study Guide

  • πŸ”’ The SUM function adds up numerical values. The syntax is `$SUM(value1, [value2, ...])`
  • πŸ“Š The AVERAGE function calculates the arithmetic mean of a range of numbers. The syntax is `$AVERAGE(value1, [value2, ...])`
  • πŸ“Œ The COUNT function counts the number of cells in a range that contain numerical values. The syntax is `$COUNT(value1, [value2, ...])`
  • πŸ“ Use ranges (e.g., A1:A10) to apply these functions to multiple cells at once.
  • πŸ’‘ These functions ignore text values unless they are within the COUNT function.
  • βž• You can combine these functions with other operators and functions for more complex calculations.
  • πŸ’° Remember to format cells appropriately (e.g., currency, percentage) for readability.

πŸ§ͺ Practice Quiz

  1. What function would you use to add the values in cells A1, A2, and A3?
    1. SUM(A1:A3)
    2. AVERAGE(A1:A3)
    3. COUNT(A1:A3)
    4. TOTAL(A1:A3)
  2. Which function calculates the average of the numbers 10, 20, 30, 40, and 50?
    1. SUM(10, 20, 30, 40, 50)
    2. AVERAGE(10, 20, 30, 40, 50)
    3. COUNT(10, 20, 30, 40, 50)
    4. MEDIAN(10, 20, 30, 40, 50)
  3. How do you count the number of cells containing numbers in the range B1:B10?
    1. SUM(B1:B10)
    2. AVERAGE(B1:B10)
    3. COUNT(B1:B10)
    4. NUMBER(B1:B10)
  4. What will `$SUM(2, "hello", 4)` return in Google Sheets?
    1. 6
    2. Error
    3. 2hello4
    4. 0
  5. Which function will return the number of cells containing numerical data in the range A1:A5, assuming all cells contain data?
    1. SUM(A1:A5)
    2. AVERAGE(A1:A5)
    3. COUNT(A1:A5)
    4. MAX(A1:A5)
  6. If cells C1, C2, and C3 contain 5, 10, and "apple" respectively, what does `$AVERAGE(C1:C3)` return?
    1. 5
    2. 10
    3. Error
    4. 7.5
  7. You have the numbers 1, 2, 3 in cells A1, A2, and A3. Which formula would return the sum of these numbers multiplied by 2?
    1. SUM(A1:A3)*2
    2. SUM(A1:A3,2)
    3. (A1+A2+A3)*2
    4. Both A and C
Click to see Answers
  1. A
  2. B
  3. C
  4. A
  5. C
  6. D
  7. D

Join the discussion

Please log in to post your answer.

Log In

Earn 2 Points for answering. If your answer is selected as the best, you'll get +20 Points! πŸš€