Midterm+Exam

Your midterm files are in Doc Sharing under the MidTerm category. The instructions are located within the spreadsheet itself. Follow the instructions carefully!! Remember, NO posting of formulas....you may only provide GUIDANCE to your classmates! Good luck! Seek assistance in the lab, help file for excel, etc. NOTE: Error In Instructions!!!! First thing is "On row 11, you need to add a function to calculate the Total Retail Value for all Products." I think it should be changed "On row 35, you need to add a function to calculate the Total Retail Value for all Products."

Second thing is "Name the range of Total Retail values in Column E TotalRetail (name the Range E1:E28)" I think it should be changed "Name the range of Total Retail values in Column E TotalRetail (name the Range E5:E28)"

What does "percentage of total retail value" mean??? What is the definition of it?? (Youngin Lee)

response to Youndin Lee it is hard to explain it without giving you the formula. But the best thing to do is in YouTube just type in does key formulas or words and ill pop up real quick what you need. I had forgotten how some formulas go and I used YouTube and it walked you step by step which was very nice. - Javier

I just got done with my Midterm spread sheet and I really recommend using YouTube. It is a big help! Ill like to help if you need some help just ask me on Facebook, since I do not look at the wiki that frequent. Good luck - Javier

Thank you so much, Javier. First, I will try to do by myself:) (Youngin Lee)

One hint I would give is that percentages are figured in Excel just like they are in math class. A ratio is a ratio no matter how you slice it. 10% of 100 is 10. Now just think about what percentage of what numer you want to find and apply it to excel as a formula. I agree with Javier, it's hard explain how it works without just putting the formula out there. Hope this helps. - Brett

What does it mean when she asks On row 11, you need to add a function to calculate the Total Retail Value for all Products.? (Blanca Mireles)

Don't forget the answer key is available to you. It helped me a lot. I am still a little confused as to which ranges she wants named. I also was unable to change the color of my tabs since I'm on a mac... (Jessica Chumley)

I must have done something wrong since my 23% & 14% did not come up red (warning) everything else is good though. Carlos Padilla

I'm a little confused on which ranges she wants named. Do we name individual cells? (Vanessa Lyons)

I have the same question as Vanessa, in the directions where it says "name the cell holding Total Retail Value appropriately (range name)" does that mean simply to address the correct cells, or to somehow name the cell? Sorry if that's a silly question. (Samantha White)

Jessica Chumley, thank you for reminding me to look at the solution images. That was the "Oh, duh!" moment I needed! (Samantha White)

I have the same question as Samantha & Vanessa... do we name the cells individually because once I name "E5" to (Totalretail) it confused me at how to name the cells. (Jardin Battle)

You can select the range (multiple cells) and then right click there should be an option to name the range.(Jeremy Bell)

I was confused too in the midterm because of the row 11 issue. Thank You for correcting that. (Marlon Adrian Segura)