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?
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.
Message
All members who signed up before 2023 are requested to register again.