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
