Bissoy.com
Doctors Medicines MCQs Q&A

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?

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? Correct Answer 0

The correct answer is 0.

Key Points

  • Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.
  • It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. 
  • The current version of excel can handle over 1M rows and 16384 (label 'XFD') columns.
  • Given-
    • Cell A1- 5
    • Cell A2- 6
    • Cell A3- It is the addition of A1+A2= 11
  • Now, if the formula of A3 is dragged to B3, the answer will be zero as there is no input in the B1 cell and B2 cell.
  • The reference for the formula = A1 + A2 will also get changed to =B1 + B2, Since there is nothing to add, the answer will be zero.

Related Questions

There are five cinema halls in a building near the airport – Hall1, Hall 2, Hall 3, Hall 4 and Hall 5. Hall 1 is at the bottom, Hall 2 above it and so on. Five movies – P, Q, R, S, and T are displayed in these given halls. Only one movie is displayed in a particular cinema hall. Each movie is displayed only once. Movie T is displayed at an even numbered hall. Movie Q is displayed at Hall 1. Movie P is displayed at the hall just below T. Movie S is not displayed at an even numbered hall. Which of the following statement is NOT correct about Movie R?
There are five classes class 1, class 2, class 3, class 4 and class 5 in a school. They are one above the other. Class 1 is at the bottom, then class 2 above it and so on. Five videos M1, M2, M3, M4 and M5 are displayed in these given classes. Only one video is displayed in a particular class. Each video is displayed only one time. Video M5 is displayed at an even numbered class. Video M2 is displayed at class 1. Video M1 is displayed at the class just below M5. Video M4 is not displayed at even numbered class. Which of the following statement is not correct?
There are five cinema halls in a building - Hall 1, Hall 2, Hall 3, Hall 4 and Hall 5. They are one above the other. Hall 1 is at the bottom, then Hall 2 above it and so on. Five movies A, B, C, D and E are displayed in these given halls. Only one movie is displayed in a particular cinema hall. Each movie is displayed only one time. Movie E is displayed at a even numbered hall. Movie B is displayed at Hall 1. Movie A is displayed at the hall just below E. Movie D is not displayed at even numbered hall. Which of the following statement is not correct about movie C? 
Five movies Fl, F2, F3, F4 and F5 (not necessarily in the same order) are displayed from Monday to Friday. Only one movie is displayed on one day. Each movie is displayed only one time. Movie FI is displayed on Monday. Two movies are displayed between F4 and F5. F2 is displayed just one day after F5. Which movie is displayed on Wednesday?
Five movies K, L, M, N and P (not necessarily in the same order) are displayed from Monday to Friday. Only one movie is displayed on one day. Each movie is displayed only one time. Movie K is displayed on Monday. Two movies are displayed between N and P. L is displayed just one day after P. How many movies are displayed before M?
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?
A right angled triangle was cut from a rectangular sheet of length 20 cm whose perimeter is same as a square of side 30 cm. If height of the triangle is same as breadth of rectangular sheet and base is 1/4th of length of sheet then, the area of the remaining sheet is what percent of area of the whole sheet?
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?