Structure
True/False
Basic Formulas
Formulas
Charts
100
Columns are labeled with these.
What are the letters of the alphabet ?
100
A data marker is a single value or piece of data from the data series.
What is FALSE ? (DATA POINT)
100
All formulas must start with this.
What is an equal sign?
100
The special formula for adding a column, row, or block of numbers.
What is =SUM(first cell:last cell) ?
100
Y Axis
What is vertical line : up and down ?
200
Rows are labeled with these.
What are numbers?
200
Chart is a visual display of data in a spreadsheet, also know as a graph.
What is true?
200
The symbol for multiplication.
What is the asterisk * ?
200
The special formula for finding the average of a column, row, or block of numbers.
What is =AVERAGE(first cell:last cell) ?
200
x axis
What is horizontal line left to right?
300
The name of where a row and column intersect.
What is a cell ?
300
X-axis is a category axis that describes when is shown in the chart.
What is true ?
300
The symbol for division.
What is the slash / ?
300
The special formula for finding the Square Root of a number.
What is =SQRT(cell) ?
300
legend
What tells you what each bar or pie slice represents on your chart?
400
The proper way to refer to where row 8 and column B intersect.
What is B8 ?
400
a legend is a horizontal and vertical line that extends across the plot area of the chart to make it easier to read/understand the values.
What is FALSE ? (GRIDLINE)
400
The correct formula for adding cell D2 and F8.
What is =D2*F8
400
The special formula for finding a number squared
What is =POWER(number,power) ?
400
Line graph
What is a graph most useful in displaying data or information that changes continuously over time.
500
The way to widen a column so all information that is there can be seen .
What is to put your mouse between two letters at the top of the screen and stretch to length wanted ?
500
a tick mark is a object that represents the individual values; marker can be a bar, column, etc.
What is FALSE ? (DATA MARKER )
500
The correct formula for subtracting cell C6 from A2.
What is =A2-A6 ?
500
The button in the toolbar that brings up formula choices.
What is AutoSum?
500
Ascending
What is a sort from a-z or low to high ?
M
e
n
u