KEMBAR78
Sample Data For Excel Exercises | PDF | Home & Garden
Scribd
Upload
344 views3 pages

Sample Data For Excel Exercises

The document appears to be a sales order log listing orders over time with details of items ordered, quantities, unit costs and totals. It includes orders from 2010 to 2011 in various regions handled by different sales representatives. For each order it provides the date, region, sales rep, items ordered, quantities, unit costs and total costs. There are over 100 orders recorded in the log spanning two years with various items like pencils, binders, pens and desks.

Uploaded by

Taquito
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
344 views3 pages

Sample Data For Excel Exercises

The document appears to be a sales order log listing orders over time with details of items ordered, quantities, unit costs and totals. It includes orders from 2010 to 2011 in various regions handled by different sales representatives. For each order it provides the date, region, sales rep, items ordered, quantities, unit costs and total costs. There are over 100 orders recorded in the log spanning two years with various items like pencils, binders, pens and desks.

Uploaded by

Taquito
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 3

OrderDate Region Rep

1/6/10 East

Jones

Item

Units

Unit Cost Total

Pencil

95

1.99

189.05

Binder

50

19.99

999.50

Pencil

36

4.99

179.64

2/26/10 Central Gill

Pen

27

19.99

539.73

3/15/10 West

Sorvino

Pencil

56

2.99

167.44

Jones

Binder

60

4.99

299.40

4/18/10 Central Andrews

Pencil

75

1.99

149.25

5/5/10 Central Jardine

1/23/10 Central Kivell


2/9/10 Central Jardine

4/1/10 East

Pencil

90

4.99

449.10

Thompson Pencil

32

1.99

63.68

Jones

Binder

60

8.99

539.40

6/25/10 Central Morgan

Pencil

90

4.99

449.10

7/12/10 East

Howard

Binder

29

1.99

57.71

7/29/10 East

Parent

Binder

81

19.99

1,619.19

8/15/10 East

Jones

Pencil

35

4.99

174.65

Desk

125.00

250.00

Pen Set

16

15.99

255.84

5/22/10 West
6/8/10 East

9/1/10 Central Smith


9/18/10 East

Jones

Binder

28

8.99

251.72

10/22/10 East

10/5/10 Central Morgan


Jones

Pen

64

8.99

575.36

11/8/10 East

Parent

Pen

15

19.99

299.85

11/25/10 Central Kivell

Pen Set

96

4.99

479.04

12/12/10 Central Smith

Pencil

67

1.29

86.43

12/29/10 East

Pen Set

74

15.99

1,183.26

Binder

46

8.99

413.54

Binder

87

15.00

1,305.00

Jones

Binder

4.99

19.96

Sorvino

Binder

Parent

1/15/11 Central Gill


2/1/11 Central Smith
2/18/11 East

19.99

139.93

3/24/11 Central Jardine

3/7/11 West

Pen Set

50

4.99

249.50

4/10/11 Central Andrews

Pencil

66

1.99

131.34

4/27/11 East

Pen

96

4.99

479.04

5/14/11 Central Gill

Pencil

53

1.29

68.37

5/31/11 Central Gill

Binder

80

8.99

719.20

6/17/11 Central Kivell

Desk

125.00

625.00

Pen Set

62

4.99

309.38

7/21/11 Central Morgan

Pen Set

55

12.49

686.95

8/7/11 Central Kivell

Pen Set

7/4/11 East

Howard

Jones

42

23.95

1,005.90

Desk

275.00

825.00

9/10/11 Central Gill

Pencil

1.29

9.03

9/27/11 West

Pen

76

1.99

151.24

57

19.99

1,139.43

8/24/11 West

10/14/11 West

Sorvino
Sorvino

Thompson Binder

10/31/11 Central Andrews

Pencil

14

1.29

18.06

11/17/11 Central Jardine

Binder

11

4.99

54.89

Developed by Contextures Inc.

www.contextures.com

10/13/2013

12/4/11 Central Jardine

Binder

94

19.99

1,879.06

12/21/11 Central Andrews

Binder

28

4.99

139.72

Developed by Contextures Inc.

www.contextures.com

10/13/2013

Contextures Links
30 Excel Functions in 30 Days eBook Kit
Contextures Excel Tips Website
Contextures Excel Blog
Excel Pivot Tables Blog
Debra's Pivot Table Books on Amazon

Contextures Recommends
Jon Peltier's Excel Chart Utilities
ExcelUser Dashboards
Chandoo's Excel VBA School
Chandoo's Project Management Templates
Excel Guru Magic of Pivot Tables Course
JP's Random Data Generator for Excel

www.contextures.com

10/13/2013

You might also like