A community for students.
Here's the question you clicked on:
 0 viewing
Destinyyyy
 one year ago
Need some help with excel 2013. I will metal and fan.
Destinyyyy
 one year ago
Need some help with excel 2013. I will metal and fan.

This Question is Closed

Destinyyyy
 one year ago
Best ResponseYou've already chosen the best response.0My 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.

Jaynator495
 one year ago
Best ResponseYou've already chosen the best response.1OOOOH! a easy question! :D

Destinyyyy
 one year ago
Best ResponseYou've already chosen the best response.0lmao you are the only person to say that

Jaynator495
 one year ago
Best ResponseYou've already chosen the best response.1this is a basic excel function, should be nice and simple x'D

Destinyyyy
 one year ago
Best ResponseYou've already chosen the best response.0Okay. Thank you.. But what did it do?

Destinyyyy
 one year ago
Best ResponseYou've already chosen the best response.0And what does the rest of the instructions mean?

Jaynator495
 one year ago
Best ResponseYou've already chosen the best response.1it 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
 one year ago
Best ResponseYou've already chosen the best response.0What did you do? Just set the whole thing to accounting? O.o

Destinyyyy
 one year ago
Best ResponseYou've already chosen the best response.0This is only step 7

Jaynator495
 one year ago
Best ResponseYou've already chosen the best response.1to me it sounds like a trick question *flys away*

Destinyyyy
 one year ago
Best ResponseYou've already chosen the best response.0Okay thank you for your help!! I might need more help later

Destinyyyy
 one year ago
Best ResponseYou've already chosen the best response.0Step 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
 one year ago
Best ResponseYou've already chosen the best response.0@GreenCat This is what im working on

Destinyyyy
 one year ago
Best ResponseYou've already chosen the best response.0I have 7 more steps. And another assignment using excel like this

GreenCat
 one year ago
Best ResponseYou've already chosen the best response.0Actually, I can't help you. Sorry.

GreenCat
 one year ago
Best ResponseYou've already chosen the best response.0First, you could make the formula. And the values you need to plug in would be written like "B3".

GreenCat
 one year ago
Best ResponseYou've already chosen the best response.0Step 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
 one year ago
Best ResponseYou've already chosen the best response.0What formula??? Absolute cell references?

e.mccormick
 one year ago
Best ResponseYou've already chosen the best response.0Absolute 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
 one year ago
Best ResponseYou've already chosen the best response.0Thank you for explaining.
Ask your own question
Sign UpFind more explanations on OpenStudy
Your question is ready. Sign up for free to start getting answers.
spraguer
(Moderator)
5
→ View Detailed Profile
is replying to Can someone tell me what button the professor is hitting...
23
 Teamwork 19 Teammate
 Problem Solving 19 Hero
 Engagement 19 Mad Hatter
 You have blocked this person.
 ✔ You're a fan Checking fan status...
Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.