Excel 2019 Skills Assessment Quiz

What is the main use of a chart in Excel?

• To store data

• To show data visually

• To do calculations

• To make pivot tables

Which of these is a chart type in Excel 2019?

• Pie Chart

• Histogram

• Scatter Plot

• All of the above

How do you make a chart in Excel 2019?

• Select data, click "Insert," then choose a chart

• Use the "Data" tab for a formula

• Click "File" and select "New Chart"

• Right-click and select "Create Chart"

What does a pivot table do in Excel?

• Makes a visual of data

• Summarizes and analyzes data

• Does basic math

• Formats cells

What is a necessary step to create a pivot table?

• Select data range, go to "Insert" tab

• Click "File" and select "New Pivot Table"

• Use "Home" tab to format data

• Right-click and select "Create Pivot Table"

In a pivot table, what is the "Values" area for?

• Filtering data

• Showing data fields

• Doing calculations

• Sorting data

How can you change the type of an existing chart in Excel 2019?

• Right-click the chart, select "Change Chart Type"

• Double-click the chart, choose a new type

• Go to "Data" tab, select "Change Chart Type"

• Click "File" and select "Change Chart Type"

What does filtering data in a pivot table do?

• Removes all data except selected range

• Shows only data that meets criteria

• Sorts data in order

• Highlights specific data

You have sales data for regions. How do you use a pivot table to find total sales for each region?

• Drag "Region" to "Rows," "Sales" to "Values"

• Use "Sort" to arrange by region

• Apply a filter to show sales data

• Make a new worksheet for each region

To compare monthly sales of two products, which chart is best?

• Line Chart

• Pie Chart

• Bar Chart

• Area Chart