Tutorial 4 Quick Check Answers
Session 4.1 Quick Check
1. =PMT(4.8%/12, 20*12, 225000)
3. Because the PMT value represents an expense to the borrower (a negative cash flow).
5. It would be better displayed as a column chart because as the number of slices in the pie chart
6. Because the chart needs to display the total population of the county, a stacked column chart will
work best to show how that total is divided into different ethnic groups.
8. Because the chart does not need to display the total population but only the comparison of the
population values of different ethnic groups, a clustered column chart will work best.
Session 4.2 Quick Check
1. A line chart plots a data series against a set of category values which are assumed to be
arranged in sequential order. A scatter chart plots one data series against another.
2. Because there are two data series involved in the chart, the researcher should use a scatter
chart and not a line chart.
4. Double-click the axis scale to select it and open the Format pane. Enter the new axis scale into the
5. The chart area contains the entire chart, including the plot area. The plot area contains the region
of the chart in which the data values are plotted.
8. Sparklines are compact graphs containing very few chart element and displayed within a
9. A data bar is a conditional format in which a horizontal bar is added to a cell background
with the length of the bar proportional to the cell’s value.