Given below are two statements regarding MS Excel. In the light of the above statements, choose the correct answer from the options given below.

Statement I:Cell E9 contains 4 and E10 contains 8; selecting both and dragging the fill handle to E13 gives E11, E12 and E13 as 9, 10 and 11.

Statement II:In the formula =A3*$A$1, the reference to A1 is a relative reference while the reference to A3 is an absolute reference.

ABoth Statement I and Statement II are true

BBoth Statement I and Statement II are false ✓ Correct

CStatement I is true but Statement II is false

DStatement I is false but Statement II is true

Correct answer: (B) Both Statement I and Statement II are false

Explanation

Both statements are false.

Statement 1 is wrong because dragging 4 and 8 extends the pattern to 12, 16 and 20, not 9, 10 and 11.

The fill handle continues the difference between the two selected cells.

Statement 2 is wrong because the dollar signs make A1 an absolute reference and A3 a relative one.

The description reverses which reference is absolute and which is relative.

An absolute reference stays fixed when a formula is copied elsewhere.

Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.