Font size
WorksheetsGrade 12D Excel Midterm Exam
Total questions: 17
Worksheet time: 19mins
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)
How would you modify the COUNTIF formula to count sales above 2500 instead of 2000?
Change the criteria in COUNTIF to ">2500"
Add 500 to each cell before counting
Use COUNT instead
Replace COUNTIF with SUMIF
Which of the following is NOT a valid use of COUNTIF?
Counting sales above a specific value
Counting employees in a department
Summing all sales
Counting empty cells
How can you use SUM to calculate the total earnings (Sales + Bonus) for each employee?
Which formula can be used to count how many employees have bonuses greater than 500?
=COUNTIF(D2:D9,">500")
=SUM(D2:D9,">500")
=COUNT(D2:D9)
=IF(D2:D9>500,1,0)
Which of the following is the best use of a macro in Excel?
Automating repetitive tasks like applying SUM to a new dataset
Manually entering formulas into each cell
Typing COUNTIF for every entry individually
Sorting data once
How can macros be used to automate sales analysis with COUNTIF?
Macros can automate COUNTIF calculations for different ranges, making sales analysis faster without manually entering formulas.
Explain how a macro could be used to automate the process of counting sales over 2000 in multiple sheets.
A macro can be written to apply COUNTIF to multiple sheets, summarizing the count of sales over 2000 automatically.
