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 results would be Seat1Row4, Seat1Row5, Seat1Row6
Step-by-step explanation:
Given
B1 = Seat1Row1
C1 = Seat1Row2
D1 = Seat1Row3
Required
Values for E1, F1, G1 if autofill is applied
Autofilling in Microsoft Excel allows automatic cell filling based on prior entries.
The autofill function adjusts various data types, including both numbers and alphanumeric characters.
However, when utilizing autofill for alphanumeric data in Excel, only the numeric portion is altered.
In this particular instance, the sequence of entries in B1, C1, and D1 includes Seat1Row1, Seat1Row2, and Seat1Row3
"Seat1Row" will be treated as a string, while the numbers 1, 2, and 3 will be incremented, allowing their respective alphanumeric outcomes to populate the given cells.
As a result,
The E1 cell will automatically become Seat1Row4
The cell F1 will be updated to Seat1Row5
The cell G1 will be updated to Seat1Row6
See attachment
You might be interested in