BIS 155 Week 2 Quiz

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?