Faculty

CISY 102 Computer Literacy

Final Project Part C (10 points)

From the book, do the Exercise Lab 1: Annual Cost of Goods Worksheet that is on pages EX74-EX75

Deviations from book:

  •  For Step 7, only provide your name 
  •  For Step 8, name the workbook as Name Coffee.xlsx where Name is your name 
  •  Do not do Steps 9, 10, 11 

Grading Rubric

  • Filename as requested Name Coffee.xlsx(1/2 point)
  • Data and Labels Entered as requested in range A1:F7 (1 point)
  • Row/Column totals using SUM function (1 point)
  • Format of cells:
    • Accounting Number format on Ranges Requested (1 point)
    • Comma Style format on Range Requested (1 point)
  • Merge of Cells as requested (1 point)
  • Cell Styles (Title, Heading 2, Total, etc) and Fonts (2 points)
  • Bar Chart on proper data range (1 point)
    Bar Chart positioned/sized as requested (1 point)
  • Document Properties (1/2 point)