The Spreadsheet
Calculations and Such
Functions
Frequency Charts
Histograms
100
When was the first excel spreadsheet developed?
What is the 70s
100
Cell designation are used for what?
What is to indicate values
100
What is another word for the addition of numbers?
What is Sum
100
Frequency charts indicate what?
What is the frequency of occurrence within a class interval
100
What is a histogram?
What is Graphical representation of the frequency chart
200
This was based on an earlier spreadsheet
What is Excel
200
What is the Order of Operations?
What is the order used to find the solution to a formula
200
What is another word for Mean
What is Average
200
What does Bin values give you?
What is the boundary point between class intervals
200
What kind of graph is a histogram
What is Bar graph
300
What is the purpose of a spreadsheet?
What is to store raw data and represent data
300
What is in the order of operations
What is Parenthesis, exponents, multiply, divide, add, subtract
300
Functions are used to find what 6 things?
What is Mean, Mode, Standard Deviation, Minimum, Maximum, Median
300
Does Bin values occur in histograms or frequency charts?
What is Both
300
What is shown at the top of a histogram?
What is Title
400
In a spreadsheet, what three things present in the data array?
What is Row, Column, Table
400
What do calculations always begin with?
What is =
400
What does STDEV.P stand for?
What is Standard Deviation
400
Do you choose the input or output range when making your chart?
What is output
400
What is shown the left of a histogram?
What is frequency
500
What is a cell in a spreadsheet?
What is the intersection of a column and row
500
What is a function?
What is Defined mathematical calculations
500
The excel command MODE.SNGL represents what function?
What is Mode (unimodal)
500
What is a frequency chart?
What is A chart that indicates the frequency of occurrence within a class interval
500
Is a histogram relevant to a frequency chart? If so, what has to be the same
What is yes. The information has to be the same
M
e
n
u