Question

Read the spreadsheet formula below, then answer the question. cell B5=A5*2 If this formula is filled into cell B6, what will the new formula be? =B5*B5 =B5*2 =A5*B6 =A6*2

Answer 1

The new formula for B6 cell will be B6=A6*2

Answer 2

B6 =A6*2

Explanation:

In Excel, the rectangular box where the rows and column intersect is called cell. The raws are represented by 1, 2, 3, 4, ................, the columns are represented by A, B, C, D,........,The notation of a cell is 'column row',

When we fill a formula in a cell then it can be proceed in below cells.

Here, the given formula,

B5=A5*2

Since, B6 is the below cell of the cell B5,

And, A6 is the below cell of the cell A5,

Thus, the new formula would be,

B6 =A6*2