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
How many series of data can be shown on a pie chart?
One
Two
Three
Any number
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
{"name":"Excel 2016: Working with Charts and Graphics Test", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsMultiple choice formatEngaging and interactive","img":"https:/images/course1.png"}
Powered by: Quiz Maker