Basics
A vertical stack of cells in a table or worksheet indentified by letters.
Column
What does formatting do?
Changes how the data looks
What is the very first step when building a chart
Highlight or select the data that you want to see in the chart
A command or tool that enables you to display the formulas in a worksheet.
Show Formulas
Changing the content of a document or file.
Editing
How do you identify a cell?
By column letter and row number
Use this tool to adjust the width of a column so that it perfectly fits the longest entry in that column.
Autofit
A chart that shows the relationship of a part to a whole
Pie chart
This is what a built in formula is called
Function
A tool used to display specific records in a worksheet.
Filter
A selected or highlighted group of cells in a worksheet.
Range
This tool joins or combines cells
Merge
A list that identifies patterns, symbols, or colors used in a chart
Legend
What button do you select to get access to all functions?
Fx
OR
Insert Function
A piece of data within a data series.
Data point
Write the range A1 through B10
A1:B10
Tool used for making changes to a chart.
Chart Editor
Text or numbers that provide additional information about a data marker.
Data Label
Write a formula that will add cells A1 through A10
=SUM(A1:A10)
OR
=A1+A2+A3+A4+A5+A6+A7+A8+A9+10
Two or more pieces of data that are not next to eachother.
Non-adjacent Data
This appears when you hover over the bottom right corner of the selected cell
Copy tool
OR
Fill handle
Formatting that is applied to a cell when a specified condition is met.
Conditional Formatting
All the data points for a particular category of information.
Data Series
Write a formula that will calculate the average of cells D1:D10
=AVERAGE(D1:D10)
Explain what this formula does:
=A1/B1
It divides the value in cell A1 by the value in cell B1