Question

I'm really bad at excel, someone please help

Answer 1

https://gasprices.aaa.com/state-gas-price-averages/

Answer 2

@Ultrilliam

Answer 3

Do you know how to edit a column?

Answer 4

Yes

Answer 5

Which steps are you struggling with?

Answer 6

5

Answer 7

Well step one is you need to fill out the State Averages column so you have data, could you fill that out based on state averages?

Here is an example of how it should look thus far:

Answer 8

Good, now fill out the state averages, from month to month

Answer 9

That is not quite what you need

Answer 10

O

Answer 11

It's asking for May 2012 through April 2013 average state gas prices in YOUR state

Answer 12

OH

Answer 13

My state is Oregon, not sure how to find those prices

Answer 14

https://www.oregon.aaa.com/gas-prices/page/6/

this looks like a lot

Answer 15

https://www.oregon.aaa.com/gas-prices/
It goes all the way back to the 2005

Answer 16

You just need one number from each month between May 2012 through April 2013

Answer 17

(Look at the state column, not the national column!)

Answer 18

okay ill do that right now, it might take awhile

Answer 19

Alrighty

Answer 20

Good, now transplant the actual money values into this column here:

Answer 21

ok

Answer 22

Perfect, do you know what column A17 would be?

Answer 23

That is correct, paste the link you got the data from there (https://www.oregon.aaa.com/gas-prices/)

Answer 24

Perfect, next we're going to edit the chart data. First, we're going to change the title to just "Gas Prices May 2012 through April 2013", from there we're going to edit the data and legend of the chart. Right click on the chart and hit "Select Data" Select the first legend and hit "edit". Click the series name box and then click on "National Average"

Answer 25

Next, we're going to add a new one, hit "add". For series name click on State Average, and for the data, hold shift and click and drag from C4-C15 and hit "ok"

Answer 26

The result should be a graph that looks like this:

Answer 27

where does it say add

Answer 28

Your at the step where you need to hit "National Average" (Column B3)

Answer 29

After that hit "ok"

Answer 30

ok

Answer 31

then i pressed add agaon

Answer 32

I think you jumped around the steps I gave a bit...

Answer 33

Lol

Answer 34

i'll read over again

Answer 35

Better, but...
Alright, lemme make this simpler instead of giving "the hard version" lol, after hitting Select Data, click and drag from A3 to C15

Answer 36

(Sorry, brain-farted and forgot that you could do that)

Answer 37

gottem

Answer 38

There ya go, lol

Answer 39

And with that, you should be done! Here's the one I did as we were going along with this.

Answer 40

Perfect, thank u (:

Answer 41

No problem!

Answer 42

There's one more assignment that adds onto the last one, working with charts