5.3.1 Which function would be used in cell C15 to determin…
5.3.1 Which function would be used in cell C15 to determine how many students scored 80 marks or more? (1) 5.3.2 Even though the marks in cells C4:C13 were formatted to the nearest whole number, the total of all the marks in cell C16 shows a value after the decimal point. Explain why this is happening by referring to the difference between using formatting and using the ROUND function. (2) 5.3.3 Name the most suitable data type that should be used in cells D4:D13. (1) 5.3.4 Name a function that could be used in column D to automatically give the answer ‘Yes’ or ‘No’, based on the marks in column C. (1)