Which references are updated when you copy the formula = $E6/15-MAX (H$1:J4) ?

Answer Choices:

Column E

Column H

Column J

Row 6

Row 1

Row 4

Value 15

The answer is "Column E and Row 6".

Explanation:

In the given question some information is missing, that is the values so, the explanation to this question can be defined as follows:

In the given formula = "=$E6/15-MAX (H$1:J4) ", First it divides the column "E6" value from 15 after divides it subtract the value from the max method calculated value. In the max method, it selects column H to J, then it calculates the max values from the selected columns. After calculating the value, it will store, it into the Column E in 6 rows.