A cell contains the formula =B$6*2. This formula is copy/pasted to a cell 1 row
ID: 3841772 • Letter: A
Question
A cell contains the formula =B$6*2. This formula is copy/pasted to a cell 1 row above and 1 column to the right of the original cell. What will be the pasted result?
=D$5*2
=C$5*2
=C$6*2
=D$6*2
A cell contains the formula =A7*2. This formula is copy/pasted to a cell 1 row above and 1 column to the right of the original cell. What will be the pasted result?
a.
=D4*2
b.
=B4*2
c.
=B6*2
A cell contains the formula =B$6*2. This formula is copy/pasted to a cell 1 row above and 1 column to the right of the original cell. What will be the pasted result?
=D$5*2
=C$5*2
=C$6*2
=D$6*2
d.
=D6*2
e.
=C5*2
Explanation / Answer
1. Option C ( This formula is copy/pasted to a cell 1 row above and 1 column to the right of the original cell. Got the result as)
=C$6*2
2. Option C ( This formula is copy/pasted to a cell 1 row above and 1 column to the right of the original cell. Got the result as)
=B6*2
3. Option C ( This formula is copy/pasted to a cell 1 row above and 1 column to the right of the original cell. Got the result as)
=C$6*2
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.