wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel

Total questions: 20

Worksheet time: 10mins

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.

A function in Excel is represented by what to letters?

a)

f( )

b)

xF

c)

xf

d)

fx

8.

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

9.

What version of Excel are we using in class?

a)

Excel 2016

b)

Excel 2017

c)

Excel 2018

d)

Excel 2015

10.
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 
11.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
12.
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
13.
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
14.
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
15.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
16.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
17.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
18.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
19.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
20.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol