A. Create a table showing the Fahrenheit and Kelvin equivalents of the Celsius degrees from -40 to +40 Celsius. See Figure A below. · Use conversion formulas available here B. Create an input-based conversion model which accepts a Celsius entry and computes the Fahrenheit and Kelvin equivalents. See Figure B below. · Use Excel’s CONVERT function. · There are 105 students in a class. 22 are 1st Year, 45 in 2nd Year, 27 in 3rd Year, and 7 in 4th Year and 4 students did not answer the question. · There are 42 men and 63 women in the class. · 67 students of the class did the homework assignment. What percentage of the class did or did not do the homework? 1. Construct a single formula to be entered in cell B4 that can be auto-filled down to B7 inclusively to return the related attributes. Hint: Labels in the “categories” range (purple) correspond to the field names in the billionaires database itself; rather than seeking a lookup solution, consider how INDEX and MATCH functions may be utilized. Enjoy!