NEW
Font size
S
M
L
XL
WorksheetsReview of Spreadsheets
Total questions: 15
Worksheet time: 10mins
Name
Class
Date
1.
Columns are identified using _______?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
2.
Rows are identified using ________?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
3.
Which formula is the correct for adding a column of values?
a)
SUM(E4:E10)
b)
=SUM(E4:E10)
c)
=AVG(E4:E10)
d)
=MAX(E4:E10)
4.
What would you format a cell as when working with amounts of money?
a)
currency
b)
percent
c)
number
d)
scientific
5.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
6.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
7.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
8.
Which of the following operators (symbols) represent multiplication in EXCEL spreadsheets?
a)
+
b)
-
c)
*
d)
/
9.
Which of the following operators (symbols) represent division in EXCEL spreadsheets?
a)
+
b)
-
c)
*
d)
/
10.
A spreadsheet is made up of one "workbook" and can have have many "worksheets".
a)
True
b)
False
11.
Worksheets appear as tabs at the bottom of the spreadsheet.
a)
True
b)
False
12.
What is the correct order for the parts that make up a Cell Reference?
a)
Letter then Number
b)
Number then Letter
13.
What function should be entered to calculate the total budget?
a)
=AVERAGE(B3:B6)
b)
=SUM(B3:B6)
c)
=SUM(B3-B6)
d)
=TOTAL(B3:B6)
14.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
15.
Which of the following formulas show the correct use of the SUM function?
a)
-SUM(G3-G10)
b)
=SUM(G3...G10)
c)
=SUM(G3:G10)
d)
+SUM(G3:G10)
Reset
