How do I input formulas in the excel spreadsheet using hypothetical numbers?

User Generated

oaoevttfvirl

Business Finance

MTH 154

Germanna Community College

Description

I have a project due tomorrow midnight that is an excel spreadsheet. There are already values in the sheet but it has to be finished with hypothetical numbers ad formulas in each cell.

Unformatted Attachment Preview

Quantitative Reasoning Project 1: Gradebook Due Date: October 6, 2018 In this project, you will create a spreadsheet to calculate your grade for the QR course. The gradebook should give you a running tally of your grade at this point in the course, which requires that you use weighted averages. 1. (30%) You spreadsheet must contain a section for: 24 homework/excel files (0-10 pts each) 2 projects (100 pts each) 1 midterm (100 pts each) 1 final (100 pts each) An area to enter the weights ( 35%, 15% ETC) for each of the categories Your spreadsheet must be well labeled and neat. 2. (10%) Create cells which will compute the average HW grade, average project grade, and average exam grade. Name these cells appropriately, so if used in a formula the name will appear not the cell reference. 3. (10%) Create cells which will compute the max and min grades for the HW and Excel grades 4. (20%) Create a Histogram of your HW/Excel grades. You must choose appropriate bin sizes so that there is more than one column in your chart. Keep the chart next to where you enter grades, not on a separate sheet, so when you enter your grades the columns will change. 5. (5%) Format all of this nicely with borders and shading. Try to arrange so that it all fits onto one screen when Excel is opened to the max width of the monitor screen. 6. (20%) Create a cell which computes your total grade using the ideas of weighted average as discussed in class. 7. (5%) Calculate your average with a 100 for the projects and exams. What is your average if you get 100 on the projects and exams? Enter a grade of zero for the projects. What is your average if you do not complete the projects? Answer these two questions on the spreadsheet. A B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 HW Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 HW 28 Average 29 HW Max 30 HW Min HW Grade 40% 5 7 10 5 6 6.2 7.8 4 10 5 6.6 10 4 C D My Grade Spreadsheet Project Project Number Grade 1 2 Project Average Project Max Project Min 30% 100 50 75 100 50 E F G H Final Exam Number Exam Grade Midterm Exam Midterm Exam 1 15% 100 1 15% 100 Final Exam Average Exam Max Exam Min 100 100 100 Midterm Exam Average Max Min 100 100 100 A 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 B C D E F G Overall Average 63.9 Enter a grade of zero for the projects. What is your average is you do not complete the projects? If you do not complete the projects and you get a 0 your average is 58.8 What is your average if you get 100 on the projects and exams? Answer this question in this box. If you get 100 on both projects and the exams you will get a 99.1 H A 64 B C D E F G H
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags