WorksheetsSpreadsheet Revision
Total questions: 20
Worksheet time: 9mins
Name
Class
Date
1.
What does every formula in a spreadsheet start with?
a)
+
b)
A number
c)
=
d)
(
2.
Which software would be used to create a spreadsheet?
a)
Access
b)
Excel
c)
Word
d)
Powerpoint
3.
Which formula is the best (and correct) for adding up a selection of numbers
a)
sum(A1+A10)
b)
=sum(A1+A10)
c)
=sum(A1:A10)
d)
sum(A1:A10)
4.
Each box on a spreadsheet is called a ...
a)
row
b)
column
c)
cell
d)
box
5.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
6.
Columns on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
space
d)
smiley face
7.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
8.
The location of a cell on a spreadsheet. It is a column letter followed by a row number.
a)
Cell range
b)
Cell reference
c)
Active cell
d)
Row
9.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
10.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
11.
Which formula would you use to calculate how many sales are over $20 from a series.
a)
sum
b)
sumif
c)
count
d)
countif
12.
A ___________ conveys a visual representation of data.
a)
chart
b)
picture
c)
text box
d)
style
13.
_____ are vertical.
a)
Rows
b)
Columns
14.
________ are horizontal
a)
Rows
b)
Columns
15.
This function counts the number of numeric entries in a list. It will ignore blanks, text and errors.
a)
COUNT
b)
COUNTA
c)
COUNTBLANK
d)
COUNTIF
16.
This function counts the number of numeric or text entries in a list. It will ignore blanks.
a)
COUNT
b)
COUNTA
c)
COUNTBLANK
d)
COUNTIF
17.
A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.
a)
Line Chart
b)
Pie Chart
c)
Bar Chart
d)
Graphs
18.
A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.
a)
Bar Chart
b)
Pie Chart
c)
Graphs
d)
Line Chart
19.
A type of chart which displays information as a series of data points called 'markers' connected by straight line segments.
a)
Pie chart
b)
Line Chart
c)
Bar Graphs
d)
Graphs
20.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign
100 %
