Font size
S
M
L
XL
WorksheetsSpreadsheet Formula
Total questions: 15
Worksheet time: 15mins
Name
Class
Date
1.
What do all formulas begin with? (a)
Choose from the below words
%
[ ]
=
:
2.
What symbol do we use for multiplication in a Spreadsheet program?
a)
/
b)
=
c)
^
d)
*
3.
What symbol do we use for addition in a Spreadsheet program?
a)
/
b)
+
c)
=
d)
*
4.
What symbol do we use for subtraction in a Spreadsheet program?
a)
/
b)
*
c)
+
d)
-
5.
What symbol do we use for division in a Spreadsheet program?
a)
/
b)
*
c)
+
d)
=
6.
Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?
a)
A4-A3=
b)
A3-A4=
c)
=A4-A3
d)
=A3-A4
7.
Which of the following tells a Spreadsheet to Divide the value in cell A3 by 27?
a)
=27/A3
b)
= A3/27
c)
= 27^A3
d)
=A3*27
8.
Which of the following formulas will add cells A1 thru A5?
a)
=SUM(A2+A5)
b)
=A1+A2+A3+A4+A5
c)
=A1:A5
d)
=A1-A2-A3-A4-A5
9.
Which of the following is a formula that will divide cell D10 by 2?
a)
=D10/A2
b)
10/2
c)
=D10*2
d)
=D10/2
10.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
11.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
12.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
13.
What formula should be written in cell D2 if I wanted to add the number in cell B2 with the number in cell C2?
a)
498+5
b)
=B2+C2
c)
B2/C2
d)
B2+C2=
14.
What is the name of this part of a Spreadsheet?
a)
Row
b)
Column
c)
Letters
d)
Cell
e)
Spreadsheet
15.
What column contains the days of the week?
a)
A
b)
B
c)
1
d)
2
Reset
