NEW
Font size
S
M
L
XL
WorksheetsExcel functions
Total questions: 17
Worksheet time: 8mins
Name
Class
Date
1.
What is the Sum formula?
a)
Sum( )
b)
Sum( )=
c)
=Sum( )
d)
=( )Sum
2.
When starting a formula what is the first thing you type in the cell?
a)
+
b)
-
c)
%
d)
=
3.
Excel spreadsheets that are already created and ready for you to edit are known as?
a)
spreadsheets
b)
templates
c)
data inputs
d)
pages
4.
Excel is useful for using ________ as opposed to words or presentations?
a)
Excel is useful in presenting
b)
Excel is useful in documents
c)
Excel is useful in numbers
d)
Excel is useful in publishing
5.
The letters in Excel represent the _______?
a)
columns
b)
rows
c)
data
d)
functions
6.
The numbers in Excel represent the _____?
a)
columns
b)
rows
c)
data
d)
functions
7.
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
a)
A1-C3
b)
A1-C3=
c)
=A1-C3
d)
=C3-A1
8.
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
9.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
10.
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
11.
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
12.
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
13.
the sum of all numbers divided by the amount of numbers.
a)
Maximun
b)
Minimum
c)
Median
d)
Average
14.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
15.
a vertical line of cells
a)
Maximum
b)
Minimum
c)
Column
d)
Formulas
16.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
17.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
Reset
