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

Other questions on the subject: Mathematics

image
Mathematics, 21.06.2019 16:30, jordivivar74
For how answer my question this will be the last question can you answer in math subject
Answers: 2
image
Mathematics, 21.06.2019 17:30, meganenaranjo
If the speed of an electromagnetic wave is 100,000 cm/s and its wavelength is 100 cm, what is its frequency? a) 100,000 cycles per second (hz) b) 1 × 10-3 cycles per second (hz) c) 10,000,000 cycles per second (hz) d) 1,000 cycles per second (hz)
Answers: 1
image
Mathematics, 21.06.2019 18:00, santosv3136
What are the equivalent ratios for 24/2= /3= /5.5=108/ = /15
Answers: 1
image
Mathematics, 21.06.2019 19:00, LoneWolves
What is x and y intercepts for y=x+7
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 in other subjects:

Konu
Mathematics, 08.09.2019 16:10
Konu
Biology, 08.09.2019 16:10