Excel 2019 Chart Creation Quiz

What is the first step in creating a chart in Excel 2019?

• Click on the Insert tab and select a chart type

• Select a data source for the chart

• Change the style of the chart

• Add titles to the axes

Which tab in Excel 2019 allows you to change the chart type after inserting a chart?

• Home

• Insert

• Design

• Format

How can you adjust the size of a chart in Excel 2019?

• Use the Chart Tools in the Size group under the Format tab

• Use the Chart Styles under the Design tab

• Use the Font group under the Home tab

• Use the Add Chart Element icon under the Design tab

What does the Chart Styles option under the Design tab in Excel 2019 allow you to do?

• Select the data source for the chart

• Change the text and data format in the chart

• Change the overall style of the chart

• Insert a new chart

Where do you add axis titles in an Excel 2019 chart?

• Under the Insert tab

• In the Chart Styles group under the Design tab

• Using the Add Chart Element icon under the Design tab

• In the Font group under the Home tab

What is the first step to increase the font size of the axis titles in a chart in Microsoft Excel 2019?

• Right-click on the axis title and select Font Size

• Select the axis title and use the Increase Font Size button

• Double-click the axis title and choose a larger font

• Right-click on the axis title and select the Font menu that appears

How can you change the fill color of a column in a chart in Microsoft Excel 2019?

• Right-click the column and select Fill Color

• Select the column and use the Shape Fill icon in the Shape Styles group

• Double-click the column and choose Color

• Use the Format tab and select Color Options

What should you do to print a chart with its data from Microsoft Excel 2019?

• Click on the chart and select Print from the File menu

• Go to Backstage view, click Print, and then Print Preview

• Right-click on the chart and select Print

• Ensure the chart is selected and then click Print in Backstage view

What is the correct procedure to publish a chart as a web page from Microsoft Excel 2019?

• Save the chart as a web page format and click Publish

• Use the Save As dialog box, select Web Page format, and click Publish

• In the Save As dialog box, choose a location, select Web Page format from the dropdown menu, and click Publish

• Copy the chart to a web editor and publish from there

A type of chart which displays information as a series of data points called 'markers' connected by straight line segments. 

• Pie chart
• Line Chart
• Bar Graphs
• Graphs