Question

Task Instructions
×
In cell C6, enter a formula that multiplies the value in C5
for Atlanta city by the value in cell B6. Use a mixed
reference for cell B6 so that only column B does not
change when copied. Use relative references for all other
cell references.

Answer 1

The Excel formula to enter in cell C6 is = (C5 * $B6)

How to determine the Excel function and formula?

From the question, we have the following parameters:

• Atlanta City: C5
• Second cell: B6
• The cell to enter the formula is cell C6

From the question, we understand that the cell B6 should be referenced using a mixed style of referencing so that only column B does not change when copied

This means that

BG = $B6

Using the product formula, we have:

Product = (C5 * B6)

When referenced, we have

Product = (C5 * $B6)

Rewrite as

C6 = (C5 * $B6)

When the above formula is entered in the cell C6, the formula becomes = (C5 * $B6)

So, the formula to enter in cell C6 is = (C5 * $B6)

Hence, the required formula to enter in cell C6 is = (C5 * $B6)

Read more about Excel formulas at:

brainly.com/question/14820723

#SPJ1