CAT G11 Excel - Extra activity
Authored by Rene Leus
Computers
11th Grade
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
6 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
3 mins • 4 pts
What function would we use to calculate the total amount paid by Grade 10 learners?
Type out the full function in the space provided, with the relevant cells included.
2.
FILL IN THE BLANK QUESTION
3 mins • 3 pts
What function would we use to determine how many learners are male?
Type out the full function in the space provided, with the relevant cells included.
3.
FILL IN THE BLANK QUESTION
1 min • 2 pts
What function would we use to calculate the least amount paid?
Type out the full function in the space provided, with the relevant cells included.
4.
FILL IN THE BLANK QUESTION
2 mins • 3 pts
What function would we use to calculate the third-lowest amount paid?
Type out the full function in the space provided, with the relevant cells included.
5.
FILL IN THE BLANK QUESTION
2 mins • 3 pts
What function would we use to assign a random number between 10 and 40 to the learners?
Type out the full function in the space provided, with the relevant cells included.
6.
FILL IN THE BLANK QUESTION
2 mins • 3 pts
Provide a function that will give the answer for what is demonstrated in the image.
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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
