read the scenario below, and then answer the following questions. the scholarship committee at a college has…

read the scenario below, and then answer the following questions. the scholarship committee at a college has created a spreadsheet to compile information received from scholarship applicants. to be eligible for a scholarship from abc foundation, applicants must have a gpa of 3.5 or above, and an ap english score of 4 or higher. after the committee has a list of applicants meeting the criteria, the committee will e - mail applicants to let them know they are semifinalists and will need to write a five - page essay explaining why a college degree will help them reach their career goals. which spreadsheet feature could the scholarship committee use to locate applicants who meet the criteria? based on selected five applicants from abc, the spreadsheet is sent to the colleges financial department so that checks can be mailed to the winners. which feature should the committee use to prevent any further changes to the spreadsheet?

read the scenario below, and then answer the following questions. the scholarship committee at a college has created a spreadsheet to compile information received from scholarship applicants. to be eligible for a scholarship from abc foundation, applicants must have a gpa of 3.5 or above, and an ap english score of 4 or higher. after the committee has a list of applicants meeting the criteria, the committee will e - mail applicants to let them know they are semifinalists and will need to write a five - page essay explaining why a college degree will help them reach their career goals. which spreadsheet feature could the scholarship committee use to locate applicants who meet the criteria? based on selected five applicants from abc, the spreadsheet is sent to the colleges financial department so that checks can be mailed to the winners. which feature should the committee use to prevent any further changes to the spreadsheet?

Answer

Brief Explanations:

Lookup Tables are used to find specific values in a dataset. Conditional formatting is for visually highlighting data based on conditions. Nested IF statements are for making multiple - level logical decisions. Cell protection is used to prevent changes to cells. To locate applicants meeting criteria, a nested IF statement can be used to check the GPA and AP English score conditions. To prevent further changes to the spreadsheet, cell protection should be used.

Answer:

Which spreadsheet feature could the scholarship committee use to locate applicants who meet the criteria? - nested IF statement Which feature should the committee use to prevent any further changes to the spreadsheet? - cell protection