anonymous
  • anonymous
Will someone PLEASE HELP me with my EXCEL assignment?
Mathematics
  • Stacey Warren - Expert brainly.com
Hey! We 've verified this expert answer for you, click below to unlock the details :)
SOLVED
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.
chestercat
  • chestercat
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
anonymous
  • anonymous
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
anonymous
  • anonymous
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.
anonymous
  • anonymous
ok so how do I do that?
1 Attachment

Looking for something else?

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

More answers

anonymous
  • anonymous
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:)
anonymous
  • anonymous
Thank you so very very much!!!!
1 Attachment
anonymous
  • anonymous
now Im trying to figure out why it keeps attaching that file
1 Attachment
anonymous
  • anonymous
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:)
anonymous
  • anonymous
how do i do that?
anonymous
  • anonymous
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.
anonymous
  • anonymous
WOW! wish I would have learned that sooner
anonymous
  • anonymous
Ha! You made an old man laugh! You get a medal for that:)
anonymous
  • anonymous
I hope this was a help to you:)
anonymous
  • anonymous
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)?
anonymous
  • anonymous
Hang on Tina, let me check it:)
anonymous
  • anonymous
Yes =SUM(D6:G6)
anonymous
  • anonymous
SUM should be capitalized
anonymous
  • anonymous
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
anonymous
  • anonymous
H25 contains the number 825 on the Summary tab which is a total of line 25. Is there a next step?
anonymous
  • anonymous
it says to name the cell, I figured that part out, you click on H25 and and then click on name a range
anonymous
  • anonymous
Yes, the range should extend from D to G with the total displayed in H:)
anonymous
  • anonymous
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")))
anonymous
  • anonymous
Did you try playing with it in a formula bar to see what results you got?
anonymous
  • anonymous
yes it is suppose to be the letter grade but the grade I am getting is not whats on the sample sheet
anonymous
  • anonymous
Have you populated row 6 in the summary sheet from the other 4 tabs?
anonymous
  • anonymous
yes all columns have been filled in with the correct values
anonymous
  • anonymous
Okay, post a copy of that sheet for me:) Then I will try it to see what happens:)
anonymous
  • anonymous
1 Attachment
anonymous
  • anonymous
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:)
anonymous
  • anonymous
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
anonymous
  • anonymous
Okay, the sheet file "gradebook" is your's. Did the text get 825 for H25?
anonymous
  • anonymous
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
anonymous
  • anonymous
I see that, no Cs. Okay, let me look:)
anonymous
  • anonymous
Found it. Ha! Modify your IF statement to include Cs:)
anonymous
  • anonymous
I didnt even notice it missing when I typed it in, or when I used the show formulas , again TY
1 Attachment
anonymous
  • anonymous
Make sure you save the new file:)
anonymous
  • anonymous
oop's almost forgot that would have sucked.
anonymous
  • anonymous
Ha! I am on Pacific time and half a bottle of Jack later:) brown19472002@ yahoo.com Glad to have been a help, anytime:)
anonymous
  • anonymous
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?
anonymous
  • anonymous
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:(
anonymous
  • anonymous
Put my email address in your Yahoo contacts list, you should see my email account as open:)
anonymous
  • anonymous
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.
anonymous
  • anonymous
and I like my jack with a little Dew
anonymous
  • anonymous
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.
anonymous
  • anonymous
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
anonymous
  • anonymous
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?
anonymous
  • anonymous
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?
anonymous
  • anonymous
I forgot a step on my grade book, it says to revise the file to calculate the grade using VLookup function?
anonymous
  • anonymous
Ha! Hugh will do:) VLookup function, Okay, we should be able to look up the protocols for that.
anonymous
  • anonymous
Your email address says it is invalid brown19472002@ yahoo.com?
anonymous
  • anonymous
Okay, send me an email and I'll check to see if I receive it, that is the right address:)
anonymous
  • anonymous
my email is aatinabo@yahoo.com
anonymous
  • anonymous
Sent:)
anonymous
  • anonymous
Worked for me:)
anonymous
  • anonymous
The Excel HELP screen gives a good example for the VLookup function.
anonymous
  • anonymous
please explain how to do help gives lots of examples?
anonymous
  • anonymous
=VLOOKUP(1,D6:I23,2) Am I atleast close because it is not working?
anonymous
  • anonymous
Hang on:) Let me check how you are using it:)
anonymous
  • anonymous
=VLOOKUP(606,A2:J23,8,FALSE) Will get you going:)
anonymous
  • anonymous
It needed an Identifier, ID number, from left-side column A, a range of cells, and argument, i.e. False:)
anonymous
  • anonymous
ok so the next one should be =VLOOKUP(943,A2:J23,8,FALSE)?
anonymous
  • anonymous
Hang on, let me check:)
anonymous
  • anonymous
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:)
anonymous
  • anonymous
Oh! Will need Absolute $ address to get formula to change on the copy:)
anonymous
  • anonymous
Where do I put those in?
anonymous
  • anonymous
ID numbers, Okay, you will have to change each line formula to use to proper ID number, try it:)
anonymous
  • anonymous
Use a separate column to play with this until you get the results you want. Save file:)
anonymous
  • anonymous
ID 943 for second line, it works:)
anonymous
  • anonymous
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.
anonymous
  • anonymous
ty
anonymous
  • anonymous
Let me know you got it to work for you:)
anonymous
  • anonymous
should I be getting a letter or the same as the total column?
anonymous
  • anonymous
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:)
anonymous
  • anonymous
when i put the 10 in it it gives me a circular reference warning then goes to 0
anonymous
  • anonymous
Copy and paste here your line 6 formula:)
anonymous
  • anonymous
=VLOOKUP(606,A2:J23,8,FALSE)
anonymous
  • anonymous
=VLOOKUP(606,A2:J23,10,FALSE) Ha! Change the 8 to a 10, you have it:)
anonymous
  • anonymous
i get a 0
anonymous
  • anonymous
You will then copy down the formula. Then you only have to go back and manually change the ID number per row formula:)
anonymous
  • anonymous
Huh? You in line 6?
anonymous
  • anonymous
yes
anonymous
  • anonymous
=VLOOKUP(606,A2:J23,10,FALSE)
anonymous
  • anonymous
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
anonymous
  • anonymous
Check to make sure the formula is in K6:)
anonymous
  • anonymous
it is now i got letters now
anonymous
  • anonymous
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:)
anonymous
  • anonymous
I will ty for all your help. good night sorry if i kept you up
anonymous
  • anonymous
No Jack left :( Bottle is empty:( Later:)

Looking for something else?

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