Question

Activity

You have learned about the graphical elements that you can add in a spreadsheet. Create your own spreadsheet using these elements.
Question 1
Create a chart using the sample data in the table below. Recollect the steps on how to create a chart, and explain the necessary steps based on
the data in the table. Mention what the x- and the y-axes state and your interpretation of the data represented in the chart.
Year Percentage Increase in Expenses
2005
25.3
2007
30
2009
35
2011
35.8
2014
40

please help

Answer 1

its a

Step-by-step explanation:

the answer is a i am right

Answer 2

Here are the steps I followed to create the chart on the Microsoft Excel spreadsheet.

I clicked the Insert option from the top toolbar.

I clicked the Chart option.

I clicked Chart Type, and selected the type of chart I wanted. The table above provides data on the increase in percentage of expenses over the years. I chose the Column chart to display this data graphically. The column chart is the best form of chart that can show variation between items.

I selected the Data Range. I specified the start and end values of the data set that I wanted to plot in the chart.

Under Chart Elements, I specified the title and legend for the chart. A legend makes it easy for a viewer to understand a titled graph.

The x-axis represents the year in my column chart, and the y-axis shows the percentage increase in expenses per year. With the help of this chart, I could see that every year the percentage in expenses has increased steadily, and reached the highest value in 2014.

Step-by-step explanation:

This is really close to the sample answer, so I would be careful...