subject

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”)

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 06:00
Write a function that draws a pool ball. this function should take as parameters, the color, the number that should go on the pool ball, and the location of the center of the pool ball. the radius of the pool balls should be pool_ball_radius, and the font of the number should be pool_ball_font. the text of the pool ball font should be white. drawpoolball(color.orange, 5, 100, 100); drawpoolball(color.green, 6, 50, 200); drawpoolball(color.red, 3, 150, 350); drawpoolball(color.blue, 2, 250, 140); to center the numbers on the pool ball, you should use the getwidth() and getheight() methods. you are allowed to call these methods on your text object, such as txt.
Answers: 3
question
Computers and Technology, 22.06.2019 22:40
In this lab, you complete a python program that calculates an employee's annual bonus. input is an employee's first name, last name, salary, and numeric performance rating. if the rating is 1, 2, or 3, the bonus rate used is .25, .15, or .1 respectively. if the rating is 4 or higher, the rate is 0. the employee bonus is calculated by multiplying the bonus rate by the annual salary.
Answers: 1
question
Computers and Technology, 23.06.2019 21:00
Will this setup result in what kathy wants to print?
Answers: 2
question
Computers and Technology, 23.06.2019 23:00
Computer programming is one type of what career
Answers: 1
You know the right answer?
A teacher uses the spreadsheet below to determine the average quiz score of each student. The teache...
Questions
question
English, 27.10.2020 03:30
question
Mathematics, 27.10.2020 03:30
question
Mathematics, 27.10.2020 03:30
question
Mathematics, 27.10.2020 03:30