Register
Update the cell reference to cell B6, from a relative reference to a mixed reference by making an absolute reference to row 6. Copy the formula from cell B8 to the range B9:B11 and then copy the formulas
168k views
0 votes
Update the cell reference to cell B6, from a relative reference to a mixed reference by making an absolute reference to row 6. Copy the formula from cell B8 to the range B9:B11 and then copy the formulas

User Uday Ramjiyani
by
4.1k points

1 Answer

3 votes

Answer: I’m your formula, after inserting B6 press F4

Explanation: in order to absolute reference the cell B6 in the formula for cells B8-B11, the cell B6 must have the dollar sign as such $B$6 this is to ensure that when copying the formula across B9-B11, it does not change to B7-B9 respectively

User Mysrt
by
3.9k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

4.5m questions

5.8m answers

Other Questions

Assume you have created a mechanical arm that can hold a pen. The arm can perform the following tasks: • Lower the pen to a piece of paper. • Raise the pen from the paper. • Move the pen 1 inch along a
Drag each connector name to match the connector type shown.
In which part is data processing done?
What is the maximum throughput of a homogeneous pipeline in which four processors each handle one million instructions per second and processing a data item requires 50, 60, 40, and 30 instructions, respectively?
33. (03.03 LC) Technologies are having a negative impact on businesses. (2 points) O True False I need help smh
Link Copied!