Question

Will someone PLEASE HELP me with my EXCEL assignment?

Answer 1

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

Answer 2

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.

Answer 3

ok so how do I do that?

Answer 4

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:)

Answer 5

Thank you so very very much!!!!

Answer 6

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

Answer 7

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:)

Answer 8

how do i do that?

Answer 9

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.

Answer 10

WOW! wish I would have learned that sooner

Answer 11

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

Answer 12

I hope this was a help to you:)

Answer 13

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)?

Answer 14

Hang on Tina, let me check it:)

Answer 15

Yes =SUM(D6:G6)

Answer 16

SUM should be capitalized

Answer 17

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

Answer 18

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

Answer 19

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

Answer 20

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

Answer 21

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")))

Answer 22

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

Answer 23

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

Answer 24

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

Answer 25

yes all columns have been filled in with the correct values

Answer 26

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

Answer 27

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:)

Answer 28

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.

Answer 29

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

Answer 30

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

Answer 31

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

Answer 32

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

Answer 33

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

Answer 34

Make sure you save the new file:)

Answer 35

oop's almost forgot that would have sucked.

Answer 36

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

Answer 37

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?

Answer 38

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:(

Answer 39

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

Answer 40

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.

Answer 41

and I like my jack with a little Dew

Answer 42

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.

Answer 43

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

Answer 44

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?

Answer 45

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?

Answer 46

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

Answer 47

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

Answer 48

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

Answer 49

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

Answer 50

my email is aatinabo@yahoo.com

Answer 51

Sent:)

Answer 52

Worked for me:)

Answer 53

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

Answer 54

please explain how to do help gives lots of examples?

Answer 55

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

Answer 56

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

Answer 57

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

Answer 58

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

Answer 59

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

Answer 60

Hang on, let me check:)

Answer 61

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:)

Answer 62

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

Answer 63

Where do I put those in?

Answer 64

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

Answer 65

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

Answer 66

ID 943 for second line, it works:)

Answer 67

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.

Answer 68

ty

Answer 69

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

Answer 70

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

Answer 71

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:)

Answer 72

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

Answer 73

Copy and paste here your line 6 formula:)

Answer 74

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

Answer 75

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

Answer 76

i get a 0

Answer 77

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

Answer 78

Huh? You in line 6?

Answer 79

yes

Answer 80

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

Answer 81

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

Answer 82

Check to make sure the formula is in K6:)

Answer 83

it is now i got letters now

Answer 84

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:)

Answer 85

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

Answer 86

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