Create an Excel Spreadsheet with at least 2 sheets for the Excel Project. Select an appropriate topic of your choice. This project takes longer than the simulations and the other projects, so please plan accordingly.
If you use someone else’s intellectual property, you must cite your source(s).
This assignment is worth 20 points. I will grade this document based on the following criteria; each worth 2 points:
Top row Title cell merged and centered, using Microsoft Excel’s ‘merge & center’ feature.
Top row column titles with any cell style; other than “normal”, using the Microsoft Excel “Cell Styles” feature.
Rows of names (at least 5 rows)
Columns of numbers (at least 5 columns)
Accounting number format with 2 decimal places, use Microsoft Excel “number format” feature.
Auto-fit ALL column width to best-fit; use Microsoft Excel cells “format” feature.
Create Total Row, use the sum formula: sum (sum of a column/row), e.g.,=sum(B4:B8). Also, use formulas, do not simply type the number in the cell.
Max, Min, and Average Formulas: average (average of a column), e.g.,=average(B4:B8) and minimum/maximum (the lowest and/or highest scores), e.g., =min(B4:D8). Do not include the total rows into the formulas. Also, use formulas, do not simply type the number in the cell.
Spelling and grammar checked, file named correctly, use Microsoft Excel “Spelling” checker.
Create a pie chart or column chart on new sheet, use the “Move Chart” button on the ribbon (see image below) to move the chart to a new sheet tab:
Late submissions will receive a zero for the assignment. Upload your Microsoft Excel file here in Canvas. Your file MUST be a Microsoft Excel file type, Canvas will not allow any other file type to be uploaded. The file name should include CIS105, your name, and project title, for example:
CIS105_MarySmith_ExcelProject
Your finished document will look similar (but not the same) as the images below (scroll down for examples):
