Question

7. Copy the formula from cell I6 to the range I7:I11 and then edit the formula in cell I7 to return the value in the 3rd column, the formula in cell I8 to return the value in the 4th column, the formula in cell I9 to return the value in the 5th column, the formula in cell I10 to return the value in the 6th column, and the formula in cell I11 to return the value in the 7th column.

Answer 1

The formula is an illustration of Excel formulas, and Excel formulas are used to operate on values in a cell or a range of cells

How to write the formula?

From the complete question, the formula in cell I6 is a VLOOKUP formula, and the VLOOKUP formula is:

VLOOKUP(I5,A17:G20,9,1)

When copied from cell I6 through cell I11, the corresponding formulas in the cells would be:

I7 = VLOOKUP(I6,A17:G20,9,1)

I8 = VLOOKUP(I7,A17:G20,9,1)

I9 = VLOOKUP(I8,A17:G20,9,1)

I10 = VLOOKUP(I9,A17:G20,9,1)

I11 = VLOOKUP(I10,A17:G20,9,1)

Read more about Excel formulas at:

https://brainly.com/question/17566733