A17 example in F 0 Q s B C D E G H J KL M N P R 1 The Read-Me is to be revised and completed PLZ do NOT move any cell, and do NOT insert any row/column! 2 Would -1 for each of the violations to this rule. 3 0. *** Save this spreadsheet onto your PC BEFORE any work is attempted, adding your Lname at the beginning of the filename. Then open the saved copy and work on it. 4 Without the corrrect file name and wlo saving it onto your PC, would get -1. 5 1. Salary lookup and SUMIFICOUNTIF: Given the names and salaries of a small company, a VLOOKUP formula is to be created so that when the last name of 6 (#1 - 5 points) an employee is entered, his/her salary can be located and displayed. Also perform SUMIF and COUNTIF as required next sheet. 7 2. Commission w VLOOKUP: The same problem as the one used in Excel A2; the difference is that in A2 the commission rate was determined through nested IF, 8 (#2 - 3 points) while here the commission rate is to be determined through a VLOOKUP. 9 3. IF with AND/OR: CSUN MPAcc adminssion, EITHER CSUN-grad or non-CSUN-Grad, to be admitted, ==> 10 (#2 - 4 points) For CSUN grad: GPA 3.2 or higher, 11 Non-CSUN grad: GPA 3.0 or higher, AND GMAT 540 or higher 12 Help here: ===> Logic: 13 (Refer to the EITHER (CSUN grad AND GPA 3.2 or higher) 14 "CSUN inter- OR (Non-CSUN grad AND GPA 3.0 or hierh, AND GMAT 540 or higher). >=3.2 15 national In Excel formumla structure: >=3.0 >=540 16 admission =IF(OR(Red, Green), "Admit", "Deny") 17 example in And the Red part would be: 18 demo 2.2-2.3) AND(CSUN-grad-True, GPA... you figure out) 19 The Green part would be: 20 AND(CSUN-grad-False, GPA... you figure out, GMAT... you figure out) Salary Lookup Enter Lname: (Test Data here) 10 (#2 - 4 points) For CSUN grad: GPA 3.2 or higher, 11 Non-CSUN grad: GPA 3.0 or higher, AND GMAT 540 or higher 12 Help here: ===> Logic: 13 (Refer to the EITHER (CSUN grad AND GPA 3.2 or higher) 14 "CSUN inter- OR (Non-CSUN grad AND GPA 3.0 or hierh, AND GMAT 540 or higher). >=3.2 15 national In Excel formumla structure: >=3.0 >=540 16 admission =IF(OR(Red, Green), "Admit", "Deny") 17 example in And the Red part would be: 18 demo 2.2-2.3) AND(CSUN-grad-True, GPA... you figure out) 19 The Green part would be: 20 AND(CSUN-grad-False, GPA... you figure out, GMAT... you figure out) Salary Lookup Enter Lname: (Test Data here)