Register
Anu copied the formula =$A$3*$B$1 from cell A1 to B5. How will the formula look like in cell B5? (a) =$B$7*$C$5 (b) =$C$7*$B$5 (c) =$C$5*$B$7 (d) =$A$3*$B$1
234k views
5 votes
Anu copied the formula =$A$3*$B$1 from cell A1 to B5. How will the formula look like in

cell B5?
(a) =$B$7*$C$5 (b) =$C$7*$B$5 (c) =$C$5*$B$7 (d) =$A$3*$B$1

User Aaron Swan
by
7.5k points

1 Answer

6 votes

Answer:

=$A$3*$B$1

Step-by-step explanation:

Since cells involved in the formula are absolute row and column because of the $ sign on the row letter and column number for both, this formula will not changed when it is copied to any new location on the worksheet

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

8.8m questions

11.4m answers

Other Questions

A piston-cylinder device fitted with stops in the cylinder walls contains 2.1 kg of water initially at 150 kPa and 30 °C. Heat is transferred to the system until the final temperature reaches 250 °C. The
A car has an initial speed of 10 m/s. It then undergoes a constant acceleration of 0.05 m/s^2 over a distance of 5 km. Determine: a) The car final speed. b) The time needed to travel the 5 km.
Where are all the controls on most circuits?
A 200 g projectile is fired with a velocity of 900 m/s toward the center of a 15 kg wooden block which rests on a rough surface. If the projectile penetrates and emerges from the back at a velocity of
The pressure at any point in a static fluid depends only on the Select one a)- depth, surface pressure, and specific weight. b)- specific weight. c)- surface pressure and depth. d)- depth and container
Link Copied!