Start with a clean version of the file Training.xlsx. Begin by using VBA to name the following ranges with the range names specified: cell A1 as Title, the headings in row 3 as Headings, the employee numbers in column A as EmpNumbers, and the range of scores as Scores. (These are to be Excel range names that will appear in the Excel sheet itself.) Refer to these range names as you do the following:

(a) Fill the cells containing all of the scores yellow. (

b) Boldface the title of the spreadsheet in cell A1.

(c) Change the font of the column headings to 22 point.

(d) Change the formatting of the employee numbers to have a comma in front of the last three digits.

B D E F H K L M N O P Q R First Name Exam 3 Exam 4 Exam 1 99 Exam 2 89 85 Exam 5 81 95 74 81 78 91 Noah Sophia Ethan Alexander Liam 94 77 70 96 89 88 74 92 62 91 86 88 91 73 82 73 1 Employee Training Scores 2 3 ID Last Name 4 16006 Aaron 5 16002 Avila 6 16013 Bergeron 7 16003 Cooper 8 16008 Cota 9 16004 Douglass 10 16015 11 16011 Gaffney 12 16005 Griffis 13 16007 Hay 14 16009 Knowles 15 16019 Laird 16 16020 Loomis 17 16012 Poe 79 81 94 81 77 Emma Mia Fox 74 99 85 71 68 90 96 93 96 92 94 73 96 82 98 Jacob Isabella Benjamin Harper Charlotte 79 62 81 70 72 92 97 96 80 62 71 93 70 72 100 Ava 67 87 93 84 67 71 94 84 81 63 18 16014 Saenz 73 92 76 66 60 19 16016 95 82 66 91 73 Saburo Sachi Zack Batette Qadir Lachina 71 61 83 20 21 22 Ulrich Wing Wynne Yoo 16001 16018 92 67 75 68 97 72 65 16017 79 74 82 83 82 Sheet1 + FO Accessibility: Good to go M