Question

Given the highlighted cells in Microsoft Excel (c4 5, d4 4, e3 4, f2 4, b3 5, c9 5, d7 5, e4 5, f2 5, b4 6, c6 6, d5 6, e6 6, f3 6, b6 7, c5 7, d4 7, e5 7, f7 7), write formulas with absolute and relative cell references as instructed.

Answer 1

In Microsoft Excel, you can use formulas with absolute and relative cell references to perform calculations based on the values in different cells.

Step-by-step explanation:

In Microsoft Excel, you can write formulas with absolute and relative cell references to perform calculations based on the values in different cells.

An absolute cell reference remains constant regardless of where the formula is copied or applied. It is indicated by a dollar sign ($). For example, you can use the formula =A$1+B$1 to add the values in cells A1 and B1, and the reference to A1 and B1 will not change when you copy the formula to other cells.

A relative cell reference, on the other hand, changes based on the position of the formula. For example, if you use the formula =A1+B1 to add the values in cells A1 and B1, and copy the formula to cell C1, the formula will automatically adjust to =C1+D1 to add the values in cells C1 and D1.