Information Technology IT – 8 Spreadsheets | e-Consult

Question

Question 2

You are given a spreadsheet containing student exam scores. The columns are: A - Student Name, B - Maths Score, C - Science Score, D - English Score. You need to identify and highlight any students who achieved a 'Pass' in all three core subjects (Maths, Science, and English). A 'Pass' is defined as a score of 40 or above. Describe how you would use a spreadsheet function to achieve this. Include the function name and provide a formula example.

Answer 1

To identify students who passed all three core subjects, I would use a combination of the IF and AND functions. The IF function checks a condition, and the AND function returns TRUE only if all conditions are TRUE.

The formula would be:

=IF(AND(B2>=40, C2>=40, D2>=40), "Pass", "Fail")

Explanation:

B2, C2, D2: These refer to the Maths, Science, and English scores for the current student (row 2).

B2>=40, C2>=40, D2>=40: These are the conditions checking if the scores are 40 or above.

AND(condition1, condition2, condition3): This ensures that all three conditions are met.

IF(condition, valueiftrue, valueiffalse): If all conditions are true (the student passed all subjects), the formula returns "Pass"; otherwise, it returns "Fail".

Information Technology IT – 8 Spreadsheets | e-Consult

8 Spreadsheets (1 questions)

Question 2