Excel Formula
Authored by Leigh Sinderson
Computers, Education, Other
10th Grade
Used 95+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
1 min • 1 pt
What symbol must be at the beginning of every formula you write in a spreadsheet?
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=SUM(A1,A3,A4)
What is the purpose of this formula?
To add up the values referenced inside the brackets.
To multiply the values referenced inside the brackets
To compare the values referenced inside the brackets.
To find a value in the cells referenced inside the brackets.
3.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
=ROUND(AVERAGE(B2:B7), 0)
Select all statements that apply.
[Maximum: 3]
This formula includes cell referencing
This formula will find the mean number in the range selected.
This formula will round the answer to 2 decimal places.
The formula will produce a whole number as an answer.
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which formulas below will count the number of items with a cost above £1.50?
=COUNT(IF(B2>1.5))
COUNTIF(B2-B7, >1.5)
=COUNTIF(B2:B7, ">1.5")
COUNTIF(B2:B7, ">1.5")
5.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
=ROUND(A1*$C$3, 2)
Select all that apply.
[Maximum: 2]
This formula includes absolute referencing
This formula will add the values in the two cells.
This formula will round the answer to 2 decimal places.
The formula will produce a whole number as an answer.
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Write a formula to find calculate the total stock level in the bakery for all of its products combined.
Your formula MUST include cell references.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which mathematical function does the symbol below represent?
*
To the Power of
Multiplication
Division
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?
