Grade 12D Excel Midterm Exam

What formula would you use to calculate the total sales from all employees in the sheet?

• =SUM(B2:B8)

• =COUNT(B2:B8)

• =COUNTIF(B2:B8,">2000")

• =AVERAGE(B2:B8)

Which function is best suited for counting the total number of employees in the dataset?

• SUM

• COUNT

• COUNTIF

• AVERAGE

Which formula is used to count the number of employees who made sales above 2000?

• =COUNT(B2:B9)

• =COUNTIF(B2:B9,">2000")

• =SUM(B2:B9)

• =AVERAGE(B2:B9)

If a new employee is added to the dataset, what changes should be made to ensure COUNT and COUNTIF formulas remain accurate?

What is the difference between COUNT and COUNTIF functions?

Which formula is best suited for calculating the sum of all bonuses in the dataset?

• SUM

• COUNT

• COUNTIF

• AVERAGE

What would happen if you applied COUNT instead of COUNTIF in column G?

Which formula correctly calculates the total number of employees in the dataset?

• =COUNT(A2:A9)

• =COUNTIF(A2:A9,">0")

• =SUM(A2:A9)

• =COUNTIF(A2:A9, "*")

Which formula would correctly count the number of sales greater than 2000?

• =COUNT(B2:B9)

• =COUNTIF(B2:B9,">2000")

• =SUM(B2:B9)

• =IF(B2:B9>2000,"Yes","No")

Which formula should be used to find the total sales for all employees in the South region?

• =SUMIF(C2:C9, "South", B2:B9)

• =COUNTIF(C2:C9, "South")

• =SUM(B2:B9)

• =AVERAGEIF(C2:C9, "South", B2:B9)