Question

Jan was entered into the cell A3 and fill handle was dragged up to cell A20. What value would the
cell A18 contain ?
i. Apr
ii. May
ii. Jul
iv. Aug
​

Answer 1

Answer:

The correct answer to this question is:

option (i) - Apr

Explanation:

Given,

Jan was entered into cell A3.

If we use the fill handle and dragged up to cell A20, we get Jun in A20 cell

In question, they asked for A18 cell

In the A18 cell, this gets filled by Apr

So, the answer is "Apr"

Another approach without using an excel worksheet, using simple logic we can solve

If A3 has "Jan" month after 12 rows, that is A15 is again "Jan"

If we need A18 then subtract "12 from 18"

A(18 - 12) = A6, which is the third row(month) from Jan

that is Apr

Hence, the cell A18 contains Apr

Click here for more about excel:

https://brainly.in/question/3272828

Click here for more about fill handle:

https://brainly.in/question/27090701