MS Excel (25 points)
Create a worksheet that includes supporting data for some aspect of your project. This worksheet will be
assessed by the items listed and the overall professional look.
- Select 6 cells in a single row at the top of your worksheet, apply the merge and center command and enter a
title for the project. - Apply fill color to the merged and centered cell.
- Use at least 5 rows and 5 columns, where at least 4 columns have proper titles for the data.
- Use appropriate data that enhances your topic (can be actual or fictitious).
- Format font size of worksheet headings to 14pt, column titles to 12pt and data to 10pt.
- Apply font color to the column titles.
- Apply bold font style to row labels in column A.
- Create a chart with a title to highlight specific data – your choice of proper chart type.
- The worksheet must include calculations—at a minimum 2 different simple formulas must be used (e.g.
Sum, Min, Max, Avg, etc.). - Include an image in your chart that supports your topic – be creative! You could use your image to format
the “chart area” of the chart you create. You could use your image as the format for a single data point of the
chart (works well only if you use a pie chart).