Computers and Technology, 09.03.2021 01:20 bayleeharris8p78txa

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? =IF(E3>E8, “Exceeded”)
=IF(E3>$E$8, "Exceeded")
=IF(AVERAGE(E3:E6)>E8, “Exceeded”)
=IF(AVERAGE(E3:E6)>$E$8, “Exceeded”)

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 23:30, lexirandall19

Define a function printfeetinchshort, with int parameters numfeet and numinches, that prints using ' and " shorthand. ex: printfeetinchshort(5, 8) prints: 5' 8"

Answers: 1

continue

Computers and Technology, 23.06.2019 07:30, Braxtonw875

What part of the interface displays the external references contained in a selected cell? the status bar the review tab the scroll bar the formula bar

Answers: 1

continue

Computers and Technology, 23.06.2019 14:30, qveenvslayin

The basic work area of the computer is it screen that you when you first fire up your computer

Answers: 1

continue

Computers and Technology, 24.06.2019 00:40, ndurairajownkpq

What social factors affect your health

Answers: 3

continue

You know the right answer?

A teacher uses the spreadsheet below to determine the average quiz score of each student. The teache...