• 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?


BIS 155 Week 2 | Quiz

  • Institution(s): Devry
  • Year Published: 2021
  • Digital Download: Instant
  • $5.00


Related Products

Tags: BIS 155 Week 2 Quiz, BIS155 Week2 Quiz, BIS155 Week 2 Quiz, BIS 155 Week2 Quiz, BIS 155 Week 2 Quiz 2.