subject
Mathematics, 04.10.2020 14:01 kiahbryant12

Problem 2.3 - Enter the following grade report into an empty Excel worksheet. Place the heading (Grade Report) in cell Al. (The numerical grades correspond to letter grades, i. e., A = 4.0, B = 3.0, C = 2.0, D = 1.0, F = 0. Fractional values represent pluses and minuses, i. e., A- = 3.7, B+ = 3.3, B- = 2.7, etc.). Don't enter or calculate letter grades. Be sure that all of the strings (text) are fully visible within the worksheet. Calculate the average grade WEIGHTED BY CREDITS and show formulas. For example, the average of 3.0 for a 4 credit class and 2.0 for a 3 credit class is (3*4+2*3)/(4+3 credits) = 2.57, NOT 2.5. Show formulas, copy, and paste your cells into the answer. Grade Report (Your full name) CourseCreditsGrade Chemistry I43.0 Physics I43.3 English Composition32.0 Intro to Engineering34.0 Calculus I33.7 Seminar12.7 Problem 2.5 - Make the following changes to the spreadsheet above. (a) Change the heading from Grade Report to Semester Grade Report. (b) Change Intro to Engineering to Engineering Analysis. (c) Change the number of credits for Physics I from 4 to 3. (d) Change the grade for English Composition from 2.0 to 2.7. Show formulas, copy, and paste your cells into the answer after the previous answer.

ansver
Answers: 1

Another question on Mathematics

question
Mathematics, 21.06.2019 14:00
The table shows the distance traveled over time while traveling at a constant speed.
Answers: 1
question
Mathematics, 21.06.2019 17:30
How many kilometers are equal to 5 miles? use 1 mile β‰ˆ 1.61 kilometers. !
Answers: 2
question
Mathematics, 21.06.2019 21:20
In 2009, there were 1570 bears in a wildlife refuge. in 2010, the population had increased to approximately 1884 bears. if this trend continues and the bear population is increasing exponentially, how many bears will there be in 2018?
Answers: 2
question
Mathematics, 21.06.2019 22:00
Can you me find the slope! (30 points)
Answers: 2
You know the right answer?
Problem 2.3 - Enter the following grade report into an empty Excel worksheet. Place the heading (Gra...
Questions
question
Geography, 20.05.2021 18:30
question
Mathematics, 20.05.2021 18:30
question
Mathematics, 20.05.2021 18:30
question
Mathematics, 20.05.2021 18:30
question
Spanish, 20.05.2021 18:30
question
History, 20.05.2021 18:30