Problemas
The __ function is used to average a range of cells based on multiple conditions. Both the range of cells and the conditions must be specified. SUMIFS HLOOKUP VLOOKUP COUNTIFS AVERAGEIFS
Roztwór
Angelica
veterano · Tutor durante 10 años
4.1
(444 Votos)
Respuesta
The correct answer is 'AVERAGEIFS'.
Explicación
## Step 1The problem is asking us to identify the function in Microsoft Excel that is used to average a range of cells based on multiple conditions. The options provided are SUMIFS, HLOOKUP, VLOOKUP, COUNTIFS, and AVERAGEIFS.## Step 2Let's analyze each function:### SUMIFSThis function is used to add the values in a range of cells, based on one or more conditions.### HLOOKUPThis function is used to search for a value in the first row of a table, and return a value in the same column from a specified row index.### VLOOKUPThis function is used to search for a value in the first column of a table, and return a value in the same row from a specified column index.### COUNTIFSThis function is used to count the number of cells that meet multiple conditions.### AVERAGEIFSThis function is used to average the values in a range of cells, based on multiple conditions.## Step 3From the above analysis, it is clear that the function that fits the description given in the problem is AVERAGEIFS. This function is used to average the values in a range of cells, based on multiple conditions.