Question

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?

Answer 1

Correct Answer - Option 1 : 0

The correct answer is 0.

• 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. Since there is nothing to add, the answer will be zero.