Excel Quiz
Authored by Mohammed Hannioui
Information Technology (IT)
1st Grade
Used 1+ times
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.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to calculate the amount of sales for each product?
=C11+D11
=SUM(D11:D14)
=C11*D11
=C11*C12
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to calculate the total of Sales?
=SUM(C11:C14*D11:D14)
=C11:C14*D11:D14
=SUM(E11:E16)
=SUM(E11:E14)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to return the amount of tax according to the amount of Sales?
=E17*(1+D18)
=E17+E18
=E17*D18
=E17/D18
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula for the amount of Sales with tax?
=SUM(E11:E18)
=E17+E18*D18
=SUM(E17:E18)
=E17+E18
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
For each invoice, you want to add the current date in E1.
=16/03/2025
=TODAY()
=TODAY(TRUE)
=NOW()
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How to display each currency number (the unit price and the total) with only 2 digits and the currency symbol in each cell?
Reduce the number of digits
Apply the Accounting format
Apply the Standard format
Apply the Currency format
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?
