At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
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.
OOOOH! a easy question! :D
lmao you are the only person to say that
this is a basic excel function, should be nice and simple x'D
Okay. Thank you.. But what did it do?
And what does the rest of the instructions mean?
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
What did you do? Just set the whole thing to accounting? O.o
This is only step 7
to me it sounds like a trick question *flys away*
Okay thank you for your help!! I might need more help later
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?
@GreenCat This is what im working on
I have 7 more steps. And another assignment using excel like this
Actually, I can't help you. Sorry.
First, you could make the formula. And the values you need to plug in would be written like "B3".
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.
What formula??? Absolute cell references?
Um okay O.o
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.
Thank you for explaining.