Vocabulary
At the bottom of the workbook, it identifies the different worksheets.
What are sheet tabs?
This function calculates the average of a set of numbers.
What is AVERAGE?
What are the different types of charts?
Highest paid job in the budget game.
What is a physician?
A single spreadsheet.
What is a workbook?
=SUM(A3+F4)
What is the formula for finding the sum?
A type of chart that displays data points connected by straight lines, primarily used to visualize trends and changes in data.
What is a line chart?
=COUNT(A4:A5)
What is the COUNT formula?
Like the grammar for writing formulas in a spreadsheet.
What is formula syntax?
This function identifies the largest value in a range.
What is MAX?
What is a column chart?
Add a title.
What is a way you can enhance your chart?
A special equation you use in a spreadsheet to do math with numbers in cells
What is a formula?
This function identifies the smallest value in a range.
What is MIN?
You should use this chart when you want to show how different parts make up a whole and show a percentage.
When should I use pie charts?
File types of spreadsheets.
What are xls. and csv.?
Like an address for a specific box in a spreadsheet. It tells you the exact location of a cell by using the column letter and row number, like B5 or C10
What are cell references?
This function counts the number of cells that contain numbers in a range.
What is COUNT?
A line chart shows this type of data.
What chart shows changes in trends?
A duck.
What was the image created using cell reference numbers?