Question: Note that columns C and D store student's lab exam I and lab exam II grades. The max grade for these 2 columns is 1

Note that columns C and D store student's lab exam I and lab exam II grades. The max grade
for these 2 columns is 10 but the instructor would like all grades to be stored in percentage
(out of 100). Enter 10 in column C2; Use the copy-and-paste-special method to update the
existing grades in columns C and D to be stored out of a max of 100 now (e.g.9 should be
updated 90). Reapply any formatting if it is removed, so the entire table is consistent.
I am given values out of 10 but i need to get them out of 100 for percentage. It does not tell us to add another column, and everytime I try a formula it will just use the same value from the first calculation (ex.,=9/$C$2 will make every column 0.90. Idk how to use the formula without adding another column. If i add another column it messes up the next steps of the assignment.
Note that columns C and D store student's lab

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!