Home | | Chapters | | Excel Chapter 1: Creating a Worksheet and Charting Data | | End of Chapter Matching and Multiple Choice Questions |
This activity contains 16 questions.
| |||||||||||||
Constant value | Sheet tabs | Chart | Cell content | Value | Formula | Row | Workbook | Data | Cell address | Column | Fill handle |
Answer choices in this exercise appear in a different order each time the page is loaded.
What are tiny charts that reside in a cell in Excel?
Sparklines are tiny charts that reside in a cell in Excel. These charts are used to show a trend over time or the variation in the dataset. You can use these sparklines to make your bland data look better by adding this layer of visual analysis.
What is used to display the contents of a cell on multiple lines quizlet?
The Wrap Text feature enables you to display the contents of a cell on multiple lines within a cell.
What displays the name of the cell that is selected?
The name box is the box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. The Name Box displays the cell reference of the active cell. The Name Box can also be used to assign names to cells or ranges of cells.
What is a graphic representation of trends in a data series?
3. Line Graph. A line graph reveals trends or progress over time and you can use it to show many different categories of data. You should use it when you chart a continuous data set.