NEW
Font size
S
M
L
XL
WorksheetsExcel
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.
a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
2.
In Excel it means Add
a)
Plus sign
b)
sort
c)
Forward slash
d)
asterisk
3.
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
a)
Average
b)
Minimum
c)
Filter
d)
Maximum
4.
Completes previously typed words when you begin to repeat the typing.
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
5.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
6.
2 or more cells that are selected to create a source to be used in a formula
a)
Range
b)
Max
c)
Filter
d)
Colums
7.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
8.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns
9.
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
10.
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
11.
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
12.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
13.
the sum of all numbers divided by the amount of numbers.
a)
Maximun
b)
Minimum
c)
Median
d)
Average
14.
What does this mean "######'?
a)
column is not wide enough
b)
column is missing numbers
c)
column is showing an error
d)
column is too narrow
15.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign
16.
In an excel forumula it means divide
a)
Forwardslash
b)
Backwards
c)
Skip
d)
Multiply
17.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
18.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
19.
a vertical line of cells
a)
Maximum
b)
Minimum
c)
Column
d)
Formulas
20.
Not next to each other
a)
non contiguous cells
b)
contiguous cells
c)
close cells
d)
apart cells
Reset
