A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

anonymous

  • 4 years ago

Will someone PLEASE HELP me with my EXCEL assignment?

  • This Question is Closed
  1. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    enter a formula into cell D6 in the Summary sheet that will display the total number of homework points for the first student (Melissa Altiveros) from the homework sheet

    1 Attachment
  2. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Hi Tina, See attached. Equals, in D6 Summary tab, from Total from Homework tab. See tabs at bottom of spreadsheet which allow you to move between tabs to select input to the Summary sheet. Hope this helps.

  3. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    ok so how do I do that?

    1 Attachment
  4. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Okay, type = in D6, then go to the Homework tab and click on 93 in the totals column, then flip back to the Summary tab. Then look in the formula bar, your done:)

  5. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Thank you so very very much!!!!

    1 Attachment
  6. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    now Im trying to figure out why it keeps attaching that file

    1 Attachment
  7. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Tina, Not sure, try re-saving the version you want to keep. You can now fill the whole column by pulling the formula down the column:) The formulas will change automatically and pull the input from the Homework tab. Try it:)

  8. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    how do i do that?

  9. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Go to D6 in Summary tab, then grab the little plus sign in the bottom corner of the cell and pull it down the column. What you are doing is copying the formula downward.

  10. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    WOW! wish I would have learned that sooner

  11. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Ha! You made an old man laugh! You get a medal for that:)

  12. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I hope this was a help to you:)

  13. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    it really is I am really new to Excel, and the class I am taking is getting to be frustrated. To calculate the total points for each student in column H, would be =sum(D6:G6)?

  14. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Hang on Tina, let me check it:)

  15. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Yes =SUM(D6:G6)

  16. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    SUM should be capitalized

  17. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Ty, and do you by any chance know how to name a cell? next step says to name cell H25. Thank you for the tip

  18. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    H25 contains the number 825 on the Summary tab which is a total of line 25. Is there a next step?

  19. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    it says to name the cell, I figured that part out, you click on H25 and and then click on name a range

  20. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Yes, the range should extend from D to G with the total displayed in H:)

  21. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    but I am having trouble with an IF statement =IF(I6>0.899,"A",IF(I6>0.799,"B",IF(I6>0.599,"D","E")))

  22. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Did you try playing with it in a formula bar to see what results you got?

  23. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    yes it is suppose to be the letter grade but the grade I am getting is not whats on the sample sheet

  24. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Have you populated row 6 in the summary sheet from the other 4 tabs?

  25. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    yes all columns have been filled in with the correct values

  26. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Okay, post a copy of that sheet for me:) Then I will try it to see what happens:)

  27. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    1 Attachment
  28. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Formula is good =IF(I6>0.899,"A",IF(I6>0.799,"B",IF(I6>0.599,"D","E"))) Click on I6, they named H25 as POSSIBLE POINTS which is 825. Check that in your file. Also check to see you are carrying the percent input to two decimal places:)

  29. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    the sheet i sent was my assignment, i dont have a copy of the sample sheet it is in the textbook. That grade that is on the sample sheet all the D's on my sheet are C's on the sample sheet. The next step says to review the Summary worksheet and make any necessary formula and/or formatting changes.

    1 Attachment
  30. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Okay, the sheet file "gradebook" is your's. Did the text get 825 for H25?

  31. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    yes everything matches except the grades only the C's on the sample sheet are D's on mine, I have looked at the formulas they are all correct and I have ran error check

    1 Attachment
  32. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I see that, no Cs. Okay, let me look:)

  33. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Found it. Ha! Modify your IF statement to include Cs:)

  34. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I didnt even notice it missing when I typed it in, or when I used the show formulas , again TY

    1 Attachment
  35. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Make sure you save the new file:)

  36. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    oop's almost forgot that would have sucked.

  37. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Ha! I am on Pacific time and half a bottle of Jack later:) brown19472002@ yahoo.com Glad to have been a help, anytime:)

  38. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I am on Eastern I will be up for a long while Internet was down for the last 3 1/2 days I am an Accounting Major, beginning my second year. Do you drink your Jack straight or mix? And do you use Yahoo messenger?

  39. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Oh Wow, not good. Straight up! BS in Information Systems, MBA w/Finance emphasis, MS Accounting, MS Financial Management & PMF Fellowship finalist. Yes, but slow typing:(

  40. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Put my email address in your Yahoo contacts list, you should see my email account as open:)

  41. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I think I just found my new best friend, I am working on my BA in Accounting, and I am always on here looking for help, midterms next week. Then its on to Peach Tree.

  42. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    and I like my jack with a little Dew

  43. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Dew will do! Well, the best to you on exams. Peach Tree should be fun after IF statements. Ha! Most of my children and grandchildren are on the east coast, MD, DE & VA.

  44. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I am in FL, just moved back here from CO. Thank you for all your help and patience. Looking forward to PT. So now that I know your educational background what was your overall career choice

  45. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Most welcome, any time Tina. I work for the Army Corps of Engineers, civilian employee in Construction Management, Contract Administration and negotiation. How long before you have your BA and where do you want to work? How about a CPA?

  46. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I graduate god willing, Dec 2014. I actually want to have my own Accounting firm one day , but not 100% sure. Tax auditor for the IRS, is a thought. I think it would be alot less complicated if I had a good mentor. I am my only support. Thank god for Open study, I would have given up in my Algebra class. Well Mr. Brown may I have the pleasure of knowing your first name?

  47. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I forgot a step on my grade book, it says to revise the file to calculate the grade using VLookup function?

  48. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Ha! Hugh will do:) VLookup function, Okay, we should be able to look up the protocols for that.

  49. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Your email address says it is invalid brown19472002@ yahoo.com?

  50. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Okay, send me an email and I'll check to see if I receive it, that is the right address:)

  51. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    my email is aatinabo@yahoo.com

  52. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Sent:)

  53. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Worked for me:)

  54. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    The Excel HELP screen gives a good example for the VLookup function.

  55. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    please explain how to do help gives lots of examples?

  56. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    =VLOOKUP(1,D6:I23,2) Am I atleast close because it is not working?

  57. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Hang on:) Let me check how you are using it:)

  58. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    =VLOOKUP(606,A2:J23,8,FALSE) Will get you going:)

  59. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    It needed an Identifier, ID number, from left-side column A, a range of cells, and argument, i.e. False:)

  60. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    ok so the next one should be =VLOOKUP(943,A2:J23,8,FALSE)?

  61. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Hang on, let me check:)

  62. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Figured it out:) =VLOOKUP(943,A2:J23,10,FALSE) Create an extra column at line 6 paste this formula and copy the formula down the column, just like before, you will be surprised:)

  63. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Oh! Will need Absolute $ address to get formula to change on the copy:)

  64. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Where do I put those in?

  65. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    ID numbers, Okay, you will have to change each line formula to use to proper ID number, try it:)

  66. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Use a separate column to play with this until you get the results you want. Save file:)

  67. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    ID 943 for second line, it works:)

  68. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    i.e. Third line formula =VLOOKUP(983,A4:J25,10,FALSE) should display a grade of D and so forth down the sheet, you will only have to change the ID number for each line in your formula.

  69. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    ty

  70. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Let me know you got it to work for you:)

  71. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    should I be getting a letter or the same as the total column?

  72. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Right! A letter grade; note I changed the 8 to a 10 in the base formula:) Should match the grade in your column figured previously:)

  73. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    when i put the 10 in it it gives me a circular reference warning then goes to 0

  74. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Copy and paste here your line 6 formula:)

  75. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    =VLOOKUP(606,A2:J23,8,FALSE)

  76. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    =VLOOKUP(606,A2:J23,10,FALSE) Ha! Change the 8 to a 10, you have it:)

  77. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    i get a 0

  78. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    You will then copy down the formula. Then you only have to go back and manually change the ID number per row formula:)

  79. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Huh? You in line 6?

  80. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    yes

  81. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    =VLOOKUP(606,A2:J23,10,FALSE)

  82. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Are you beginning the test column K starting next to the cell with the D grade, 1st row, line 6? Something like this: ID # Last Name First Name Homework Projects Quizzes Exams Total Percent 000606 Altiveros Melissa 93 312 33 213 651 78.91% Letter Test D D

  83. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Check to make sure the formula is in K6:)

  84. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    it is now i got letters now

  85. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    All Right:) Just change the ID number in each row formula, nothing else:) I am going to bed! Get up at 4. Email when you need help:)

  86. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I will ty for all your help. good night sorry if i kept you up

  87. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    No Jack left :( Bottle is empty:( Later:)

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