Computers and Technology, 02.04.2020 03:54 andrewmena05

2. Student organizations sometimes require transportation for off-campus activities, and school policy requires students to be over 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.

Answers: 3

Show answers

Answers

The required formula which determines the age of the student and displays a yes or no depending on whether the condition is true or not is =IF(C2>=23, 'Yes', 'No')

The IF function in excel, takes in three arguments or parameters ;

The first being the condition to be evaluated The second being the statement that should be executed if the condition is True If condition is not true, then the third statement is executed.

The first parameter, checks if the age of students is 23 years or greater.

The second parameter displays the string 'Yes' if the condition is met

The third parameter displays the string 'No' if the condition isn't.

To extend the formula to other range of cells in the sheet, drag the fill handle and it will use relative reference to apply the formula to corresponding cells on the Sheet.

Therefore, the appropriate excel function would be =IF(C2>=23, 'Yes', 'No')

Learn more : link

2. Student organizations sometimes require transportation for off-campus activities, and school poli

Answer from: nancye2008

=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

Answer from: Quest

Why can you not find anything better to do i mean i guess talking to strangers is pretty entertaining

Answer from: Quest

a social news website is an internet website that features user-posted stories. such stories are ranked based on popularity, as voted on by other users of the site or by website administrators. users typically comment online on the news posts and these comments may also be ranked in popularity. since their emergence with the birth of web 2.0, social news sites have been used to link many types of information, including news, humor, support, and discussion. all such websites allow the users to submit content and each site differs in how the content is moderated. on the slashdot and fark websites, administrators decide which articles are selected for the front page. on reddit and digg, the articles that get the most votes from the community of users will make it to the front page. many social news websites also feature an online comment system, where users discuss the issues raised in an article. some of these sites have also applied their voting system to the comments, so that the most popular comments are displayed first. some social news websites also have a social networking function, in that users can set up a user profile and follow other users' online activity on the website.

Another question on Computers and Technology

Computers and Technology, 22.06.2019 19:30

When creating a presentation in libre office impress, where does the editing of slides take place? a. the slides panel b. the center panel c. the tasks panel, under the masters pages tab d. the tasks panel, under the layouts tab

Answers: 3

Answer

Computers and Technology, 22.06.2019 19:40

Solve the following javafx application: write a javafx application that analyzes a word. the user would type the word in a text field, and the application provides three buttons for the following: - one button, when clicked, displays the length of the word.- another button, when clicked, displays the number of vowels in the word.- another button, when clicked, displays the number of uppercase letters in the word(use the gridpane or hbox and vbox to organize the gui controls).

Answers: 1

Answer

Computers and Technology, 23.06.2019 01:00

Write the command that can be used to answer the following questions. (hint: try each out on the system to check your results.) a. find all files on the system that have the word test" as part of their filename. b. search the path variable for the pathname to the awk command. c. find all files in the /usr directory and subdirectories that are larger than 50 kilobytes in size. d. find all files in the /usr directory and subdirectories that are less than 70 kilobytes in size. e. find all files in the / directory and subdirectories that are symbolic links. f. find all files in the /var directory and subdirectories that were accessed less than 60 minutes ago. g. find all files in the /var directory and subdirectories that were accessed less than six days ago. h. find all files in the /home directory and subdirectories that are empty. i. find all files in the /etc directory and subdirectories that are owned by the group bin."

Answers: 1

Answer

Computers and Technology, 23.06.2019 02:50

There’s only one game mode that stars with the letter ‘e’ in cs: go. which of the options below is it?

Answers: 1

Answer

You know the right answer?

2. Student organizations sometimes require transportation for off-campus activities, and school poli...

Questions