S1 Spreadsheets Functions/Formulae
Quiz
•
Computers, Business
•
7th - 11th Grade
•
Medium
Nick Allen
Used 50+ times
FREE Resource
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used at the beginning of all formulae and functions?
+
-
=
$
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used in a formula for adding?
*
-
/
+
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used in a formula for subtracting?
*
-
/
+
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used in a formula for multiplying?
*
-
/
+
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used in a formula for dividing?
*
-
/
+
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to add up A1 and B1?
=SUM(A1:B1)
=A1+B1
A1+B1
=ADD(A1:B1)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to work out A2 take away B2?
A2-B2
=A2-B2
=SUB(A2:B")
=A2MINUSB2
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
15 questions
Estadística Descriptiva y Técnicas de Investigación
Quiz
•
1st Grade - University
10 questions
Tin 7 - KT cuối kì 2
Quiz
•
7th Grade
12 questions
KT GHK2 Tin 7
Quiz
•
6th - 8th Grade
15 questions
EXCEL
Quiz
•
8th Grade
10 questions
Excel basico inseya
Quiz
•
6th - 9th Grade
10 questions
PENTAKSIRAN : ASK TINGKATAN 1
Quiz
•
1st - 8th Grade
15 questions
Excel informática octavo
Quiz
•
8th Grade
18 questions
Ulangan kelas 7 informatika bab 6 semester 2 kurikulum merdeka
Quiz
•
7th Grade
Popular Resources on Wayground
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Order of Operations
Quiz
•
5th Grade
20 questions
Halloween
Quiz
•
5th Grade
16 questions
Halloween
Quiz
•
3rd Grade
12 questions
It's The Great Pumpkin Charlie Brown
Quiz
•
1st - 5th Grade
20 questions
Possessive Nouns
Quiz
•
5th Grade
10 questions
Halloween Traditions and Origins
Interactive video
•
5th - 10th Grade
