Given below are two statements regarding MS-Excel: Statement I: Cell E9…
2023
Given below are two statements regarding MS-Excel:
Statement I: Cell E9 contains the value 4 and E10 contains the value 8. You select both cells and drag the fill handle down to E13. The contents of cells E11, E12 and E13 will be 9, 10 and 11, respectively.
Statement II: The formula =A3*$A$1 has the reference to cell A1 set as a relative reference while the reference to cell A3 is an absolute reference.
In the light of the above statements, choose the correct answer from the options given below:
Answer: B. Both Statement I and Statement II are false — ConceptWhen two starting values are selected, Excel can extend a linear series by using the constant difference between them. In a cell reference, a dollar…
- A.
Both Statement I and Statement II are true
- B.
Both Statement I and Statement II are false
- C.
Statement I is true but Statement II is false
- D.
Statement I is false but Statement II is true
Show answer & explanation
Correct answer: B
Concept
When two starting values are selected, Excel can extend a linear series by using the constant difference between them. In a cell reference, a dollar sign locks the part immediately following it; therefore $A$1 locks both column A and row 1, while A3 is fully relative.
Application
The difference between the selected values is 8 - 4 = 4.
Continuing that arithmetic series gives E11 = 8 + 4 = 12, E12 = 12 + 4 = 16, and E13 = 16 + 4 = 20. Therefore the 9, 10, 11 claim does not describe the fill result.
In =A3*$A$1, A3 has no dollar sign and is relative. The reference $A$1 has dollar signs before both the column and row, so it is absolute. Therefore the stated reference labels are reversed.
Cross-check and contrast
The pair (true, true) does not match either the +4 fill sequence or the dollar-sign rule.
The pair (true, false) matches the reference-rule evaluation but not the fill-series evaluation.
The pair (false, true) matches the fill-series evaluation but not the reference-rule evaluation.
Both statements are false, so the result is the pair (false, false).