CGS 2518 EXAM ARMSTRONG
QUESTIONS AND ANSWERS
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?
(ch. 2) - Answer-periodic interest rate
Which of the following is NOT an appropriate use of the SUM function? (ch. 2) -
Answer-=SUM(D15-C15)
What is the keyboard shortcut to create an absolute reference? (ch. 2) - Answer-F4
Which type of chart is the least appropriate for depicting yearly rainfall totals for five
cities for four years? (ch. 3) - Answer-pie chart
Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the
category axis? (ch. 3) - Answer-CIS managers
Which of the following is not a type of sparkline? (ch. 3) - Answer-bar
If you want to show exact values for a data series in a bar chart, which chart element
should you display? (ch. 3) - Answer-data labels
The value axis currently shows increments such as 50,000 and 100,000. What option
would you select to display the values in increments of 50 and 100? (ch. 3) - Answer-
show axis in thousands
You want to create a single chart that shows the proportion of yearly sales for five
divisions for each year for five years. Which type of chart can accommodate your
needs? (ch. 3) - Answer-100% stacked column chart
Currently, a column chart shows values on the value axis, years on the category axis,
and state names in the legend. What should you do if you want to organize data with
the states on the category axis and the years shown in the legend? (ch. 3) - Answer-
click switch row/column in the data group on the design tab.
What do you click to remove a data series from a chart so that you can focus on other
data series? (ch. 3) - Answer-chart filters
Which of the following does not display automatically when you create a clustered
column chart? (ch. 3) - Answer-data labels
After you create a line type sparkline, what option should you select to display dots for
each data point? (ch. 3) - Answer-markers
QUESTIONS AND ANSWERS
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?
(ch. 2) - Answer-periodic interest rate
Which of the following is NOT an appropriate use of the SUM function? (ch. 2) -
Answer-=SUM(D15-C15)
What is the keyboard shortcut to create an absolute reference? (ch. 2) - Answer-F4
Which type of chart is the least appropriate for depicting yearly rainfall totals for five
cities for four years? (ch. 3) - Answer-pie chart
Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the
category axis? (ch. 3) - Answer-CIS managers
Which of the following is not a type of sparkline? (ch. 3) - Answer-bar
If you want to show exact values for a data series in a bar chart, which chart element
should you display? (ch. 3) - Answer-data labels
The value axis currently shows increments such as 50,000 and 100,000. What option
would you select to display the values in increments of 50 and 100? (ch. 3) - Answer-
show axis in thousands
You want to create a single chart that shows the proportion of yearly sales for five
divisions for each year for five years. Which type of chart can accommodate your
needs? (ch. 3) - Answer-100% stacked column chart
Currently, a column chart shows values on the value axis, years on the category axis,
and state names in the legend. What should you do if you want to organize data with
the states on the category axis and the years shown in the legend? (ch. 3) - Answer-
click switch row/column in the data group on the design tab.
What do you click to remove a data series from a chart so that you can focus on other
data series? (ch. 3) - Answer-chart filters
Which of the following does not display automatically when you create a clustered
column chart? (ch. 3) - Answer-data labels
After you create a line type sparkline, what option should you select to display dots for
each data point? (ch. 3) - Answer-markers
