Question: The following AVERAGEIFS function was entered into a cell on the Summary worksheet in an Excel workbook: =AVERAGEIFS(Detail!B5:B15,Detail!G5:G15,Summary!A6,Detail!J5:J15,>10/28/2021) Complete the statement below that describes how

The following AVERAGEIFS function was entered into a cell on the Summary worksheet in an Excel workbook:

=AVERAGEIFS(Detail!B5:B15,Detail!G5:G15,Summary!A6,Detail!J5:J15,">10/28/2021")

Complete the statement below that describes how this function will produce an output.

The function will calculate the arithmetic mean using values in the cell range ________ on the ________worksheet where the values in the cell range _________on the _______ worksheet are equal to the entry in cell ______ on the _______ worksheet and where the dates in the cell range _________ on the ________ worksheet come after 10/28/2021.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!