1. Download from Blackboard the Barney's Farm Excel file. Save the file to your computer. 2. Open the file. Enable the editing if necessay. 3. Follow the steps listed below in the exact order listedl Feel free to refer to chapter/project 2A in your eBook for help with this skill check, if needed. 4. DO NOT SKIP ANY STBPS, as you proceed through this assignment. 5. Seroll down to A38 and type your full name. 6. Merge and Center the text in cell Al through H1. Apply the Title cell style. 7. Merge and Center the text in cell A2 through H2. Apply the heading 2 cell style. 8. Referring to the labels in column A, and using formulas/finctions, complete the range B4:B9 (hint... Carefolly read each label, so you will use the correct column of data in your formulas) 9. Insert two columns to the left of column D. a. In cell D11, type Registered Name b. In cell E11, type Nickname c. Widen column D and E, so that the labels that you just typed display fully. d. Using an Excel editing tool, complete D12:D36, so that the Registered Names in column C are displayed in column D. c. Again, using an Excel editing tool, complete E12:E36, so that the Nickname from column C will be displayed in column E. f. Hide column C. g. Resize all the columns, so that none of them are too narrow or too wide, and the data is fully displayed. 10. In cell G11, type the word Jade (a horse is ealled a jade when they are considered oldertypically between the age of 15 and 20 . The horse can still be ridden but is not as active, when they are jade) 11. For the cells under the Jade heading, use a function that will insert the word No if the age is 15 or younger, otherwise; Yes, should display. 12. Add conditional formatting to cells G12:O36,30 the word Yes will be formatted with a red border. 13. Add solid fill blue data bars to the range F12:F36. 14. Save your work. 15. Create a table with headers to the range A11:O36. a. Sort the table by the Nickname in ascending order. b. Filter the table so only the Clydesdale horses' display. c. Using a table tool, average the Age of the sorted and filtered data. 16. Change the orientation of your spreadsheet to landscape. 17. Tum on the row and column headings, so that if you were being asked to print your spreadsheet the gridlines would then display. We do not need to print, so please do not print. (The activation of the row and column headings step assists the instructor with providing feedback when grading.) The gridlines and row and column headings can be found on the layout tab in the sheet options group. Simply click in the white boxes next to the word Print, as is shown here. 18. Save your work. 19. Verify that your Excel work is saved on your computer, and you've closed the file. (Whille saving