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:
99.27% probability that among 6 randomly selected graduates, at least one finds a job in his or her chosen field within a year of graduating.
Step-by-step explanation:
For each student, there are only two possible outcomes. Either they find a job in their chosen field within one year of graduating, or they do not. The probability of a student finding a job in their chosen field within one year of graduating is independent of other students. So we use the binomial probability distribution to solve this question.
Binomial probability distribution
The binomial probability is the probability of exactly x successes on n repeated trials, and X can only have two outcomes.
In which is the number of different combinations of x objects from a set of n elements, given by the following formula.
And p is the probability of X happening.
56% of the school's graduates find a job in their chosen field within a year after graduation.
This means that
Find the probability that among 6 randomly selected graduates, at least one finds a job in his or her chosen field within a year of graduating.
This is when n = 6.
Either none find a job, or at least one does. The sum of the probabilities of these events is decimal 1. So
In which
99.27% probability that among 6 randomly selected graduates, at least one finds a job in his or her chosen field within a year of graduating.