Part 2: Excel Basic Functions Quiz – SUM, AVERAGE, COUNT (20 MCQ)

Correct answer: A. SUM

★ Key Takeaway: Use SUM to add numbers across one or more cells.

Explanation: SUM adds all numeric values in the cells you specify. For example, =SUM(A1:A5) adds the values from A1 through A5.

Why other options are incorrect:

• B. AVERAGE – This calculates the mean of numbers, not the total.
• C. COUNT – This counts how many cells contain numbers; it does not add them.
• D. MIN – This returns the smallest value in a range, not the sum.

Tip: Want to get comfortable with Excel functions fast? A 1-on-1 Excel tutor can help you practice SUM, AVERAGE, and COUNT with real examples. Explore 1-on-1 Excel tutoring on Fiverr →

Correct answer: B. =SUM(A1:A5)

★ Key Takeaway: Excel functions start with an equals sign and use a colon to represent a range.

Explanation: The equals sign tells Excel it’s a formula, and A1:A5 means “from A1 to A5.” SUM then adds those values.

Why other options are incorrect:

• A. SUM(A1-A5) – This is missing the equals sign and uses a dash instead of a range reference.
• C. =ADD(A1:A5) – ADD is not a standard Excel function name.
• D. =TOTAL(A1:A5) – TOTAL is not the correct built-in function for summing a range.

Correct answer: B. AVERAGE

★ Key Takeaway: AVERAGE finds the mean value of the numbers you select.

Explanation: AVERAGE adds the numbers and divides by how many numeric values are included. For example, =AVERAGE(B1:B4) returns the mean of those cells.

Why other options are incorrect:

• A. SUM – SUM totals the values; it does not divide to find the mean.
• C. COUNT – COUNT returns how many numeric entries exist; it does not compute an average.
• D. MAX – MAX returns the largest value, not the average.

Correct answer: D. Counts cells that contain numbers

★ Key Takeaway: COUNT counts numeric entries, not text.

Explanation: COUNT ignores text and blank cells. For example, if A1 has 10, A2 has “Hi”, and A3 is blank, =COUNT(A1:A3) returns 1.

Why other options are incorrect:

• A. Counts all non-empty cells – That describes COUNTA, not COUNT.
• B. Counts cells that contain formulas only – COUNT doesn’t limit to formulas; it counts numeric values (including formula results if numeric).
• C. Counts the number of worksheets – Worksheet counting is not what COUNT does.

Correct answer: A. COUNTA

★ Key Takeaway: COUNTA counts any cell with content, not just numbers.

Explanation: COUNTA includes text, numbers, and even formula results as long as the cell is not blank. It’s useful for counting how many entries are filled in a list.

Why other options are incorrect:

• B. COUNT – COUNT only counts numeric cells and ignores text.
• C. SUM – SUM adds numeric values; it does not count filled cells.
• D. AVERAGE – AVERAGE calculates the mean of numbers; it does not count non-empty cells.

Correct answer: C. =FUNCTION(arguments)

★ Key Takeaway: Functions use parentheses to hold arguments.

Explanation: Excel functions follow a consistent structure: equals sign, function name, then arguments inside parentheses, such as =SUM(A1:A5).

Why other options are incorrect:

• A. FUNCTION A1:A5 – This is missing the equals sign and parentheses.
• B. FUNCTION=arguments – The equals sign goes at the beginning, and arguments must be inside parentheses.
• D. =FUNCTION[arguments] – Excel functions use parentheses, not square brackets, for arguments.

Correct answer: D. =SUM(A1:A3, C1:C3)

★ Key Takeaway: SUM can add multiple ranges by separating arguments with commas.

Explanation: SUM accepts multiple arguments, such as separate ranges or individual cells. Using a comma lets Excel treat them as two inputs to the same function.

Why other options are incorrect:

• A. =SUM(A1:A3:C1:C3) – This is not valid range syntax; a colon is for one continuous range only.
• B. =ADD(A1:A3, C1:C3) – ADD is not a standard Excel function.
• C. =SUM(A1-A3 + C1-C3) – Dashes and plus signs here don’t correctly define ranges in SUM.

Correct answer: B. 20

★ Key Takeaway: AVERAGE adds the numbers and divides by how many numbers you provided.

Explanation: 10 + 20 + 30 = 60, and there are 3 numbers. 60 divided by 3 equals 20.

Why other options are incorrect:

• A. 10 – This is the smallest value; AVERAGE returns the mean, not the minimum.
• C. 30 – This is the largest value; AVERAGE returns the mean, not the maximum.
• D. 60 – 60 is the sum, not the average.

Correct answer: C. AutoSum

★ Key Takeaway: AutoSum is the fastest way to create a basic SUM total.

Explanation: AutoSum automatically suggests a nearby range to add and inserts a SUM function for you. It’s especially useful for quickly totaling columns or rows.

Why other options are incorrect:

• A. Freeze Panes – This keeps rows or columns visible while scrolling; it does not insert formulas.
• B. Find and Replace – This searches and changes text or values; it does not create totals.
• D. Page Break Preview – This is a view for printing layout; it does not help build formulas.

Tip: If function syntax still feels confusing, a tutor can help you practice AutoSum, ranges, and common functions until it feels natural. Find an Excel tutor on Fiverr →

Correct answer: B. MIN

★ Key Takeaway: MIN finds the lowest value in the selected cells.

Explanation: MIN scans the range and returns the smallest numeric value. For example, =MIN(D2:D10) returns the lowest number in that range.

Why other options are incorrect:

