Quiz for Day 4

Which chart type is best for showing trends over time?

• Pie Chart
  
  

• Column Chart

• Line Chart

• Scatter Plot

Which Excel chart is best for showing the correlation between two numeric variables?

• Bar Chart

  
  

• Area Chart

• Scatter Plot

• Pie Chart

What is the minimum number of data points needed to create a chart in Excel?

• 4

• 2

• 3

• 1

A bar chart and a column chart are exactly the same.

• True
• False

The legend in a chart shows the categories of data.

• True
• False

What is the main purpose of a Pivot Table in Excel?

• To sort data alphabetically

• To delete duplicate entries

• To summarize and analyze large datasets

• To create charts only

In a Pivot Table, what does the 'Values' area represent?

• Column headings

• Filters for slicing data

• Summary calculations like counts, sums, etc.

• Graph titles

What happens when you drag a field into both the 'Rows' and 'Values' areas?

• An error message appears

• Excel hides the field

• It creates a detailed breakdown for that field

• It creates a pie chart

Which of the following can you NOT do directly in a Pivot Table?

• Filter data
  

• Format cells

• Manually enter new data into the table

• Sort rows

You can add multiple fields to the Values area of a Pivot Table.

• True
• False