Cells B1, C1, and D1 contain the values Seat1Row1, Seat1Row2, and Seat1Row3. If cells B1, C1, and D1 were selected, and autofill
used to fill E1, F1, and G1, what would be the autofilled values?
2 answers:
Answer:
The autofilled values would be Seat1Row4, Seat1Row5, Seat1Row6
Step-by-step explanation:
Given
B1 = Seat1Row1
C1 = Seat1Row2
D1 = Seat1Row3
Required
Values of E1, F1, G1 if autofilled
Autofill in Microsoft Office Excel (Ms Excel).is used to automatically fill cells base on suggestion from previous cells.
The autofill feature of Ms Excel works data types such as numbers and alphanumeric among others.
But for autofill to work on alphanumeric in Ms Excel, only the numeric part will be altered.
In this case, the series of text in B1, C1 and D1 are Seat1Row1, Seat1Row2, Seat1Row3
"Seat1Row" will be regarded as string while 1,2,3 will be incremented and the resulting alphanumeric values will be saved in their respective cells.
Hence,
Cell E1 will be filled with Seat1Row4
F1 will be filled with Seat1Row5
G1 will be filled with Seat1Row6
See attachment
You might be interested in