Information Communication Technology ICT – 13 Layout | e-Consult

To correct incorrect scores and ensure the total score is calculated accurately, the following steps should be taken:

1. Identify Incorrect Scores: The student should carefully review the 'Exam 1 Score' and 'Exam 2 Score' columns to identify any values that are clearly incorrect (e.g., negative scores, scores outside the expected range). Highlighting these cells can aid in identification.
2. Cut and Paste (Correct Values): For each incorrect score, the student should cut the incorrect value and paste the correct value into the corresponding cell. This ensures the data is updated.
3. Use a Formula for Total Score: To ensure the 'Total Score' is calculated automatically, the student should use a formula. In the 'Total Score' column, they should enter a formula that adds the 'Exam 1 Score' and 'Exam 2 Score' for each row. For example, if 'Exam 1 Score' is in column B and 'Exam 2 Score' is in column C, the formula would be '=B2+C2' (assuming the first data row is row 2).
4. Copy and Paste (Formula): After entering the formula in the first 'Total Score' cell, the student can copy the cell and paste it down the entire 'Total Score' column. This will automatically calculate the total score for each student based on their exam scores.