It is time for the university to upgrade its Web site. This decision is very important because it will impact current and potential students, faculty, and the community at large. The university has graded 50 different vendors on 10 criteria and with a weight given to each criteria. The 10 criteria and their weights are given below.

1. Customizability (15%)

2. Expandability (15%)

3. Faculty Tutorials (5%)

4. Student Tutorials (5%)

5. Mobile Access (10%)

6. Video Support (10%)

7. File System (5%)

8. Course Migration (15%)

9. Faculty User Interface (10%)

10. Student User Interface (10%)

• Create a formula to calculate the total score. It will be the sum of the category scores multiplied by their weights (given above). For e.g.: For a vendor if the Customizability value is 39, from above we have its weight as 15%. So the total score would be (39x0.15) + weighted score for Expandability and so on.
• Once you have the nal grade, create a formula using the IF function that provides a value of yes if the total score is greater than 90 and no if the total score is less than 90.
• The vendors who earn greater than or equal to 90 could be considered as receiving an A. You dont need to use any formula to find these vendors, you can simply lookup the grades greater than or equal to 90. Then for these vendors (who get an A) write a letter detailing the differences in the nalists considered for implementation (based on which criteria you consider most important, etc).

• The IF function provides one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. For example, the formula:

=IF(A1>10,"Over 10","10 or less") returns "Over 10" if the value in cell A1 is greater than 10, and "10 or less" if the value in cell A1 is less than or equal to 10.

• You do not have to type the if/then formula into every cell. Enter the first formula and press enter. Click the cell to select, and position your mouse over the bottom right corner of the cell. The arrow will change to a plus. Click and drag the formula to the bottom of the row to fill in the values.

Customizability Expandability Faculty Tutorials Student Tutorials Mobile Access Video Support File System Course Migration Faculty User Interface Student User Interface Total Score IF - Then 52 17 49 | || Vendor 002 003 4 005 006 008 009 011 012 014 05 06 17 %5 020 1021 022 023 1024 025 026 027 028 029 66 031 1032 D24 1035 mm, % 08 rm 1040 1041 042 043 1044 045 047 048 1049 01 1036 Customizability Expandability Faculty Tutorials Student Tutorials Mobile Access Video Support File System Course Migration Faculty User Interface Student User Interface Total Score IF - Then 52 17 49 | || Vendor 002 003 4 005 006 008 009 011 012 014 05 06 17 %5 020 1021 022 023 1024 025 026 027 028 029 66 031 1032 D24 1035 mm, % 08 rm 1040 1041 042 043 1044 045 047 048 1049 01 1036