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

- Destinyyyy

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

- Stacey Warren - Expert brainly.com

Hey! We 've verified this expert answer for you, click below to unlock the details :)

- chestercat

I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!

- Destinyyyy

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.

##### 1 Attachment

- Destinyyyy

@sleepyjess

- Destinyyyy

@e.mccormick

Looking for something else?

Not the answer you are looking for? Search for more explanations.

## More answers

- Destinyyyy

@Jaynator495

- Jaynator495

OOOOH! a easy question! :D

- Destinyyyy

lmao you are the only person to say that

- Jaynator495

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

- Destinyyyy

Hope so

- Jaynator495

http://prntscr.com/7kh224 TaDa

- Destinyyyy

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

- Destinyyyy

And what does the rest of the instructions mean?

- Jaynator495

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

- Destinyyyy

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

- Destinyyyy

This is only step 7

- Jaynator495

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

- Destinyyyy

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

- Destinyyyy

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?

- Destinyyyy

##### 1 Attachment

- Destinyyyy

@GreenCat This is what im working on

- Destinyyyy

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

- GreenCat

Actually, I can't help you. Sorry.

- Destinyyyy

That's okay.

- GreenCat

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

- Destinyyyy

Huh?? O.o

- GreenCat

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.

- Destinyyyy

What formula??? Absolute cell references?

- GreenCat

¯\_(ツ)_/¯

- GreenCat

gtg

- Destinyyyy

Um okay O.o

- Destinyyyy

@Jaynator495

- e.mccormick

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.

- Destinyyyy

Thank you for explaining.

Looking for something else?

Not the answer you are looking for? Search for more explanations.