Font size
S
M
L
XL
WorksheetsSpreadsheet Exam
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
A formula will always start with a ?
a)
Plus
b)
Number
c)
Equal Sign
d)
Parentheses
2.
A number in a Spreadsheet is called?
a)
Formula
b)
Value
c)
Cell
d)
Calculator
3.
What formulas is used to Calculate the Selling Price?
4 lines
4.
What formula is required to get the Total in B16?
4 lines
5.
What formula is required to get the average in B17?
4 lines
6.
What formula is required to insert today's date in a cell?
a)
today()
b)
=today)(
c)
=today()
7.
Give the correct formulas to calculate the Sales Tax.
4 lines
8.
What does cell formatting mean?
a)
Changing what the cell means
b)
Formatting the layout
c)
Changing the appearance
d)
None of them
9.
What word is used to describe re-organising the order of data
a)
Sorting
b)
Filtering
c)
Search
d)
Fill
10.
What does the # mean in this worksheet?
4 lines
Reset
