Show:
Types of Charts
Loan Payments
Functions
Spreadsheet Basics
Chart Vocab
100
This chart shows changes over time.
What is line chart?
100
The function that calculates monthly loan payments.
What is PMT?
100
Finds the total of a set of numbers
What is the SUM function
100
Columns are identified this way
What is letters?
100
The key that provides explanations of different series of data
What is legend?
200
These two similar charts only differ on the direction of the bars.
What is bar and column charts?
200
The fee paid for borrowing money.
What is interest?
200
Finds the smallest number in a range
What is MIN function?
200
Rows are identified this way
What is numbers?
200
The white space around a chart.
What is chart area?
300
This chart shows part to whole relationship.
What is pie chart?
300
The amount of money borrowed in a loan.
What is principal?
300
Computes the mean of a set of numbers
What is the AVERAGE function?
300
The default number of sheets in a workbook.
What is 3?
300
The chart tab used for titles, labels, etc.
What is Layout?
400
This chart type adds a third axis (Z).
What is 3-D chart?
400
The meaning of the acronym APR.
What is annual percentage rate?
400
Functions must start with this.
What is =?
400
The intersection of a row and column.
What is a cell?
400
The chart tab used to select data, change legend text, or move chart.
What is Design tab?
500
The two options to place a chart in Excel.
What is active sheet and chart sheet?
500
The type of interest computed in loan calculations.
What is compound interest?
500
The button represented by the Greek letter Sigma
What is AutoSum?
500
The two orientations for printing a spreadsheet.
What is portrait or landscape?
500
Math calls them X and Y axes. Excel calls them this.
What are Category and Value Axes?