S1 Spreadsheets Functions/Formulae
Authored by Nick Allen
Computers, Business
7th - 11th Grade
Used 50+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
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?
