Question

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?

Answer 1

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

Answer 2

Answer:

Step-by-step explanation: