Sign In Sign Up Ask an AI advisor
PrincesssOfficial
PrincesssOfficial
06.03.2020 • 
Mathematics

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. Copy and paste your cells into the answer. Show data and formulas. The easiest way is to copy and paste data, then show formulas and copy and paste again.

Solved
Show answers

Ask an AI advisor a question

I want advice