A community for students.
Here's the question you clicked on:
 0 viewing
anonymous
 4 years ago
Will someone PLEASE HELP me with my EXCEL assignment?
anonymous
 4 years ago
Will someone PLEASE HELP me with my EXCEL assignment?

This Question is Closed

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0enter 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

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Hi 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.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0ok so how do I do that?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Okay, 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:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Thank you so very very much!!!!

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0now Im trying to figure out why it keeps attaching that file

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Tina, Not sure, try resaving 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:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Go 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.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0WOW! wish I would have learned that sooner

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Ha! You made an old man laugh! You get a medal for that:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I hope this was a help to you:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0it 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)?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Hang on Tina, let me check it:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0SUM should be capitalized

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Ty, and do you by any chance know how to name a cell? next step says to name cell H25. Thank you for the tip

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0H25 contains the number 825 on the Summary tab which is a total of line 25. Is there a next step?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0it says to name the cell, I figured that part out, you click on H25 and and then click on name a range

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Yes, the range should extend from D to G with the total displayed in H:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0but I am having trouble with an IF statement =IF(I6>0.899,"A",IF(I6>0.799,"B",IF(I6>0.599,"D","E")))

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Did you try playing with it in a formula bar to see what results you got?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0yes it is suppose to be the letter grade but the grade I am getting is not whats on the sample sheet

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Have you populated row 6 in the summary sheet from the other 4 tabs?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0yes all columns have been filled in with the correct values

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Okay, post a copy of that sheet for me:) Then I will try it to see what happens:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Formula 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:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0the 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.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Okay, the sheet file "gradebook" is your's. Did the text get 825 for H25?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0yes 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

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I see that, no Cs. Okay, let me look:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Found it. Ha! Modify your IF statement to include Cs:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I didnt even notice it missing when I typed it in, or when I used the show formulas , again TY

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Make sure you save the new file:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0oop's almost forgot that would have sucked.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Ha! I am on Pacific time and half a bottle of Jack later:) brown19472002@ yahoo.com Glad to have been a help, anytime:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I 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?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Oh 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:(

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Put my email address in your Yahoo contacts list, you should see my email account as open:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I 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.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0and I like my jack with a little Dew

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Dew 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.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I 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

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Most 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?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I 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?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I forgot a step on my grade book, it says to revise the file to calculate the grade using VLookup function?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Ha! Hugh will do:) VLookup function, Okay, we should be able to look up the protocols for that.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Your email address says it is invalid brown19472002@ yahoo.com?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Okay, send me an email and I'll check to see if I receive it, that is the right address:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0my email is aatinabo@yahoo.com

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0The Excel HELP screen gives a good example for the VLookup function.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0please explain how to do help gives lots of examples?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0=VLOOKUP(1,D6:I23,2) Am I atleast close because it is not working?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Hang on:) Let me check how you are using it:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0=VLOOKUP(606,A2:J23,8,FALSE) Will get you going:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0It needed an Identifier, ID number, from leftside column A, a range of cells, and argument, i.e. False:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0ok so the next one should be =VLOOKUP(943,A2:J23,8,FALSE)?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Hang on, let me check:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Figured 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:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Oh! Will need Absolute $ address to get formula to change on the copy:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Where do I put those in?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0ID numbers, Okay, you will have to change each line formula to use to proper ID number, try it:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Use a separate column to play with this until you get the results you want. Save file:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0ID 943 for second line, it works:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0i.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.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Let me know you got it to work for you:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0should I be getting a letter or the same as the total column?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Right! A letter grade; note I changed the 8 to a 10 in the base formula:) Should match the grade in your column figured previously:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0when i put the 10 in it it gives me a circular reference warning then goes to 0

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Copy and paste here your line 6 formula:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0=VLOOKUP(606,A2:J23,8,FALSE)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0=VLOOKUP(606,A2:J23,10,FALSE) Ha! Change the 8 to a 10, you have it:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0You will then copy down the formula. Then you only have to go back and manually change the ID number per row formula:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0=VLOOKUP(606,A2:J23,10,FALSE)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Are 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

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Check to make sure the formula is in K6:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0it is now i got letters now

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0All 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:)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I will ty for all your help. good night sorry if i kept you up

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0No Jack left :( Bottle is empty:( Later:)
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.