Question

Copy the formula in cell M7 to the range M8:M15, and edit the copied formulas to return the value from the column indicated by the label in column L

Answer 1

The formula to enter, in the cell range M8:15 is =VLOOKUP($L$6,$A$6:$J$13,2,FALSE)

What are Excel formulas?

Excel formulas are formulas that are used together with functions to perform arithmetic and logical operations

How to copy the formula?

From the complete question, the formula in cell M7 is:

=VLOOKUP($M$6,$A$6:$J$13,2,FALSE)

The above formula uses absolute style of referencing.

This means that when the formulas are copied, the formulas would remain unchanged.

So, the formulas in the range M8 : M15 are:

=VLOOKUP($M$6,$A$6:$J$13,2,FALSE)

From the question, we understand that the column labels M are to be changed to label L.

So, the updated formula is:

=VLOOKUP($L$6,$A$6:$J$13,2,FALSE)

Hence, the formula to enter, in the cell range M8:15 is =VLOOKUP($L$6,$A$6:$J$13,2,FALSE)

Read more about Excel formula at:

https://brainly.com/question/14299634

#SPJ1

Complete question

Copy the formula in cell M7  is =VLOOKUP($M$6,$A$6:$J$13,2,FALSE) to the range M8:M15, and edit the copied formulas to return the value from the column indicated by the label in column L