Excel Charts & Graphs

What is the purpose of using a pie chart in Excel?

• To visually represent proportions of different categories or parts of a whole data set.

• To create 3D visualizations of data

• To calculate mathematical functions within the chart

• To display text data in a visually appealing way

Explain the difference between a line chart and a scatter plot in Excel.

• The difference between a line chart and a scatter plot in Excel is that a line chart connects data points with a continuous line to show trends over time, while a scatter plot displays individual data points without connecting lines to show relationships between two variables.

• A line chart shows correlation between two variables, while a scatter plot shows trends over time.

• A line chart displays data points in a scattered manner, while a scatter plot connects data points with lines.

• A line chart is used for discrete data, while a scatter plot is used for continuous data.

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

• Right-click on the chart and select 'Change Chart Type'

• Open 'Format Chart' dialog and change the type

• Select the chart, go to 'Design' tab, click on 'Change Chart Type', choose desired chart type

• Both A and C

What is the significance of data labels in Excel charts?

• Data labels are only visible in printed charts.

• Data labels provide a summary of the chart data.

• Data labels are used for changing chart colors.

• Data labels help in understanding the data points on the chart.

Describe the steps to create a bar graph in Excel.

• Input data, select data, go to 'Format' tab, click on 'Bar Chart', choose specific type of bar graph

• Copy data, paste data, go to 'Insert' tab, click on 'Line Chart', choose specific type of line graph

• Input data, select data, go to 'Insert' tab, click on 'Bar Chart', choose specific type of bar graph

• Delete data, clear data, go to 'Home' tab, click on 'Pie Chart', choose specific type of pie graph

What is the primary function of a trendline in Excel charts?

• To show the overall trend of the data

• To display random data points

• To confuse the viewer

• To add unnecessary clutter

How can you customize the colors of a chart in Excel?

• Right-click on the chart and select 'Customize Colors'

• Use the 'Help' menu to change chart colors

• Go to 'Insert' tab and choose 'Color Options'

• Click on the chart, go to 'Chart Tools' tab, select 'Format', then choose 'Shape Fill' or 'Shape Outline' to customize colors.

What is the purpose of the DATEDIF function in Excel?

• To convert dates into text format
• To merge two date columns
• To calculate the difference between two dates in days, months, or years.
• To calculate the sum of two dates

The first step in creating a Pivot Table is:  

• Click on the 'Pivot Table' button
• Select the data range
• Highlight the entire worksheet
• Apply conditional formatting

•  

  _____ tables allow filtering through different values.

• Join
• Filter
• Sort
• Pivot