6. (***) (Microsoft Excel problem). The following worksheet uses a weighted-point evaluation system to calculate weighted performance scores along four dimensions for up to four potential sources. Re-create this spreadsheet in Microsoft Excel. Code your spreadsheet so that any change in the highlighted cells will result in recalculated performance scores. Your formatting does not have to be exactly the same, but your numbers should be. (Hint:

Changing all the importance weights to 0.25 should result in scores of 2.25 and 3.5 for Sources X1 and X2, respectively.)

A 1 B C Weighted-Point Evaluation System 4 Dimension Importance X1 23456789 D E F Potential Sources X2 X3 X4 A 0.20 1 3 2 4 B 0.30 2 4 3 2 C 0.30 2 4 3 2 D 0.20 4 3 2 1 9 Total: 1.00 10 Scores: 2.2 3.6 2.6 2.2