Bissoy.com
Doctors Medicines MCQs Q&A

Consider a formula "= B2 + 4" in cell A1. If cell A1 is copied and pasted into D4, then what will be the formula in D4?

Consider a formula "= B2 + 4" in cell A1. If cell A1 is copied and pasted into D4, then what will be the formula in D4? Correct Answer = E5 + 4

The correct answer is = E5 + 4.

Key Points

  •  If a formula = B2 + 4 is in cell A1 then cell A1 is copied into D4, then the formula in D4 will be = E5 + 4.

Additional Information

  • How to Write Formulas in Excel
    • All Excel formulas start with an equal (=) sign.
    • The answer to the formula is displayed in the cell into which the formula is entered.
    • Cells are referenced in a formula by their column-row identifier.
    • The symbols for addition, subtraction, multiplication, and division are: + - * /
    • We do not have to enter capital letters in the formula, They will be capitalized automatically.

Related Questions

Consider a formula "= $D$3 + $C$5" in cell B4. If cell B4 is copied and pasted into F10, then what will be the formula in cell F10?
Consider a formula "= A3 + B4" in cell A5. If cell A5 is copied and pasted into E9, then what will be the formula in cell E9?
In a class of five students P, Q, R, S and T, only one student is known to have copied in the exam. The disciplinary committee has investigated the situation and recorded the statements from the students as given below. Statement of P: R has copied in the exam. Statement of Q: S has copied in the exam. Statement of R: P did not copy in the exam. Statement of S: Only one of us is telling the truth. Statement of T: R is telling the truth. The investigating team had authentic information that S never lies. Based on the information given above, the person who has copied in the exam is
Suppose the A1 cell of an MS-Excel worksheet contains the formula " =C5+A4". If A1 cell is copied and pasted into D5 cell, then what will be formula in D5?
In an MS-Excel sheet, cell A1 contains 5, A2 contains 6, and cell A3 contains the formula = A1 + A2. The formula in cell A3 is copied into cell B3 by dragging. Which of the following will be the result (output) displayed in cell B3?
She copied the word' - এ বাক্যে copied শব্দটি-
In _______________ copy, the base address of the objects are copied. In _______________ copy, the base address of the objects are not copied.
In . . . . . . . . copy, the base address of the objects are copied. In . . . . . . . . copy, the base address of the objects are not copied.
In the following question, the 1st and the last part of the sentence/passage are numbered 1 and 6. The rest of the sentence/ passage is split into four parts and named P, Q, R and S. These four parts are not given in their proper order. Read the sentence/ passage and find out which of the four combinations is correct. 1.During a research experiment, a marine biologist placed a shark into a large holding tank and then released several small bait fish into the tank. P. Again, the shark quickly attacked.  This time, however, the shark slammed into the fibreglass divider and bounced off. Q. As you would expect, the shark quickly swam around the tank, attacked and ate the smaller fish. R. The marine biologist then inserted a strong piece of clear fibreglass into the tank, creating two separate partitions.She then put the shark on one side of the fibreglass and a new set of bait fish on the other. S. Eventually, about an hour into the experiment, the shark gave up. 6. The marine biologist then removed the fibreglass divider, but the shark didn’t attack.  The shark was trained to believe a barrier existed.
Which type of cell reference in MS-Excel contains a formula which does not change when the formula is copied?