Question

A teacher uses the spreadsheet below to determine the average quiz score of each student. The teacher inserts this information into 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?

Answer 1

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.

Answer 2

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