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 15:00
15 point ! ~ see if you know the answer to both you!
Answers: 1
question
Mathematics, 21.06.2019 18:30
Select the lengths in centimeters that would form a right triangle
Answers: 1
question
Mathematics, 21.06.2019 22:00
Liz is shipping a package to her friend. the maximum weight of a medium flat-rate box is 20 pounds, including the box which weighs 6 ounces. write and solve an inequality to describe the possible weight in pounds, w, of the contents that liz will ship to her friend if she must use a medium flat-rate box. use the drop-down menus to explain your answer.
Answers: 2
question
Mathematics, 22.06.2019 02:30
An incoming airplane is x miles due north from the control tower at an airport. a second incoming airplane is y miles due east of the same control tower. the shortest distance between the two airplanes is z miles. which of the following functions would best model the situation above?
Answers: 1
You know the right answer?
Problem 2.3 - Enter the following grade report into an empty Excel worksheet. Place the heading (Gra...
Questions
question
Mathematics, 25.01.2021 21:40
question
Mathematics, 25.01.2021 21:40
question
Computers and Technology, 25.01.2021 21:40
Questions on the website: 13722360