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

📚 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