Home Insert Dow Page Layout Formulas Data Review View Help Tell me what you want to do toen 47 O boy - sro IV. 0.A. E g et $ % 9 .2 K L M N O P Q R Constants for Formulas Noodverse Pet Deposit 2 bedroom newer Apartment Complex model Pet De Recom Rolling Meadows 11/15 R Role Meadows eadows Rolling Meadow 111/2015 Role Meadows Bong Meadows dows Robin Meadow Relo Meadows Being Meadows Hot Meadows Ron Meadows Meadow AND A robust 4 - IN O type here to search 0 Layout References Mailings Review View Help Search Select Goal Seck This worksheet cakes a shaden grade in an Exceless and drops the lowest the homework des Ashdee is trying to figure out what we needed on the final aman 595 in the dass which rounds up to an A) Use goal seek to find the score needed on the final team the 895 as the Final Average Select the IF AND Sheet in cele place an F function which will o ut ther the value in H4OHS as the regured Pet Deposit The value in 14 is to be outputled if the number of bedrooms is 2 or more and number of years since the unit was remodeled is less than the value in 13 other of those logical tests are fase, then the value in H15 is outputted into cell HOGUINT you will need a single IF function using an AND Runction in the local parameter) Use absolute references where needed and copy the function through row 10 India place a lunction which will output either "No Change or "Need to Remoder The value "Need to Remoder should be outputted if the unit is not occupied (see column E) and the years since the last model is GREATER than the value in both must be true to output "Need to Remodel "Need to Remodel is not outputted, then the value "No Change should be outputled Use absolute references where needed and copy the function down through row 57 Select the AND Nest Sheet Enter a function intocel HT that cases the amount the bonus will be for each employee based on the date and pay. There are the possible levels of bonus based on the percentages in J4 Hint you need to use a need to deal with the possible outcomes the employee washed BEFORE not including wedon) the date in then the bonus is the current starymulied by the value in they were hed between the value and 13 inducing the date then ther bonus the Salary e d by the Everyone else will receive a bonus of the salary pled by J4 Use the pro b leeferences and copy the function through row 26 m E ra unction e ll that will output other "Due fora "NA" The function will Output Due to the employee is a manager and their currently say is less than the value in Otherwise 'NA Uutled into the Use the appropriate absolute Terences and copy the function through row 26 Select the OR ested IF sheet Enter in Cell H14 a function which will output other 'Yesor "No" The value "Yes" will be outputted the students SAT score is greater than or equal to the value in 6 and the students GPA is greater than or equal to the value in 17. Otherwise the value 'No' is outputted into the cell Use the appropriate absolute references and copy the function down through row 175 Enterocel 114 a function which will output the value "Yes" or "No' The Yes will be ou puted father the student's SAT score is below the value in C5 or the student's OPAS below the va in C7 Use the appropriate absolute references and copy the function through TOW 175 Goal Seel Nested_IFLogical_Homework Assignment Instructions - Saved to this PC References Mailings Review View Help Search Select the OR Nested IF sheet Enter in coll H14 a function which will output either Yes "No' The value "Yes" will be outpulled if the student SAT score is greater than or equal to the value in 136 and the student's GPA is greater than or equal to the value in B7. Otherwise the value 'No' is outputled to the cel Use the appropriate absolute references and copy the function down through row 175 Enter intocel 114 a function which will output the value "Yes" or "No". The value 'Yes' will be outputted if either the student's SAT score is below the value in C6 or if the student's GPAS below the value in C7 Use the appropriate absolute references and copy the function through TOW 175 Created On: 07/05/2019 Goal Seek Mested IF Logical Homework Assignment Excel 2015 Prosed Step Instructions Points Possible 20 Enter a function into cell K14 that will output 'Early Admission', "Early Rejection'. 'Admit' or "Red" (Hint need the nested IF functions to deal with 4 possible outcomes The value Early Admission will be outputted if the value in cell H14 is equal to Yes The value "Early Rejection will be outputted if the value in cel 114 is "Yes". The value Admit will be outputted if the value in J14 is at least the value in cell 10. Otherwise the value "Reject will be outputted Use the appropriate absolute reverences and copy the function through row 175 Save the workbook. Close the workbook and then exit Excel Submit the workbook to MitLab for grading O e a 9 Home Insert Dow Page Layout Formulas Data Review View Help Tell me what you want to do toen 47 O boy - sro IV. 0.A. E g et $ % 9 .2 K L M N O P Q R Constants for Formulas Noodverse Pet Deposit 2 bedroom newer Apartment Complex model Pet De Recom Rolling Meadows 11/15 R Role Meadows eadows Rolling Meadow 111/2015 Role Meadows Bong Meadows dows Robin Meadow Relo Meadows Being Meadows Hot Meadows Ron Meadows Meadow AND A robust 4 - IN O type here to search 0 Layout References Mailings Review View Help Search Select Goal Seck This worksheet cakes a shaden grade in an Exceless and drops the lowest the homework des Ashdee is trying to figure out what we needed on the final aman 595 in the dass which rounds up to an A) Use goal seek to find the score needed on the final team the 895 as the Final Average Select the IF AND Sheet in cele place an F function which will o ut ther the value in H4OHS as the regured Pet Deposit The value in 14 is to be outputled if the number of bedrooms is 2 or more and number of years since the unit was remodeled is less than the value in 13 other of those logical tests are fase, then the value in H15 is outputted into cell HOGUINT you will need a single IF function using an AND Runction in the local parameter) Use absolute references where needed and copy the function through row 10 India place a lunction which will output either "No Change or "Need to Remoder The value "Need to Remoder should be outputted if the unit is not occupied (see column E) and the years since the last model is GREATER than the value in both must be true to output "Need to Remodel "Need to Remodel is not outputted, then the value "No Change should be outputled Use absolute references where needed and copy the function down through row 57 Select the AND Nest Sheet Enter a function intocel HT that cases the amount the bonus will be for each employee based on the date and pay. There are the possible levels of bonus based on the percentages in J4 Hint you need to use a need to deal with the possible outcomes the employee washed BEFORE not including wedon) the date in then the bonus is the current starymulied by the value in they were hed between the value and 13 inducing the date then ther bonus the Salary e d by the Everyone else will receive a bonus of the salary pled by J4 Use the pro b leeferences and copy the function through row 26 m E ra unction e ll that will output other "Due fora "NA" The function will Output Due to the employee is a manager and their currently say is less than the value in Otherwise 'NA Uutled into the Use the appropriate absolute Terences and copy the function through row 26 Select the OR ested IF sheet Enter in Cell H14 a function which will output other 'Yesor "No" The value "Yes" will be outputted the students SAT score is greater than or equal to the value in 6 and the students GPA is greater than or equal to the value in 17. Otherwise the value 'No' is outputted into the cell Use the appropriate absolute references and copy the function down through row 175 Enterocel 114 a function which will output the value "Yes" or "No' The Yes will be ou puted father the student's SAT score is below the value in C5 or the student's OPAS below the va in C7 Use the appropriate absolute references and copy the function through TOW 175 Goal Seel Nested_IFLogical_Homework Assignment Instructions - Saved to this PC References Mailings Review View Help Search Select the OR Nested IF sheet Enter in coll H14 a function which will output either Yes "No' The value "Yes" will be outpulled if the student SAT score is greater than or equal to the value in 136 and the student's GPA is greater than or equal to the value in B7. Otherwise the value 'No' is outputled to the cel Use the appropriate absolute references and copy the function down through row 175 Enter intocel 114 a function which will output the value "Yes" or "No". The value 'Yes' will be outputted if either the student's SAT score is below the value in C6 or if the student's GPAS below the value in C7 Use the appropriate absolute references and copy the function through TOW 175 Created On: 07/05/2019 Goal Seek Mested IF Logical Homework Assignment Excel 2015 Prosed Step Instructions Points Possible 20 Enter a function into cell K14 that will output 'Early Admission', "Early Rejection'. 'Admit' or "Red" (Hint need the nested IF functions to deal with 4 possible outcomes The value Early Admission will be outputted if the value in cell H14 is equal to Yes The value "Early Rejection will be outputted if the value in cel 114 is "Yes". The value Admit will be outputted if the value in J14 is at least the value in cell 10. Otherwise the value "Reject will be outputted Use the appropriate absolute reverences and copy the function through row 175 Save the workbook. Close the workbook and then exit Excel Submit the workbook to MitLab for grading O e a 9
