Question

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

Answer 1

The answer is "Column E and Row 6".

Step-by-step 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.