58
EXL
5
14. Print Preview and adjust Page Setup with the following changes:
· Paperorientationshouldbelandscape
· Pagemarginsshouldbe.25inchesonallsides
· Theworksheetshouldbeverticallyandhorizontallycenteredonthepage
· Thecenteroftheheadershouldcontainthetext"THESUBHUBWEEKLYINVENTORY"
· The sheet should show gridlines
· Thescalingshouldbesettofittoonepage
15. Print a copy of the document if required by your instructor.
Sub Hub Weekly Inventory
1
2
3
4
5
6
7
8
9
10
11
12
A
B
C
D
E
F
G
H
The Sub Hub Weekly Inventory
Item
Beginning Inventory
Units Ending Inventory
Units Used Sold Disposed
Sub Rolls
275 each
50 each
200
Ham
100 lbs
20 lbs
75
Roast Beef
75 lbs
10 lbs
60
Turkey
100 lbs
5 lbs
90
Salami
70 lbs
40 lbs
30
American Cheese
200 lbs
25 lbs
155
Provolone Cheese
150 lbs
10 lbs
120
Swiss Cheese
125 lbs
15 lbs
105
Bologna
75 lbs
20 lbs
45
Figure ExL-5.1
For Evaluation Purposes Only