Cells B1, C1, and D1 contain the values Seat1Row1, Seat2Row1, and Seat3Row1. If cells B1, C1, and D1 were selected, and autofill used to fill E1, F1, and G1, what would be the auto-filled values?


Seat 1Row1, Seat2Row2, Seat3Row2


Seat1Row2, Seat2Row2, Seat3Row2


Seat 2Row2, Seat3Row3, Seat4Row4


Seat 2Row2, Seat3Row2, Seat4Row2

Respuesta :

The autofilled values are; Cell E1 will be filled with Seat1Row4; F1 will be filled with Seat1Row5; G1 will be filled with Seat1Row6

How to use Excel to Autofill?

We are given;

B1 = Seat1Row1

C1 = Seat1Row2

D1 = Seat1Row3

We want to find the values of E1, F1, G1 if we carry out autofill.

Autofill in Microsoft Excel is used to automatically fill cells based on suggestion from previous cells.

The autofill feature of Microsoft Excel works data types such as numbers and alphanumeric.

Thus, for autofill to work on alphanumeric in Microsoft 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.

Thus;

Cell E1 will be filled with Seat1Row4

F1 will be filled with Seat1Row5

G1 will be filled with Seat1Row6

Read more about Excel Autofill at; https://brainly.com/question/1178135

#SPJ1

Ver imagen AFOKE88