practice book

Upload: prithvi

Post on 12-Mar-2016

217 views

Category:

Documents


0 download

DESCRIPTION

course work

TRANSCRIPT

  • DataProduct Salesperson Region Sum - QuarSum - Salesstellar 4 ###

    manoj 1 200.00West 1 200.00

    Milind 1 5,000.00North 1 5,000.00

    pradeep 1 2,000.00East 1 2,000.00

    sanoj 1 6,000.00South 1 6,000.00

    Total Result 4 ###

  • This shape represents a slicer. Slicers can be used in at least Excel 2010.

    If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used.

  • convention for 2010

    Product Quarter Sales Salesperson Regionstellar 1 5,000.00 Milind Northstellar 1 200.00 manoj Weststellar 1 2,000.00 pradeep Eaststellar 1 6,000.00 sanoj South

    Salutation First name Last name title Mr. Milind Soman modelMrs. manojmr. pradeep

    January February March April May June

  • convention for 2010

    company Number Column1 sales per revenue exp. RevenueSchool 1 1,000.00 1,500.00 school 2 1,000.00 1,500.00 school 3 1,000.00 1,500.00

    July August September October November

  • convention for 2010

    figures

    results percentage500.00 33.33% 0.33333333500.00 33.33% 500.00 500.00 33.33%

    9/15/1979 ###

    December

  • figuresrevenue$1,000.00$2,000.00$3,000.00

  • 1 2 30.00

    200.00

    400.00

    600.00

    800.00

    1,000.00

    1,200.00

    1,400.00

    1,600.00

    sales per revenueexp. Revenueresultspercentage

  • 1 2 30.00

    200.00

    400.00

    600.00

    800.00

    1,000.00

    1,200.00

    1,400.00

    1,600.00

    sales per revenueexp. Revenueresultspercentage

    Sheet6Sheet1old