A teacher uses the spreadsheet below to determine the average quiz score of each student. The teacher inserts this information i

Question

4 years ago

11

A teacher uses the spreadsheet below to determine the average quiz score of each student. The teacher inserts this information i

nto column E. In column F, which function can be cut and pasted into different cells to tell the teacher if each student exceeded the satisfactory average?

Computers and Technology

2 answers:

Vinvika [58] · Answer 1 · 2021-11-14T11:14:32+03:00

Vinvika [58]4 years ago

6 0

need help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Troyanec [42] · Answer 2 · 2021-11-14T12:52:07+03:00

Answer: The correct answer is the IF Function.

Explanation: The IF function can perform a logical test on data in the spreadsheet and then return one value for a TRUE result, and another for a FALSE result. For example, the teacher can set the formula to print Pass or Fail in column F, based on the data in column E.