Excel 2016: Working with Charts and Graphics Test

A vibrant infographic illustrating various types of charts and graphics available in Excel 2016, with elements like pie charts, bar charts, and sparkline examples against a background of digital spreadsheets.

Excel 2016 Charting Mastery Quiz

Test your skills and knowledge in creating and working with charts and graphics in Excel 2016. This comprehensive quiz will challenge your understanding of chart types, design options, and graphic formatting.

12 insightful questions
Multiple choice format
Engaging and interactive

12 Questions3 MinutesCreated by DrawingData9

You might want to use a chart in your worksheet to:

Hide sensitive information

Identify trends or patterns in the data

Automate repetitive actions

Ensure a consistent look for all pages in the workbook

Which of the following are chart types supported in Excel?

Area, block, combo

Block, column, bar

Column, line, xy (scatter chart)

Stock, surface sonar

Which of the following types of chart is suited for displaying relative sizes (or percentages) of each piece of a total?

Scatter

Line

Bar

Pie

Which of the following are changes you can make to a chart design?

Fill or outline color, reflection, change the chart type

Add a chart title or legend, select a different chart layout, exchange the data rows and columns, and change the chart type

Shadow effects, height and width, fill or outline color

Which of the following are types of sparkline charts?

Star, column, and bar

Column, star, and win/loss

Line, bar, and column

Line, column, and win/loss

If you have a worksheet that contains both a chart and the data for the chart, you have the ability to select only the chart to print on its own.

True

False

Which of the following is the Quick Analysis Tools used for?

Insert a trend line to a chart

Perform what-if analysis

Insert charts, sparklines, pivot tables, and conditional formatting

Inspect a chart for errors

To add shapes and illustrations to a worksheet, you use commands on which tan of the Ribbon?

View

Insert

Data

Home

Before you can change the shape fill color of a graphic object, you must:

Remove any existing shape effects

Adjust the size of the object

Select it

Adjust the scale of the object

Which of the following are types of formatting options can you apply to a graphic object?

Fill or outline color, reflection, three-dimensional rotation, shadow effects

Shadow effects, change the chart type, select a different set of worksheet data

Add a chart title or legend, picture effects, three-dimensional rotation, borders

Which types of formatting can you apply to both pictures and clip art?

Shadow effects, borders, change the chart type

Borders, reflection, fill or outline color, shadow effects

Colors, artistic effects, visual styles, picture effects

Excel 2016: Working with Charts and Graphics Test

Excel 2016 Charting Mastery Quiz

More Quizzes