I need to know the formulas in the cells, not just the number.
F 4 1 4 2.85 A C D E 10 Table 1 11 Assessment Criteria Weight VDI Daas 12 Platform Maintenance 15% 1 13 Initial Cost 15% 1 14 Ongoing Cost 15% 4 15 Control 5% 4 16 Time to setup 5% 1 17 Modification 10% 3 18 Dedicated IT Staff 15% 1 19 Total Cost of Ownership 10% 3 20 Technology Maturity 10% 4 21 22 Weighted Score 2.3 23 24 Your Recommendation Daas 25 26 Based on your recommendation, management is evaluating various Vendors for VDI/Daas. 27 You have categorized vendors based on various assessment criteria and listed them in Table 2. 28 Table 3 shows the categories and Ratings. 29 30 Table 2 31 Assessment Criteria Weight Vendor1 Vendor2 32 Ease of management 12.0% Meets Expectations Exceeds Expectations 33 Accessibility 10.0% Exceeds Expectations Meets Expectations 34 Scalability 8.0% Exceeds Expectations Does Not Meet Expectations 35 Cost Savings 30.0% Exceeds Expectations Meets Some Expectations 36 Security 20.0% Meets Expectations Exceeds Expectations 37 Customer Support 15.0% Exceeds Expectations Meets Some Expectations 38 Customizability 5.0% Exceeds Expectations Meets Some Expectations 39 40 Table 3 41 Rating Category Rating Scale 42 Does Not Meet Expectations 43 Meets Some Expectations 44 Meets Expectations 45 Exceeds Expectations Vendor3 Meets Expectations Meets Expectations Exceeds Expectations Exceeds Expectations Meets Expectations Meets Expectations Meets Expectations A B C D E F G H 47 Based on the data in Table 2 and Table3, convert the categorical values to Rating Scale values. 48 (c) Using VLOOKUP write a formula in cell D56 to lookup for the cell D32 value in Table 3 (using Exact match type). Copy the formula to cells D57:562. 49 (d) Using SUMPRODUCT Function, write a formula in cell range D64 to compute the weighted score of Vendor 1. Copy the formula to cells E64 and F64 to calculate other vendor's weighted scores. 50 (e) Using MAX Function, write a formula in cell range D66 to compute the maximum weighted score. 51 (f) Using MATCH Function, write a formula in cell range D67 to compute the cell's column number having the maximum score. Hint: Match the value D66 in the array D64:F64 using exact match type. 52 (g) Using INDEX Function, write a formula in cell range D68 to display the vendor. Hint: INDEX the value of cell D67 in the array D55:F55. 53 54 Table 4 55 Assessment Criteria Weight Vendor 1 Vendor 2 Vendor 3 56 Ease of management 12.0% 57 Accessibility 10.0% 58 Scalability 8.0% 59 Cost Savings 30.0% 60 Security 20.0% 61 Customer Support 15.0% 62 Customizability 5.0% 63 64 Weighted Score 65 66 Maximum Score Column Number of Maximum Score (using 67 MATCH function) Your Recommendation 68 (Using Index Function)
