1. Construct an appropriate chart to visually display the information contained in the Excel file Coal Consumption. 2. Modify the Excel file Hi-Definition Television to identify televisions that belong to the big screen/projection and LCD/Plasma categories. Use Excel functions to find the minimum and maximum values for the overall scores for each type of television. Count the number of televisions in the big screen/projection category and the LCD/Plasma category.