Filters
Question type

Study Flashcards

Compare a chart layout to a chart style.

Correct Answer

verifed

verified

A chart layout is a predefined...

View Answer

Describe how to print a chart without printing the worksheet data.

Correct Answer

verifed

verified

If your worksheet contains both a chart ...

View Answer

The ____ identifies what each data series represents.


A) legend
B) data marker
C) data title
D) gridline

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

To select nonadjacent ranges, hold the ____ key.


A) [Tab]
B) [Enter]
C) [Ctrl]]
D) [Shift]

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

A chart layout is a predefined set of chart colors and fills. 

A) True
B) False

Correct Answer

verifed

verified

The chart background is an example of  a chart object .

A) True
B) False

Correct Answer

verifed

verified

A ____ sheet does not include any worksheet cells.


A) spread
B) backup
C) data
D) chart

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

Explain what a data table is.

Correct Answer

verifed

verified

A data table in a chart is a grid contai...

View Answer

The Switch Row/Column button is in the ____ group on the CHART TOOLS DESIGN tab.


A) Chart
B) Data
C) Tools
D) Number

E) A) and C)
F) A) and D)

Correct Answer

verifed

verified

On the CHART TOOLS FORMAT tab, click the More button in the ______________ Styles gallery to add a shape style to your chart element.

Correct Answer

verifed

verified

The ____ is the horizontal line at the base of the chart that shows categories.


A) title axis
B) z-axis
C) x-axis
D) y-axis

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

Clustered Column is a type of Column chart

A) True
B) False

Correct Answer

verifed

verified

  In the accompanying figure, in each category, there are ____ data series. A)  two B)  three C)  four D)  five In the accompanying figure, in each category, there are ____ data series.


A) two
B) three
C) four
D) five

E) A) and D)
F) All of the above

Correct Answer

verifed

verified

The vertical axis provides values, not categories.

A) True
B) False

Correct Answer

verifed

verified

A column sparkline is a miniature line chart that includes a bar for each cell in a selected ____.


A) chart
B) range
C) line graph
D) worksheet

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

Tiny charts that fit into one cell and show a trend are known as ____.


A) mini charts
B) micro charts
C) sparklines
D) scatterlines

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

You can add _____ to a sparkline to indicate values for each cell in the selected range.


A) color
B) weight
C) stars
D) markers

E) None of the above
F) C) and D)

Correct Answer

verifed

verified

To change fill colors, textures and fonts for your chart, click the Chart ____ button.


A) Styles
B) Layout
C) Gallery
D) Themes

E) A) and B)
F) C) and D)

Correct Answer

verifed

verified

The Move Chart button is in the ____ group on the CHART TOOLS DESIGN tab.


A) Location
B) Move
C) Copy/Move
D) Copy/Paste

E) A) and C)
F) All of the above

Correct Answer

verifed

verified

If you want to modify the formatting or alignment of a chart element, you can do so  in the ____ pane.


A) Modify
B) Chart Changes
C) Format
D) Design

E) A) and C)
F) None of the above

Correct Answer

verifed

verified

Showing 41 - 60 of 66

Related Exams

Show Answer