Bissoy.com
Doctors Medicines MCQs Q&A

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?

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? Correct Answer = E7 + F8

The correct answer is = E7 + F8.

Key Points

  • By Assuming a formula "= A3 + B4" in cell A5.
    • If cell A5 is copied and pasted into E9, then the formula in cell E9 = E7 + F8.

Additional Information

  • All the formulas in MS Excel started with an equal sign.
  • After an equal sign, one can add formula or function.
    • For example, add values in cella A1 through A4, then type the whole equation after the equal sign.
      • = A1 + A2 + A3 + A4.

Related Questions

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
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 "= B2 + 4" in cell A1. If cell A1 is copied and pasted into D4, then what will be the formula in D4?
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?