A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

Destinyyyy

  • one year ago

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

  • This Question is Closed
  1. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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.

  2. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    @sleepyjess

  3. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    @e.mccormick

  4. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    @Jaynator495

  5. Jaynator495
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    OOOOH! a easy question! :D

  6. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    lmao you are the only person to say that

  7. Jaynator495
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

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

  8. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Hope so

  9. Jaynator495
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    http://prntscr.com/7kh224 TaDa

  10. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

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

  11. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    And what does the rest of the instructions mean?

  12. Jaynator495
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    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

  13. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

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

  14. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    This is only step 7

  15. Jaynator495
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

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

  16. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

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

  17. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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?

  18. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

  19. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    @GreenCat This is what im working on

  20. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

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

  21. GreenCat
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Actually, I can't help you. Sorry.

  22. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    That's okay.

  23. GreenCat
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

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

  24. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Huh?? O.o

  25. GreenCat
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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.

  26. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    What formula??? Absolute cell references?

  27. GreenCat
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    ¯\_(ツ)_/¯

  28. GreenCat
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    gtg

  29. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Um okay O.o

  30. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    @Jaynator495

  31. e.mccormick
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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.

  32. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Thank you for explaining.

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

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

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
  • 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.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.