Question

An employer uses the spreadsheet below to determine the average hourly salary of her four employees. She begins by determining the hourly salary of each person and displaying that in column D. Which formula can she then use to determine the average hourly salary?

=average(D2:D5)

=average(B2:B5)

=average(C2:C5)

=average(B5:D5)

A. =average (D2:D5)

Answer 1

A

Step-by-step explanation:

Answer 2

The answer is "=average(D2:D5)"

Step-by-step explanation:

In Excel, the AVERAGE function is used to measures the average number, in the arithmetic average.This method is used as the group of numbers, that determines by using the AVERAGE function. This feature is an AVERAGE, which is used to ignores the logical data, empty columns, or text cell. It is up to 255 specific arguments, that could be handled by AVERAGE, including numbers, numerical values, sets, arrays, or constant.