Question

Need some help with excel 2013. I will metal and fan.

Answer 1

My instructions say -- "Apply the Accounting Number Format to the first row of sales figures and to the total row, and the Comma Style to the remaining sales figures. Format the totals in row 7 with the Total cell style." This is my first time using excel.

Answer 2

@sleepyjess

Answer 3

@e.mccormick

Answer 4

@Jaynator495

Answer 5

OOOOH! a easy question! :D

Answer 6

lmao you are the only person to say that

Answer 7

this is a basic excel function, should be nice and simple x'D

Answer 8

Hope so

Answer 9

http://prntscr.com/7kh224 TaDa

Answer 10

Okay. Thank you.. But what did it do?

Answer 11

And what does the rest of the instructions mean?

Answer 12

it changed the format to the accounting format x'D (and tbh the rest sounds like a trick question asking you to just do this... http://prntscr.com/7kh3vv

Answer 13

What did you do? Just set the whole thing to accounting? O.o

Answer 14

This is only step 7

Answer 15

to me it sounds like a trick question *flys away*

Answer 16

Okay thank you for your help!! I might need more help later

Answer 17

Step 9-- Using absolute cell references as necessary so that you can copy the formula, in cell G4 construct a formula to calculate the Percent of Total Sales for the first region. Copy the formula down for the remaining regions." Where is the absolute cell references?

Answer 18

@GreenCat This is what im working on

Answer 19

I have 7 more steps. And another assignment using excel like this

Answer 20

Actually, I can't help you. Sorry.

Answer 21

That's okay.

Answer 22

First, you could make the formula.
And the values you need to plug in would be written like "B3".

Answer 23

Huh?? O.o

Answer 24

Step 9-- Using absolute cell references as necessary so that you can copy the formula, in cell G4 construct a formula to calculate the Percent of Total Sales for the first region. Copy the formula down for the remaining regions." Where is the absolute cell references?

Use the formula.

Answer 25

What formula??? Absolute cell references?

Answer 26

¯\_(ツ)_/¯

Answer 27

gtg

Answer 28

Um okay O.o

Answer 29

@Jaynator495

Answer 30

Absolute references use the $ to lock the row, column, or both: A lot of times this is used for a constant value or to make sure things work if moved around.

say that e1 was 3.14 as a constant for pi. Then column a was the radius of a bunch of circles and you wanted column b to be the area of the circles. Then you could put this in b1:

=$e$1*a1*a1
Then when you copy and paste it into say b2 it would become:
=$e$1*a2*a2

Because the e1 was locked with $ it would stay the same. That is an absolute reference.

Answer 31

Thank you for explaining.