MS Excel - Day 08

The contextual tabs that appears with charts are

• Design and Layout

• Layout and Format

• Format and Options

• Design and Format

Charts are present in the _______ tab.

• Home

• Data

• Insert

• Formulas

Which Excel chart type is suitable for showing trends over a period of time?

• Bar Chart

• Pie Chart

• Line Chart

• Scatter Plot

Which of the following is not a valid type of Excel chart?

• Area Chart

• Radar Chart

• Cylinder Chart

• Bubble Chart

What is the purpose of a secondary axis in an Excel chart?

• To add more data series to the chart

• To make the chart title stand out

• To display a second set of data with a different scale

• To adjust the alignment of the data labels

Which Excel chart type is best suited for comparing individual data points in a category?

• Line chart

• Bar chart

• Pie chart

• Scatter plot

What is the purpose of a legend in an Excel chart?

• To display the data labels

• To provide a title for the chart

• To show the values of each data point

• To identify the data series in the chart

In Excel charts, what is data series?

• The title of the chart

• The horizontal axis labels

• A collection of related data points

• The vertical axis labels

What is the purpose of data labels in an Excel chart?

• To display the category names on the chart

• To provide a description of the chart's data

• To identify each data point with its value

• To create a legend for the chart

What does the horizontal axis (x-axis) of an Excel chart represent?

• Data series

• Category labels

• Legend

• Data points