Revision - Microsoft Excel
Authored by nafaizatul .hashim
Computers
10th Grade - University
Used 80+ 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.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
What will be the answer for this formula: =average(A1,A3)
(a)
2.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
What will be the answer for this formula: =count(A1:C2)
(a)
3.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
What will be the answer for this formula: =min(B2:D4)
(a)
4.
FILL IN THE BLANKS QUESTION
45 sec • 1 pt
What will be displayed in cell A2 if you change the format to percent with 1 decimal place?
(a)
5.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
Write the correct formula to calculate Shawl predicted sales in April. The predicted sales are 15% more from the sales in March.
(a)
6.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
Write the correct formula to calculate Hoodie predicted sales in April. The predicted sales are 23% more from the sales in March.
(a)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
C3 contains the value 21, and C5 contains the text ICT0513. When the formula =C3/C5 is evaluated, an error is given. What could possibly be the error?
#DIV/0!
#VALUE!
#REF!
#NAME?
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?
