ICT Paper A - Grade 5
Authored by Rabya Sayed
Computers
5th Grade
Used 11+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
AutoSum feature calculates the lowest value in the list.
True
False
Partially Correct
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Using the given spreadsheet the correct formula to find the average of values from A4 through D4 will be:
AVERAGE(B4:D4)
AVG(A4:D4)
AVG(N/A,B4:D4)
AVERAGE(A4:D4)
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Using the spreadsheet given the correct answer to the formula =Count(A1:D4) will be:
4
16
14
None of the Above
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Using the spreadsheet given the correct answer to the formula =CountA(A1:D4) will be:
4
16
14
None of the Above
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Using the spreadsheet given the correct answer to the formula =MIN(A1:D4) will be:
N/A
N/A, N/A
3
18
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Using the given spreadsheet the correct answer to the formula MAX(A1:D4) will be:
203
900
750
400
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Using the given spreadsheet choose the correct Excel formula to find all the values greater than 100.
COUNTIF(A1:D4, "><100")
COUNTIF(A1:D4, ">=100")
COUNTIF(A1:D4, ">100")
COUNTIF(A1:D1, "=>100")
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?
