Excel Formula
Authored by Leigh Sinderson
Computers, Education, Other
10th Grade
Used 94+ 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?
Similar Resources on Wayground
10 questions
My childhood
Quiz
•
7th - 10th Grade
11 questions
Hero Gayab Mode On
Quiz
•
6th - 12th Grade
10 questions
hardware and software(g3)
Quiz
•
2nd - 10th Grade
19 questions
Les endroits dans la ville
Quiz
•
7th Grade - University
20 questions
REVISION 4 : TOPIC 9 [ACCOUNTING FOR NON-CURRENT ASSETS]
Quiz
•
1st Grade - University
15 questions
KD 3.1_Aplikasi Pengolah Angka / Spreadsheet
Quiz
•
10th Grade
14 questions
Input, output and storage de
Quiz
•
8th Grade - Professio...
10 questions
Driving Theory Test: Alertness
Quiz
•
KG - Professional Dev...
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
