Grade 12D Excel Midterm Exam
Authored by Dina Sharawy
Information Technology (IT)
12th Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
17 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is best suited for counting the total number of employees in the dataset?
SUM
COUNT
COUNTIF
AVERAGE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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)
4.
OPEN ENDED QUESTION
3 mins • 1 pt
If a new employee is added to the dataset, what changes should be made to ensure COUNT and COUNTIF formulas remain accurate?
Evaluate responses using AI:
OFF
5.
OPEN ENDED QUESTION
3 mins • 1 pt
What is the difference between COUNT and COUNTIF functions?
Evaluate responses using AI:
OFF
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula is best suited for calculating the sum of all bonuses in the dataset?
SUM
COUNT
COUNTIF
AVERAGE
7.
OPEN ENDED QUESTION
3 mins • 1 pt
What would happen if you applied COUNT instead of COUNTIF in column G?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
