Formatting
What does formatting do?
Changes how a cell looks
Type of chart used to display parts of a whole or show how things are divided
Pie chart
What tool will display all formulas used in a woksheet.
Show Formulas
Write the formula or function that will add cells A1 and A2
=A1+A2
What is the intersection of a column and a row called?
Cell
Tool that puts data in alphabetical or numerical order.
Sort
What is the very first step when creating a chart?
Highlight the data that you want in the chart
Tool you click to see a list of all Functions
Fx button
or
Functions button
Write the formula or function that will calculate the average of cells A1, B1, and C1.
=AVERAGE(A1:C1)
What is an Excel file called?
Workbook
OR
Spreadsheet
This process joins cells together.
Merge
This is a single piece of data in a chart.
Data point
Function button that holds shortcuts to the most commonly used functions: Sum, Average, Count, Max, and Min
AutoSum
Write the formula or function that will add cells A1 through A20
=SUM(A1:A20)
What is the file extension for Excel?
.xls
OR
.xlsx
A tool that copies formatting from one cell and applies it to another.
Format painter
Tool to help readers understand the data in a chart
Legend
This is a cell reference that cannot be copied.
Absolute
Write the formula or function that pull out the highest number in the cell range A1:A20
=MAX(A1:A20)
What term describes a highlighted group of cells?
Range
Formatting that is applied to a cell only if certain conditions are met.
Conditional Formatting
Chart element that displays information about a data point such as value or category name.
Data label
This tool allows you to extract data from a spreadsheet. Using this tool, you will see only the data that you choose.
Filter
Write the formula that will calculate 25% of cell A1
=A1*0.25
or
=A1*.25
What does it mean if you see ##### in a cell instead of the data that should be in the cell?
The Column width is too narrow
OR
The Row height is too low