spreadsheet3

spreadsheet3 - CS170 Spreadsheet Assignment 2 Section: 10...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CS170 Spreadsheet Assignment 2 Section: 10 Employees Hours Base Pay Rate Jay Sly 50 $20.00 Joe Good 70 $20.00 Ted Free 85 $20.00 Kat Will 100 $20.00 Jen Ace 150 $20.00 Dan Rather 110 $20.00 Mad Hat 89 $20.00 Jon Doe 56 $20.00 Tito Fox 38 $20.00 Hec Tig 20 $20.00 Column Totals $768.00 $200.00 Sales $0.00 $1,000.00 $5,000.00 $10,000.00 $20,000.00 $100,000.00 Number of Cells with Values 10 10 Number of Cells with just text Maximum 150 $20.00 Minimum 20 $20.00 Average 76.80 $20.00 Jay Sly; $1,000.00 Joe Good; $1,400.00 Ted Free; $1,700.00 Kat Will; $2,000.00 Dan Rather; $2,200.00 Mad Hat; $1,780.00 Jon Doe; $1,120.00 Tito Fox; $760.00 Hec Tig; $400.00 CS170 Spreadsheet Assignment 2 Section: 10 Jen Ace; $3,000.00 CS170 Spreadsheet Assignment 2 Section: 10 Cap City Inc. Sales Staff Payroll Data for Last Month Total Base Pay Sales Commisision Rate $1,000.00 $3,000.00 1.00% $1,400.00 $4,500.00 1.00% $1,700.00 $100,000.00 10.00% $2,000.00 $10,000.00 3.00% $3,000.00 $50,000.00 5.00% $2,200.00 $4,000.00 1.00% $1,780.00 $6,500.00 2.00% $1,120.00 $8,900.00 2.00% $760.00 $9,800.00 2.00% $400.00 $11,000.00 3.00% $15,360.00 $207,700.00 Commision 0% 1% 2% 3% 5% 10% 10 10 10 $3,000.00 $100,000.00 10% $400.00 $3,000.00 1% $1,536.00 $20,770.00 3% CS170 Spreadsheet Assignment 2 Section: 10 CS170 Spreadsheet Assignment 2 Section: 10 Commission Pay Advances Total Pay $30.00 $500.00 $530.00 $45.00 $45....
View Full Document

This note was uploaded on 12/06/2010 for the course CS 170 taught by Professor Ganu during the Spring '09 term at Rutgers.

Page1 / 17

spreadsheet3 - CS170 Spreadsheet Assignment 2 Section: 10...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online