Quiz 2: Excel’s Advanced Formulas, Functions, and Charts

1.  Question: (TCO 2) A(n) _____ is tested in an IF function to determine if it is true or false.
2.  Question: (TCO 2) Which of the following steps can be used to insert a SUM function?
3.  Question: (TCO 2) The _____ function displays the current date in a cell.
4.  Question: (TCO 2) The PMT function is best described by which of the following?
5.  Question: (TCO 3) A data series is a group of related _____.
6.  Question: (TCO 3) Which of the following best describes a column chart?
7.  Question: (TCO 3) When creating a chart in Excel, a single data series _____.
8.  Question: (TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a _____.
9.  Question: (TCO 3) To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a _____.
10. Question: (TCO 3) In Excel, an area chart _____.
11. Question: (TCO 3) Which of the following best describes a trendline?
12. Question: (TCO 3) When you select a chart, Excel displays three icons on the right. Which icon comes first?
13. Question: (TCO 3) The _____ labels show exact values or the name of a data point.
14. Question: (TCO 3) You can apply multiple settings like fill colors and borders at the same time using the Format  _____.
15. Question: (TCO 3) What is the logical sequence for creating a chart?