Deck 6: Excell: Creating Charts, Diagrams, and Templates

Question 1

Objects that make up a chart are called ________.

A)chart data
B)chart elements
C)chart markers
D)chart objects

Answer 1

B

Question 2

Sparklines are ________.

A)the same as trendlines
B)tiny charts that fit within a cell and give a visual trend summary alongside your data
C)lines that connect the high point of columns
D)the border that displays around a selected range

Answer 2

B

Question 3

To display trends over time,use a ________ chart.

A)line
B)bar
C)column
D)pie

Answer 3

A

Question 4

An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data is called ________.

A)Organization Charts
B)Recommended Charts
C)Line Charts
D)Embedded Charts

Question 5

The entire chart with all of its elements is called the ________.

A)plot area
B)chart object
C)chart element
D)chart area

Question 6

A chart that is inserted into the same worksheet that contains the data used to create the chart is called ________.

A)embedded
B)separate
C)layered
D)selected

Question 7

Charts can be placed on a separate sheet called a ________.

A)design sheet
B)chart sheet
C)new sheet
D)worksheet

Question 8

When creating a column chart,selecting ________ for the data helps the reader understand the chart.

A)labels
B)columns
C)totals
D)rows

Question 9

A ________ is a graphic representation of data.

A)Style
B)Legend
C)Chart
D)List

Question 10

The ________ is the range of numbers in the data series and that controls the minimum,maximum,and incremental values on the value axis.

A)legend
B)template
C)scale
D)matrix

Question 11

When you create a chart,you must first decide if you are going to plot values representing ________.

A)columns OR details
B)totals OR details
C)sparklines OR trendlines
D)columns OR trends

Question 12

The key that defines the colors assigned to categories in a chart is called a(n)________.

A)object
B)element
C)legend
D)marker

Question 13

When selecting the range for a line chart,you may need to include a(n)________ to have the same number of cells in each row.

A)total
B)empty cell
C)legend
D)column

Question 14

To make comparisons among related data,use a ________ chart.

A)line
B)pie
C)column
D)scatter

Question 15

Column charts present data graphically in ________ columns.

A)horizontal
B)single
C)diagonal
D)vertical

Question 16

A group of related data plotted in a chart is called a data ________.

A)point
B)line
C)series
D)marker

Question 17

A ________ is a graphic representation of trends in a data series.

A)gridline
B)line chart
C)sparkline
D)trendline

Question 18

The area bounded by the axes,including all the data series is called ________.

A)data points
B)chart area
C)plot area
D)format

Question 19

A ________ is a visual representation of information and ideas.

A)template
B)chart area
C)SmartArt graphic
D)trendline

Question 20

Column and row titles that describe the values in the column or row are known as ________.

A)plots
B)groups
C)lines
D)labels

Question 21

When you protect a worksheet,you can add an optional ________ to prevent someone from disabling a worksheet's protection.

A)lock
B)legend
C)scale
D)password

Question 22

The Select locked cells option enables you to click the locked cell and ________ the formulas.

A)view
B)delete
C)modify
D)format

Question 23

Which of the following SmartArt graphic categories would be best to show a timeline?

A)List
B)Pyramid
C)Cycle
D)Process

Question 24

In order for individuals completing your form to type their data into designated cells,the cells must be ________.

A)selected
B)unlocked
C)password
D)unprotected

Question 25

After text is entered and formatted in your template,add ________ to the cells where you want the result of the calculations to display.

A)tables
B)cell references
C)formulas
D)ranges

Question 26

If you want all of the forms within an organization to have a uniform appearance and have the data organized in the same manner,you should use ________.

A)standardization
B)protection
C)validation
D)equality

Question 27

The Text Pane includes ________ in which you can type text into a SmartArt graphic.

A)cells
B)legends
C)placeholders
D)objects

Question 28

Templates can have built-in ________ that display the results of calculations based on the data that is entered into the template.

A)tables
B)information
C)formulas
D)ranges

Question 29

When you open a template from the Custom Office Templates folder,it opens as a(n)________.

A)Excel Workbook
B)Excel Template
C)Excel Macro-Enabled Workbook
D)Excel Macro-Enabled Template

Question 30

________ are workbooks you use as the basis for other similar workbooks.

A)Designs
B)Page Layouts
C)Common Reports
D)Templates

Question 31

