Module 4 Flashcards
financial functions
excel functions used to analyze loans, investments, and business statistics
PMT function
the financial function that calculates the payment schedule required to repay a loan
principal
the amount of money being loaned
interst
the amount added to the principal by the lender
chart subtypes
variation of a chart type
pie chart
Definition:
A chart in the shape of a circle divided into slices like a pie; shows data values as a percentage of the whole.
embedded chart
a chart object placed in a worksheet
selection box
a box surrounding an object such as a chart that is used to move or resize the object
sizing handles
a square or dot on the edge of a selection box that is used to change the object’s width and height
leader line
a line that connects a data label to its corresponding data marker
exploded pie chart
a pie chart that moves one slice away from the other as if someone were taking the piece away from the pie
filter
the process of limiting data to a fewer values
column chart
a chart that displays data values as columns with the height of each column based on its value
bar chart
column chart turned on its side so that the length of each bar is based on its value
