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 19:30
Nikolas calculated the volume of the prism. his work is shown below.
Answers: 1
question
Mathematics, 21.06.2019 19:30
The volume of a cube-shaped shipping container is 13,824 cubic inches. find the edge length of the shipping container.
Answers: 1
question
Mathematics, 21.06.2019 20:30
William invested $5000 in an account that earns 3.8% interest, compounded annually. the formula for compound interest is a(t) = p(1 + i)t. how much did william have in the account after 6 years? (apex)
Answers: 2
question
Mathematics, 21.06.2019 21:00
Atorch and a battery cost 2.50 altogether.the torch costs 1.50 more than the battery.what fraction of the total price is the torch? give your answer in its simplest form.
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
Advanced Placement (AP), 29.08.2020 21:01
Questions on the website: 13722360