Excel Assignment

Question

1.       Insert two columns to the right of column A. Enter Catalog # in cell B13 and Type in cell C13. Use Flash Fill to separate the data in column A so that Catalog # is in column B and Type is in column C.

2.       Move the range A1:A11 to B1:B11. Delete column A. Insert a new column to the right of column C and move the Type data in column B to column D. Delete column B.

3.       Merge and center cell A1 across columns A:H and apply the Title style. Merge and center cell A2 across columns A:H and apply the Heading 1 style. Change the theme to Organic.

4.       In cells B5:B8, enter formulas to calculate the average, median, lowest, and highest prices, respectively. Format B5:B8 as Comma style with two decimal places. Move the range A5:B8 to D5:E8. Apply the 20% - Accent6 cell style to the range.

5.       In cell C6, type Price Stats Merge the cells in the range C5:C8, change the orientation to 45 degrees, change the font size to 16, and apply bold. Change the font color to Red, Accent 4 and apply Middle Align and Center.

6.       Merge and center cell A10 across the range A10:B10. Merge and center cell A11 across the range A11:B11. In cell C10, use the COUNTIF function to calculate the number of plants classified as Cooking in the Usage column.

7.       In cell H13, type Low Stock In cell H14, enter an IF function to determine if the In Stock value is less than or equal to 25. If it is, display the text Low, otherwise display OKCopy the formula down the column.

8.       Apply conditional formatting to cells H14:H34 so that if the cell contains Low it displays as Light Red Fill with Dark Red Text. Format cells D14:D34 with Gradient Fill Orange Data Bars.

9.       Format the range A13:H34 as a data table with headers and apply Table Style Light 9. Add a Total row to the table, sum the In Stock amount, and filter the Unit column for Gallon. Enter the total In Stock for the Gallon units in cell C11. Remove the filter and the total row.

10.    Change the orientation to Landscape, center the worksheet horizontally, and insert a custom footer with the file name in the left section.

Answer 1

I believe that the idea is that you do your own homework.