Elijah works in a local coffee shop that sells baked goods. He is given a table that has the baked goods listed along the X-axis and the months of the year along the Y-axis. The table shows the profit that the baked goods made that month. Elijah wants to quickly spot which month the baked goods did the best, when all baked goods and months are considered. He thinks that adding some color to the table might help. What type of chart should he create? Pie chartStacked bar chartBar chartHeat map

Which Chart(s) can be Created in Excel?PieAreaLineBarNone of Above

Question 9I have a table that contains the data of the monthly sales figures of my company. I was tasked with creating a chart to display the change in sales on a monthly basis. What is the best chart to use to effectively display the change over time of monthly sales?1 pointBubble ChartPie ChartLine ChartBar Chart

Categories in a pie chart that represent parts of the whole and show the contribution of each value to the total.

Which chart type is used to show the relationship of parts to a whole in Excel?a) Line chartb) Bar chartc) Pie chartd) Scatter plot

A pie chart is ideal for representing:Changes in expenses over time.The breakdown of spending proportions within a specific category.Comparison of expenses between two or more groups. Identifying outliers in your expense data.