+ C:/Users/pertunia/Desktop/IQTT5111A1_FT.pdf 2022 21; 22 Q.3.1 Determine the % marks that the students obtained for each of the

Question

2 years ago

12

+ 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

Mathematics

1 answer:

almond37 [142] · Answer 1 · 2023-05-18T17:37:36+03:00

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

<h3>How to determine the % marks that the students obtained?</h3>

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.