Question

+ C:/Users/pertunia/Desktop/IQTT5111A1_FT.pdf 2022 21; 22 Q.3.1 Determine the % marks that the students obtained for each of the modules, given that: Q.3.1.1 The total number of marks available for the Statistics module was 600. (4) Determine this by entering an appropriate formula in cells C2 to C12​

Answer 1

The question is an illustration of Excel formulas, and the formula to enter in cell C2 is: =(B2/600)

How to determine the % marks that the students obtained?

To enter a formula in Microsoft Office Excel, we make use of the following syntax:

= (Formula)

From the question, the total score is 600.

So, the formula to enter in cell C2 is:

=(B2/600)

Next, drag the content of cell B2 through cell C12.

This is to ensure that all cells C2 to C12 have the appropriate formula.

Lastly, following the highlighted steps to show the result as percentage

• Go to the home tab
• Select the number group
• Click the Percent Style button
• Increase the number of decimal places, as desired.

Read more about Excel formulas at:

https://brainly.com/question/14299634

#SPJ1