spreadsheet2

spreadsheet2 - Employees JaySly JoeGood TedFree KatWill...

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

View Full Document Right Arrow Icon
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 0 0 Maximum 150 $20.00 Minimum 20 $20.00 Average 76.80 $20.00
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

spreadsheet2 - Employees JaySly JoeGood TedFree KatWill...

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

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