NEW
Font size
S
M
L
XL
Worksheetsinformatica
Total questions: 23
Worksheet time: 12mins
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.
Completes previously typed words when you begin to repeat the typing.
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
6.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
7.
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
8.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
9.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
10.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns
11.
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
12.
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
13.
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
14.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
15.
the sum of all numbers divided by the amount of numbers.
a)
Maximun
b)
Minimum
c)
Median
d)
Average
16.
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
17.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign
18.
In an excel forumula it means divide
a)
Forwardslash
b)
Backwards
c)
Skip
d)
Multiply
19.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
20.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
21.
a vertical line of cells
a)
Maximum
b)
Minimum
c)
Column
d)
Formulas
22.
Not next to each other
a)
non contiguous cells
b)
contiguous cells
c)
close cells
d)
apart cells
23.
Not next to each other
a)
non contiguous cells
b)
contiguous cells
c)
close cells
d)
apart cells
Reset
