Question

Using a spreadsheet program of your choice, create a worksheet to display the following data. Serial number, Name of student, Physics, Chemistry, Mathematics, Computer Science, Total Score. 1. James, 56, 78, 60, 91, 285. 2. Susan, 75, 54, 77, 82, 288. 3. Sally, 45, 43, 55, 66, 209. 4. Tyson, 80, 88, 74, 70, 312. 5. Sam, 78, 65, 56, 58, 257. 6. June, 67, 48, 55, 59, 229. 7. Timothy, 72, 67, 78, 88, 305. 8. Jason, 49, 50, 56, 60, 215. 9. Sarah, 50, 67, 77, 60, 254. 10. Peter, 76, 89, 93, 70, 328. 11. Janet, 91, 80, 75, 79, 325. 12. Jennifer, 48, 59, 66, 70, 243. 13. Thompson, 87, 95, 98, 80, 360. 14. Laura, 95, 85, 78, 76, 334. 15. Rachael, 84, 73, 88, 77, 322. 16. Emanuel, 84, 57, 68, 71, 280. 17. Justin, 54, 65, 71, 60, 250. What is the total score of the student with serial number 10?

1) 285
2) 288
3) 328
4) 325

Answer 1

Peter, the student with serial number 10, has a total score of 328, which is the sum of his individual scores in Physics, Chemistry, Mathematics, and Computer Science.

Step-by-step explanation:

The total score for the student with serial number 10 is found by looking at the provided data in the table. The student with serial number 10 is Peter. According to the data given, the subjects and scores are Physics (76), Chemistry (89), Mathematics (93), Computer Science (70), which gives us a Total Score of 328 when added together (76+89+93+70=328).

The correct answer is: 3) 328. This total score represents Peter's cumulative performance across the four given subjects. The process of summarization and addition is a key concept in data management and analysis in subjects like Mathematics and is commonly utilized within spreadsheet programs.