Computers and Technology, 27.10.2019 16:43 MileenaKitana

Ateacher 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

Answers

Answer from: joannegrace4898

=IF(E3>$E$8, "Exceeded")

=IF(AVERAGE(E3:E6)>$E$8, “Exceeded”)

Explanation:

Seeing the spreadsheet would have helped understand some curiosity about the row numbers present in the answers, and definitely zoom in the right answer. For example we don't know for sure what's present in cell E8, and how it's calculated.

But without seeing the spreadsheet, I can only come to 2 answers, depending on the layout of the spreadsheet.

We know the formula wll be copied into many cells to see if a certain value is greater than the one in E8. Since the formula will be copied, we want to keep the same reference point for each student. When you copy a formula, Excel will adapt the cell addresses to the new context, UNLESS you block them... by using the $ sign. So, the answer definitely has to have $E$8.

We don't know for sure if the teacher enters only one score per student or a group of them.

If the teacher enters only one score per student, then =IF(E3>$E$8, "Exceeded") would be the answer.

If the teacher enters 2 to 4 scores for each student, then =IF(AVERAGE(E3:E6)>$E$8, “Exceeded”) would be the answer.

Answer from: kmontanab00

B: =IF(E3>$E$8, "Exceeded")

i just took the test on Edg.

Answer from: Quest

how does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the state

Answer from: Quest

Discord1.on desktop, download the discord app and open it.2.click connections in the menu on the left.3.click spotify.4.a web page will open to connect. if you're not already logged into spotify on the device, you're directed to log in or sign up first.5.click okay to confirm.

Another question on Computers and Technology

Computers and Technology, 22.06.2019 13:00

Why the bear has a slunky tail determine the meaning of the word slunk in the story

Answers: 1

Answer

Computers and Technology, 22.06.2019 15:30

What is a costume plot? why is it important to a film or theater production?

Answers: 2

Answer

Computers and Technology, 22.06.2019 22:00

Perform the following tasks: a. create a class named testclass that holds a single private integer field and a public constructor. the only statement in the constructor is one that displays the message “constructing”. write a main()function that instantiates one object of the testclass. save the file as testclass.cpp in the chapter 08 folder. run the program and observe the results. b. write another main()function that instantiates an array of 10 testclass objects. save the file as test class array.c . run this program and observe the results.

Answers: 1

Answer

Computers and Technology, 22.06.2019 23:30

Select all that apply. which of the following are proofreading options included in microsoft word? spell check find replace grammar check formatting check

Answers: 1

Answer

You know the right answer?

Ateacher uses the spreadsheet below to determine the average quiz score of each student. the teacher...

Questions