An organization chart depicts ________ within an organization.

A)ranges
B)SmartArt
C)cycles
D)reporting relationships

Question 32

To add a shape to a lower level of an organization chart,right-click the shape,click Add Shape,and then click ________.

A)Add Shape Below
B)Add Shape Above
C)Add Shape After
D)Add Shape Before

Question 33

The two main reasons for creating templates for commonly used forms in an organization are ________.

A)lookup and validation
B)validation and standardization
C)standardization and protection
D)validation and relationship

Question 34

The Text Pane displays to the ________ of the SmartArt diagram.

A)left
B)bottom
C)top
D)right

Question 35

To prevent others from altering the formulas or changing other template components,you should use ________.

A)validation
B)uniformity
C)standardization
D)protection

Question 36

________ prevents anyone from changing a workbook.

A)Validation
B)Embedding
C)Protection
D)Securing

Question 37

If you need to make changes to a template after it is protected,you must first remove the ________.

A)validation
B)security
C)protection
D)locking

Question 38

If you try to enter data in a protected cell,a message displays informing you that the cell is protected and therefore ________.

A)read-only
B)unlocked
C)invalid
D)embedded

Question 39

When you open a template from the New tab in the Backstage view,it opens as a(n)________.

A)object
B)worksheet
C)workbook
D)template

Question 40

To delete a box from a SmartArt organization chart,a ________ border must display around the box.

A)solid line
B)dashed line
C)double line
D)dotted line

Question 41

A line chart can have only one line.

Question 42

A SmartArt graphic is a visual representation of information and ideas.

Question 43

Sparklines are tiny charts that fit within a cell and give a visual trend summary alongside your data.

Question 44

As you create a chart,you can make choices about what data to include.

Question 45

Both charts and SmartArt graphics depend on underlying data in a worksheet.

Question 46

A data series is a group of related data points that are plotted in a chart.

Question 47

You can change the values on the value axis to increase or decrease the variations among the numbers displayed.

Question 48

When you select the chart type,the resulting chart will contain elements that you can delete or change.

Question 49

Standardization means designing a workbook so that individuals cannot enter data into cells.

Question 50

The Text Pane is populated with placeholder text that you replace with your information.

Question 51

The Process SmartArt graphic can show steps in a timeline.

Question 52

All shapes in an organization chart must be the same color.

Question 53

To create sparklines,first select the data you want to plot.

Question 54

An organization chart displays relationships within an organization.

Question 55

Excel includes predesigned templates,for example for a budget.

Question 56

A chart is a graphic representation of data.

Question 57

You should plot both totals and details on the same chart.

Question 58

You cannot add additional shapes to a SmartArt graphic.

Question 59

You can add effects,for example a bevel,to a SmartArt graphic.

Question 60

When selecting a range of cells for a chart,it is sometimes necessary to include an empty cell in the selection.

Question 61

________ charts can show trends over time.

Question 62

________are tiny charts that fit within a cell and give a visual trend summary alongside your data.

Question 63

Templates can only be used on the computer on which they are created.

Question 64

If you need to make changes to a template,you must first remove protection.

Question 65

A(n)________ graphic is a visual representation of your information and ideas.

Question 66

When you open a template from the Templates folder in Backstage view,a new copy of the template opens as a workbook.

Question 67

To create an organization chart,insert a ________ graphic from the Illustrations group on the Insert tab.

Question 68

A(n)________ depicts reporting relationships in an organization.

Question 69

When a template design is complete,you should enable protection.

Question 70

A(n)________ is a graphic representation of trends in a data series.

Question 71

A Process SmartArt graphic can display steps in a process or a ________.

Question 72

Organizations use standardization and protection when creating templates for commonly used forms.

Question 73

The entire chart and all of its elements comprise the ________.

Question 74

The chart element that identifies the patterns or colors that are assigned to the categories in the chart is the ________.

Question 75

The ________ controls the minimum,maximum,and incremental values on the value axis.

Question 76

A(n)________ graphic is a graphical tool that depicts ideas or associations.

Question 77

A(n)________ is a graphic representation of data.

Question 78

________ display alongside each row of data and provide a quick visual trend summary.

Question 79

Both the Text Pane and the SmartArt graphic contain ________ in which you can type text.

Question 80

To add text to a SmartArt graphic,you can type in the shape placeholders or you can open the ________.