2. Student organizations sometimes require transportation for off-campus activities, and school policy requires students to be o
ver 23 years old to serve as transport. Lael wants to determine how many of the active students will be eligible to transport other group members. In cell J2, enter a formula using the IF function as follows to determine if Kay Colbert can serve as authorized transport: a. The function should use a reference to the Age column to determine if the student's age is greater than 23, and should return the text Yes if true and No if false. b. Fill the formula into the range J3:J31, if necessary.
1 answer:
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
You might be interested in
Answer:
Here is the function:
#include <iostream> //to use input output functions
#include <vector> // to use vector (sequence containers)
#include <algorithm> //use for sequence operations
#include<iterator> //to move through the elements of sequence or vector
using namespace std; //to identify objects cin cout
void DistinctNumbers(std::vector<int> values) { /*function that takes an STL vector of int values and determines if all the numbers are different from each other */
sort(values.begin(), values.end()); //sorts the vector elements from start to end
bool isDistinct = std::adjacent_find(values.begin(), values.end()) == values.end(); //checks for occurrence of two consecutive elements in vector
if(isDistinct==true) // if all numbers are different from each other
{cout<<"Numbers are distinct";}
else //if numbers are duplicate or same
{cout<<"Numbers are not distinct";} }
int main(){ //start of main function
std::vector<int> v = {1,2,3,4,5}; // vector of int values
DistinctNumbers(v); } //function call to passing the vector v to check if its elements are distinct
Explanation:
The program that takes an STL vector of int values and the function DistinctNumbers determines if all the numbers are different from each other. It first sorts the contents of the vector in ascending order using sort() method. Then it used the method adjacent_find() to searches the range means from the start to the end of the vector elements, for first occurrence of two consecutive elements that match, and returns an iterator to the first of these two elements, or last if no such pair is found. The result is assigned to a bool type variable isDistinct. It then checks if all the numbers are different and no two adjacent numbers are same. If all the numbers are distinct then this bool variable evaluates to true otherwise false. If the value of isDistinct is true then the message :Numbers are distinct is displayed on screen otherwise message: Numbers are not distinct is displayed in output screen.
