Excel Beginner
Excel Intermediate
Terminology
Graphs
Excel Gurus
100
A _________ consists of a grid made from columns and rows. When you open excel, one of these opens automatically. More can be added if needed by clicking the + symbol at the bottom.
Worksheet
100
What is the symbol for subtraction?
A) +
B) *
C) /
D) None of these
D) None of these.
The symbol for subtraction is -
100
This is a more advanced part of a spreadsheet that allows the user to perform calculations and manipulate data within the spreadsheet.
Formula
100
Name the type of chart/graph
Pie Chart
100
The shading or fill cell button looks like a .....
Paint tin/bucket pouring paint.
200
Which of the following is not a basic part of a spreadsheet?
A) Cell
B) Column
C) Row
D) Formula
D) Formula
200
What is the symbol for addition in excel?
A) -
B) +
C) =
D) /
B) +
200
Name this type of graph
Bar graph
200
To change the font, what tab of the ribbon do you need to be in
(Across the top?)
HOME
300
Name this cell ...
B6
300
The symbol for division is ...
/
300
This is a digital tool used for organising and analysing data. Excel is an example of this
Spreadsheet
300
Name this type of graph
Line graph
300
The AUTOSUM function button is located in which tab of the ribbon?
FORMULAS
400
____________ are used to designate each row's location.
(What is used to name them?)
Numbers
400
All formulas must begin with this symbol ...
=
400
This symbol is used to indicate that the following characters are part of a formula and not just regular text.
=
400
What would you call the red dot?
An outlier
400
The WHAT IF ANALYSIS button is located in which tab of the ribbon?
DATA
500
What is used to designate each column's location?
(What is used to give the columns titles)
Letters
or the alphabet
500
The _______ function adds all of the indicated cells together and divides by the total number of cells.
Average
500
Which axis runs vertically on a graph?
Y
Y to the sky!
500
Name this type of graph
Scatter plot
500
The CHARTS button is located in which tab of the ribbon?
INSERT