CIS 110 Excel Project 1

Grading

This project is worth 30 points.
 

You are responsible for all decisions regarding cell width, format, labels, and formulas unless otherwise indicated.

• Use appropriate formulas including functions and absolute references where appropriate.

    10 Points

• Insert a row and enter your name where indicated
• Enter the column and row labels as shown above
• Add the following formulas
  Total Hours = Regular Hours + Overtime Hours
  Pay = (Regular Hours * Hourly Wage) + (Overtime Hours * 1.5 * Hourly Wage)
  Totals for Regular Hours, Overtime Hours, Total Hours & Pay
• Change the worksheet name to Week 1
  
   
• Save as your file as Excel Project 1

    10 Points

• Create a copy of the worksheet in the same workbook
• Name it Week 2
  
    
• Change the values as follows

• Format the worksheet using styles presented in chapters 1 - 3.
• Save your file.

    10 Points

• Create a 3-D pie chart as a new sheet of the showing the cost for each weekday from Week 2.
• Remove the legend
• Add labels for each pie slice with leader lines
• Add a chart title "Weekday Payroll" and format it using at least a 22 point font size.
• Change the color of the labels and title
• Rename the chart worksheet Pie Chart
  
   
• Save as your file.
• Upload the file Excel Project 1 to the Digital Drop box.

Optional

    10 Points - Extra Credit

• Create a copy of the Week 2 worksheet in the same workbook
• Name the sheet Extra Credit
• Goal Seek to find the value of the Hourly Rate if the Total Pay is 600.00
• Add conditional formatting for the Pay (Monday - Friday)
  Set the background color to Red and font to bold for values greater than 100
• Save as your file as Excel Project 1 EC.
• Upload the file Excel Project 1 EC to the Digital Drop.

How is this assignment graded?

• This test is designed to be completed in 30 minutes. 
• After you are finished you need to upload it to the Drop Box. 
   
• Follow instructions: naming worksheets, correct placement of values and formulas.
• Correct use of formulas, cell references (relative & absolute), functions (Sum).
• Formatting worksheet: format styles similar to those presented in chapters 1 - 3.
• Chart: correct chart type, correct data used
• No circular cell reference in worksheets
• Proper use of goal seeking - extra credit