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
Get step-by-step solutions from verified subject matter experts
