Answer #5- 10 5. In Excel 2013, Excel displays the ________ button in the bottom

Question

Answer #5- 10

5. In Excel 2013, Excel displays the ________ button in the bottom-right corner of a highlighted range.

6. Which of the following is NOT a type of sparkline? (a)Bar (b)Win/loss (c)Line (d)Column

8. A(n) ________ bar is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.

9. Which of the following shows where automatic page breaks will occur in a worksheet?

1. Chart area II. PlotArea III. X-axis IV. Y-axis V. Category axis A, contains a graphical representation of values in a data series provides descriptive group names for subdividing a data series C. horizontal line that borders the plot area to provide a frame of reference D. vertical line that borders the plot area to provide a frame of reference E. contains an entire chart and all of its elements

Explanation / Answer

5. Excel displays the drag button at the bottom right corner of a highlighted range.

6. (a) Bar is not a type of sparkline. Sparklines are tiny charts in the background of a cell to show data trends. The types of sparklines are win/loss, line, and column.

7.

I - E - Chart area contains an entire chart and all of its elements.
II - A - Plot area contains a graphical representation of values in a data series.
III - C - X-axis is the horizontal line that borders the plot area to provide a frame of reference
IV - D - Y-axis is the vertical line that borders the plot area to provide a frame of reference
V - B - Category axis provides descriptive group names for subdividing a data series

8. A data bar is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.

9. The page break preview shows where automatic page breaks will occur in a worksheet.

10.

I - A - A dataset is structured, related data in columns and rows
II - C - Freezing keeps rows and/or columns visible as you scroll through a worksheet
III - E - Freeze top row keeps the top row visible as you scroll
IV - B - A manual page break appears as a blue dashed line
V - D - An automatic page break appears as a solid blue line

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.