A user types in a1 and a2 in the cells G1 and G2: If the user selects those two cells and drags the small black box to the four cells below them,then the four cells ________.
A) will display a3, a4, a5, and a6
B) will display b1, b2, c1, and c2
C) will remain blank
D) will display a1, a2, a1, and a2

Question

Quizplus · Accepted Answer

When the user drags the small black box, Excel automatically fills the cells based on the pattern it detects. In this case, it will recognize that the pattern is to increase the number by 1 (a + 1 = b, b + 1 = c). Therefore, the four cells will display a3, a4, a5, and a6.

A User Types in A1 and A2 in the Cells