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
Answer:
The mean of 25 students is 17.6
Step-by-step explanation:
The formula of the mean (average) is mean (average) = , where S is the sum of the data, and N is the number of the data
∵ The average marks of the first 10 students are 17
- That means the mean is 17 and the number of students is 10
∴ Average = 17
∴ N = 10
∵ Average =
- Substitute average by 17 and N by 10
∴ 17 =
- Multiply both sides by 10
∴ 170 = S
∴ The sum of the marks of the first 10 students is 170
∵ The average of the next 15 students is 18
∴ Average = 18
∴ N = 15
- Substitute average by 18 and N by 15
∴ 18 =
- Multiply both sides by 15
∴ 270 = S
∴ The sum of the marks of the next 15 students is 270
Now to find the mean of 25 students and the two sums and divide the answer by 25
∵ S = 170 + 270
∴ S = 440
∵ N = 25
∴ Mean =
∴ Mean = 17.6
The mean of 25 students is 17.6