Tiny charts embedded in a cell that display a visual trend summary alongside your data are called


Home
Chapters
Excel Chapter 1: Creating a Worksheet and Charting Data
End of Chapter Matching and Multiple Choice Questions

This activity contains 16 questions.


Match each term with its correct definition.

A matching question presents 15 answer choices and 15 items. The answer choices are lettered A through O. The items are numbered 1.1 through 1.15. Screen readers will read the answer choices first. Then each item will be presented along with a select menu for choosing an answer choice. Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
Number values
Cell
Spreadsheet
Constant value Sheet tabs Chart Cell content Value Formula Row Workbook Data Cell address Column Fill handle
1.1 An Excel file that contains one or more worksheets.1.2 Another name for a worksheet.1.3 The intersection of a column and a row.1.4 The labels along the lower border of the Excel window that identify each worksheet.1.5 A vertical group of cells in a worksheet.1.6 A horizontal group of cells in a worksheet.1.7 Anything typed into a cell.1.8 Text or numbers in a cell.1.9 Numbers, text, dates, or times of day that you type into a cell.1.10 An equation that performs mathematical calculations on values in a worksheet.1.11 Constant values consisting of only numbers.1.12 Another name for a cell reference.1.13 Another name for a constant value.1.14 The small black square in the lower right corner of a selected cell.1.15 The graphic representation of data in a worksheet.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

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.

Toplist

Neuester Beitrag

Stichworte