iRubric: Excel2 Lab1 rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Excel2 Lab1 Excel2 Lab1 Sales Analysis Worksheet Rubric Code: P43A29 By bellobello Ready to use Public Rubric Subject: Computers Type: Project Grade Levels: (none)

Chart
	(N/A)
Worksheet Title/Subtitle Formatting	N/A Merged & Centered (cells A through F) Background color red applied Title cell style applied Thick Border applied Font Color set to white A1 changed to 28pt 1 point each/6 points total
Column Headings A3:F3 Formatting	N/A Centered/line breaks as indicated Heading 3 cell style applied Italicized 1 point each/3 points total
Formatting General	N/A A11:A14 Italicized A10:F10 Total cell style applied B14 Percent number format/hundredths B14 Thick border/centered B14 Same color settings (font/background) as a1 Row height: 3=33pt, 11/14=30pt Col widths: A=19pt, B-F=13.5pt B4:F4/B10:F13 Floating Dollar Sign Format/2 decimals/(neg) B5:F9 Comma Style 1 point each/9 points total
Formulas	N/A D4:D9 Correct subtraction formulas F4:F9 Correct subtraction formulas Row 10: Correct Sum Formulas Row 11: Average Formulas Row 12: Max Formulas Row 13: Min Formulas B14: Formula/centered 1 point each/7 points total
PDF	N/A Landscape PDF Range PDF 1 point each/2 points
Misc	N/A Correct data entry Use of new lines within cells in Row 3 Aspect Theme applied Sheet renamed Header information on printouts Properties updated 1 point each