Excel Functions for Students

What does the COUNTA function do in Excel?

• Calculates the average of a range of cells.

• Counts only empty cells in a range.

• Counts non-empty cells in a range.

• Finds the maximum value in a range of cells.

How would you use COUNTIF to count students with marks above 75?

• COUNTIF(A1:A10, ">75")

• COUNTIF(A1:A10, "<75")

• COUNTIF(A1:A10, ">=75")

• COUNTIF(A1:A10, "=75")

What is the purpose of the SUMIF function in Excel?

• To calculate the average of a range of values.

• To sum values based on a specified condition.

• To count the number of cells that meet a condition.

• To find the maximum value in a dataset.

If a student scored 85, how would you use COUNTIF to check how many scored above that?

• COUNTIF(range, "85")

• COUNTIF(range, "<85")

• COUNTIF(range, ">85")

• COUNTIF(range, ">=85")

What type of data can COUNTA count in a range?

• COUNTA can only count numeric values.

• COUNTA can count non-empty cells, including text, numbers, logical values, and errors.

• COUNTA counts only empty cells.

• COUNTA can count only text values.

How can you use SUMIF to calculate total marks for students who passed?

• =SUMIF(B:B, ">=50")

• =SUMIF(B:B, "<=50")

• =SUMIF(B:B, "=50")

• =SUMIF(B:B, "<50")

What is the difference between COUNTIF and COUNTA?

• COUNTIF counts based on criteria; COUNTA counts non-empty cells.

• COUNTIF counts text cells; COUNTA counts only numeric cells.

• COUNTIF counts unique values; COUNTA counts duplicates.

• COUNTIF counts all cells; COUNTA counts only empty cells.

How would you write a formula to count the number of students who scored exactly 90?

• =COUNTIF(range, 90)

• =COUNT(range)

• =AVERAGEIF(range, 90)

• =SUMIF(range, 90)

Can SUMIF be used with text criteria? Give an example.

• No, SUMIF can only be used with numerical criteria.

• Yes, SUMIF can be used with text criteria.

• Text criteria can only be used with the AVERAGE function.

• SUMIF cannot handle text criteria in any form.

What would be the result of COUNTA in a range with 5 empty cells?

• 5

• 1

• 3

• 0