In order for a sort to work, which of the following is required?
1 answer:
You might be interested in
Answer:
Detailed ERD Diagram is given in the attachment
Answer:
=IF(B2>=23,"Yes","No")
Explanation:
Given
Name = Kay Colbert
The Name column can't be used to determine the eligibility of a student to the transport.
What is needed is the corresponding age column of Kay's age.
Assume that the age column is B2 and the result column is C2 (See Attachment)
Enter the following in C2
=IF(B2>=23,"Yes","No")
This will return "Yes" without the quotes in cell C2 if B2 is greater than 23
Else, it'll return "No" without the quotes.
To drag the formula to other column, follow the instructions below
Select cell C2.
Rest your cursor in the lower-right corner so that it turns into a plus sign (+), like this:
Drag the fill handle downwards