• A. MAX – MAX returns the largest value, not the smallest.
• C. COUNT – COUNT returns how many numeric cells exist; it does not return the smallest value.
• D. AVERAGE – AVERAGE returns the mean, not the minimum.

Correct answer: A. MAX

★ Key Takeaway: MAX returns the highest value in the selected cells.

Explanation: MAX looks through the numbers in a range and returns the largest one. For example, =MAX(D2:D10) gives the top value.

Why other options are incorrect:

• B. MIN – MIN returns the smallest value, not the largest.
• C. AVERAGE – AVERAGE returns a middle value (mean), not the maximum.
• D. COUNTA – COUNTA counts non-empty cells; it does not find the largest number.

Correct answer: D. =SUM(A1, A3, A5)

★ Key Takeaway: You can SUM specific cells by listing them as separate arguments.

Explanation: SUM accepts individual cell references separated by commas. This adds only those cells, not the entire range.

Why other options are incorrect:

• A. =SUM(A1:A5) – This includes A2 and A4 as well, not just A1, A3, and A5.
• B. =SUM(A1-A3-A5) – Dashes represent subtraction logic and do not correctly list separate cells for SUM.
• C. =ADD(A1, A3, A5) – ADD is not a standard Excel function.

Correct answer: B. It averages only the numeric values

★ Key Takeaway: AVERAGE ignores text in cells when calculating the mean.

Explanation: AVERAGE evaluates numeric values in the referenced cells and ignores text entries. This helps keep the average based on actual numbers rather than labels.

Why other options are incorrect:

• A. It averages numbers and text together – Text in cells is not averaged as part of the calculation.
• C. It returns the number of text cells – Counting text is not the purpose of AVERAGE.
• D. It automatically converts all text to zero – Text values are ignored in cell references rather than converted to zero.

Correct answer: C. COUNT

★ Key Takeaway: COUNT is ideal when you only want to count numeric entries.

Explanation: In typical datasets like marks or sales numbers, COUNT quickly tells you how many numeric items exist, which is useful for validation and reporting.

Why other options are incorrect:

• A. COUNTA – COUNTA counts text and numbers; it’s not specific to numeric scores.
• B. AVERAGE – AVERAGE calculates the mean; it does not count entries.
• D. SUM – SUM adds values; it does not count how many numbers there are.

Correct answer: C. =AVERAGE(B2:B6)

★ Key Takeaway: AVERAGE uses a colon to define a continuous range.

Explanation: B2:B6 means all cells from B2 to B6. AVERAGE then calculates the mean of the numeric values in that range.

Why other options are incorrect:

• A. =MEAN(B2:B6) – MEAN is not the standard Excel function name for average.
• B. =AVG(B2-B6) – AVG is not the standard Excel function name, and the dash is not valid range syntax.
• D. =AVERAGE(B2,B6) – This averages only two cells (B2 and B6), not the full range B2 through B6.

Correct answer: A. SUM

★ Key Takeaway: Use SUM for totals in real-world spreadsheets like sales, expenses, and budgets.

Explanation: SUM is designed for adding numeric values across a range, which is exactly what you need for totals such as monthly sales or total expenses.

Why other options are incorrect:

• B. COUNT – COUNT tells you how many numeric entries exist, not the total amount.
• C. AVERAGE – AVERAGE returns the mean value, not the full total.
• D. COUNTA – COUNTA counts filled cells, not the sum of the values.

Correct answer: A. Excel treats it as text and does not calculate

★ Key Takeaway: Excel formulas must start with an equals sign to calculate.

Explanation: Without the equals sign, Excel assumes you are entering plain text. To perform a calculation, you must type =SUM(A1:A5).

Why other options are incorrect:

• B. Excel automatically adds the equals sign – Excel does not automatically correct this; it will display what you typed as text.
• C. Excel shows an error and deletes the entry – Excel typically stores it as text rather than deleting it.
• D. Excel calculates but hides the formula – Calculation only occurs when the entry is a formula starting with an equals sign.

Correct answer: C. AVERAGE

★ Key Takeaway: AVERAGE is the standard function for typical “mean score” calculations.

Explanation: If student scores are in a range like C2:C31, =AVERAGE(C2:C31) returns the class average, which is commonly used for reporting performance.

Why other options are incorrect:

• A. COUNT – COUNT tells you how many numeric scores there are, not their average.
• B. SUM – SUM gives the total score, not the average score.
• D. MAX – MAX returns the highest score, not the average.

Correct answer: D. =COUNT(D1:D10)

★ Key Takeaway: COUNT counts numeric cells; COUNTA counts non-empty cells.

Explanation: If D1:D10 includes numbers, text labels, and blanks, COUNT includes only the numeric entries. This is useful for checking how many valid numbers were entered.

Why other options are incorrect:

• A. =COUNTA(D1:D10) – COUNTA counts text and numbers, so it may return a higher count than COUNT.
• B. =SUM(D1:D10) – SUM adds numbers; it does not count how many numbers appear.
• C. =AVERAGE(D1:D10) – AVERAGE calculates the mean of numbers; it does not count numeric cells.

Correct answer: B. They automate common calculations and reduce manual errors

★ Key Takeaway: Functions help you calculate faster and more accurately.

Explanation: Instead of adding or averaging values manually, you can use functions like SUM and AVERAGE to update results automatically when your data changes, which saves time and lowers mistakes.

Why other options are incorrect:

• A. They make spreadsheets look more colorful – Formatting controls appearance; functions focus on calculations and results.
• C. They prevent anyone from editing a workbook – Protection features control editing; functions do not lock files.
• D. They are only useful for printing worksheets – Printing is unrelated; functions are mainly for calculating and analyzing data.