Int Spreadsheets EX 5


	Int Spreadsheets EX 5

Intermediate Spreadsheet Concepts Exercise 5

Create a spreadsheet using the following information. You have been asked to construct a spreadsheet for Mike's Mail Order Company.

1)	Enter the raw data below, applying as many presentation Features (Font, Font Size, Font Colour, Number Formats and Colour, Cell Shading, Text Rotation, etc) to it as you wish.
2)	Apply appropriate number formats to your numbers.
3)	Center your spreadsheet horizontally on the page
4)	Give your spreadsheet an appropriate title and center it across your spreadsheet.
5)	Select the best page orientation for your spreadsheet.
6)	Adjust the column width and row height to suit the layout you have selected.
7)	Create formula's to calculate delivered cost for each item.
8)	Create formula's to calculate the Monthly Income for each Item, the Monthly Income from the delivery of each Item, and the total Monthly Income for each item.
9)	Create formula's to calculate totals for each column in your spreadsheet.
10)	Set the layout of your spreadsheet to display the header or column labels at the top of each page when printed.
11)	Setup an appropriate header for this spreadsheet.
12)	Setup a page number for this spreadsheet and place it in the footer.

Item

Price

Delivery Charge

Ordered This Month

Bath Towels

$6.95

$5.00

319

Bathroom Radio

$24.95

$8.00

150

Bathroom Scales

$99.95

$10.00

63

BBQ

$199.95

$20.00

38

Beach Towels

$9.95

$5.00

412

Board Games

$39.95

$8.00

95

Book Ends

$29.95

$10.00

241

Book Shelf

$49.95

$15.00

168

Camera

$69.95

$10.00

112

Card Games

$14.95

$5.00

243

Carving Fork

$17.95

$5.00

177

Clothes Hanger

$4.95

$5.00

588

Computer Games

$89.95

$5.00

126

Cooking Timer

$21.95

$5.00

169

Cordless Telephone

$119.95

$10.00

87

Curtain Rails

$129.95

$10.00

94

Curtains

$124.95

$8.00

317

Digital Camera

$999.95

$10.00

349

Digital Clock

$99.95

$10.00

476

Double Sheets

$49.95

$5.00

355

Electric Blender

$299.95

$20.00

122

Electric Knife

$149.95

$10.00

52

Electric Mixer

$399.95

$20.00

12

Fan Cooker

$199.95

$20.00

49

Fire Extinguishers

$249.95

$20.00

79

Hand Towels

$7.95

$5.00

513

King Sheets

$69.95

$5.00

299

Kitchen Scales

$89.95

$15.00

83

Kitchen Utensils

$29.95

$10.00

197

Microwave Oven

$799.95

$20.00

42

Model Boat

$59.95

$10.00

179

Model Plane

$99.95

$10.00

134

Model Yacht

$64.95

$10.00

187

Night Light

$29.95

$8.00

262

Pillow Slips

$7.95

$5.00

578

Pillows

$19.95

$10.00

345

Plant Pots

$9.95

$5.00

899

Queen Sheets

$59.95

$5.00

444

Rotary Oven

$249.95

$20.00

68

Security Lights

$64.95

$10.00

81

Serving Spoon

$9.95

$5.00

164

Single Sheets

$29.95

$5.00

475

Smoke Detectors

$19.95

$5.00

687

Stop Watch

$34.95

$5.00

265

Tea Towels

$18.95

$5.00

947

Tennis Balls

$8.95

$5.00

1,421

Wall Clock

$49.95

$10.00

186

Wine Opener

$29.95

$5.00

197

Wine Racks

$79.95

$20.00

59

Fruit Bowl

$29.95

$5.00

799

Carving Knife

$19.95

$5.00

1,254

Tooth Picks

$3.95

$5.00

2,233

Screwdriver Set

$19.95

$5.00

588

Drill Set (10 Piece)

$24.95

$5.00

472

Electric Tooth Brush

$23.95

$5.00

991

Coffee Cup Set

$14.95

$10.00

631

Tea Set

$39.95

$10.00

481

Lipstick Selection

$21.95

$5.00

999

Quick Burner

$19.95

$5.00

1,087

BBQ Lighters

$9.95

$5.00

2,378

Cup Hooks

$2.95

$5.00

2,594

Table Tennis Bats

$10.95

$5.00

276

Table Tennis Balls

$1.95

$5.00

552

Table Mats

$12.95

$10.00

773

Chopping Board

$14.95

$15.00

182

House Alarm System

$199.95

$20.00

95

Massage Pillow

$49.95

$10.00

423

Christmas Tree Lights

$29.95

$10.00

432

Christmas Decorations

$24.95

$10.00

587

Dinner Set

$38.95

$20.00

333

Potato Masher

$9.95

$5.00

199

Potato Peeler

$7.95

$5.00

156

Potato Eye Remover

$5.95

$5.00

123

Apple Core Remover

$5.95

$5.00

138

Electric Toaster

$99.95

$15.00

185

Camping Oven

$149.95

$20.00

50

Tent (2 person)

$189.95

$20.00

42

Tent (4 person)

$249.95

$20.00

68

View Model Answer

| BODMAS Exercises | Word Exercises | Excel Exercises |