Functions
Spreadsheets
Vocabulary
Functions
Random
100

What does the Fx button on a spreadsheet mean?

Function

100

When creating a spreadsheet graph, the horizontal axis is the _________ axis.

X

100
What is a cell in a spreadsheet?
The intersection of a column and row
100
This is the function of finding the largest number in a given list of values.
Max
100
In the real world, the word ____________ is an analogy for thinking through a problem or issue or figuring something out so that you can make a decision based on your findings.
dig
200

To illustrate change over time what type of graph would be the best to use?

line graph

200

By ___________ the data in a spreadsheet it is possible to put it in alphabetical order.

sorting

200
______________ run vertically (up and down) in a spreadsheet.
Columns
200
This is the function of finding the smallest number in a given list of values.
Min
200
This is the function of totaling the number of cells in a selected range that contain a specific type of data.
Count
300

This is the function of adding numbers in a spreadsheet.

Sum

300
______________ run horizontally (side to side) in a spreadsheet.
Rows
300
A ____________ row is a row containing labels that identify the data in the cells below.
header
300
This is a number between zero and one that shows how likely a certain event is.
Probability
300
Charts are visual representations of worksheet data. True or false. You can insert a chart into a Google Sheet.
True
400
The middle line in a box and whiskers plot represents the _______________ of the data.
median
400
True or false. Data is facts and statistics collected together for reference or analysis.
True
400
The middle number in a sorted list of numbers.
Median
400
The __________ axis runs vertically in a data set.
Y
400
True or false. Findings are presented before data has been evaluated.
False