typing

INFORMATION TECHNOLOGY/COMPUTER APPLICATIONS

APPLICATION PROGRAM: MICROSOFT EXCEL

EXCEL EXERCISE 1:

1) Create the spreadsheet exactly as shown in the illustration.

	A	B	C	D	E	F	G
1			BELTS		GLOVES		SCARVES
2
3	JAN.
4
5	FEB.
6
7	MAR.

2) Save the file as SALES in your folder.

3) Make the following changes or corrections as indicated:

a. Go to cell C1: Change the label to HATS.

b. Go to cell A3: Change JAN. to JANUARY

c. Go to cell A5: Change FEB. to FEBRUARY

d. Go to cell A7: Change MAR. to MARCH

e. In cell C3: Enter the number 882

f. In cell C5: Enter the number 673

g. In cell C7: Enter the number 912

h. In cell E3: Enter the number 534

i. In cell E5: Enter the number 498

j. In cell E7: Enter the number 210

k. In cell G3: Enter the number 570

l. In cell G5: Enter the number 425

m. In cell G7: Enter the number 125

4) Resave the file.

EXCEL EXERCISE 2:

1) In a new spreadsheet enter the values exactly as shown in the illustration.

	A	B	C	D	E	F	G
1
2	NAME		GROSS PAY		S.S.T.	F.W.T.	NET PAY
3
4	DEMBO, S.		366.75		25.67	73.35
5	GOMEZ, J.		325.72		22.81	65.14
6	KLINE, A.		350.58		24.54	50.18
7	WANG, J.		375.25		26.27	75.06
8	YEPEZ, X		450.85		31.56	40.12
9

2) Save the document as PAYROLL in your folder.

EXCEL EXERCISE 3:

1) In a new spreadsheet enter the values exactly as shown in the illustration.

	A	B	C	D	E	F	G
1			January	February	March	1st QTR.
2	INCOME
3
4	Wages		2015.54
5	Other		75.84
6	TOTAL INCOME
7
8	EXPENSES
9
10	Rent		510.23
11	Utilities		185.17
12	Food		412.45
13	Clothing		185.17
14	Insurance		112.83
15	Loans		230.36
16	Medical		50.75
17	Other		175.48
18	TOTAL EXPENSES
19
20	SAVINGS

2) Save as BUDGET.

EXCEL EXERCISE 4:

1) In a new spreadsheet enter the values exactly as shown in the illustration.

	A	B	C	D	E	F	G
1	STOCK		UNIT OF	UNITS	COST PER		TOTAL
2	ITEM		COUNT	ON HAND	UNIT		VALUE
3
4	PENCILS			27	3.89
5	STAPLERS			36	6.76
6	STAPLES			155	1.53
7	CLIPS			101	0.65
8	DISKS			43	8.95
9	PAPER		Ream	75	5.85
10	RIBBONS			16	5.33

3) Enter the missing information for Unit of Count as indicated:

a. The UNIT Of COUNT for Pencils, Staples, Clips, and Disks is Box.

b. The UNIT Of COUNT for Staplers, and Ribbons is Each.

4) Save the document as INVEN in your folder.