typing
EXCEL EXERCISE 5:
1. In a blank workbook, key the illustration as shown.
|
|
A |
B |
C |
D |
E |
|
1 |
|
|
|
|
|
|
2 |
|
|
|
|
|
|
3 |
|
NetConnect Networking Specialists |
|||
|
4 |
|
|
|
|
|
|
5 |
|
|
April |
May |
June |
|
6 |
|
John Baker |
|
|
|
|
7 |
|
Pat Smith |
|
|
|
|
8 |
|
Sally Cooper |
|
|
|
|
9 |
|
Jack Johnson |
|
|
|
|
10 |
|
Melanie McMann |
|
|
|
|
11 |
|
|
|
|
|
0. Save as XL_06.
1. Select B3 to E3 and merge the cells to form one.
2. Center, bold and resize (18) the information in the merged cells.
3. Adjust the width of Column B so that all the names fit without flowing into the next column.
4. Center align the labels in Row 5.
5. Create a header with your name on the left, the file name centered, and the date on the right.
6. Save changes and close the file.
EXCEL EXERCISE 6:
1. Open SALES in your folder.
2. Delete Columns F, D, and B.
3. Delete Rows 6, 4, and 2.
4. In cells A5 and E1 enter the label TOTALS.
5. To obtain the total for each month, enter formulas in column D horizontally as follows:
e. In E2 add the values in cells B2, C2 and D2.
Option 1: =B2+C2+D2
Option 2: =SUM(B2:D2)
b. In E3 add the values in cells B3, C3 and C3.
c. In E4 add the values in cells B4, C4 and D4.
0. To obtain a total for each item, enter formulas vertically.
a. In B5 add the values in the HATS column.
b. In C5add the values in the GLOVES column.
c. In D5 add the values in the SCARVES column.
d. In E5 add the values in the TOTALS column.
1. Bold all the labels in Row 1 and Column A.
2. Center the labels in Row 1.
3. Proofread and correct errors.
4. Resave and close the file.
EXCEL EXERCISE 7:
1. Start a new workbook and Save it as XL_07.
2. Key the information as seen in the worksheet.
|
|
A |
B |
C |
D |
E |
F |
G |
H |
|
1. |
|
|
|
|
|
|
|
|
|
0. |
|
|
|
|
|
|
|
|
|
0. |
|
Carella’s Hair Design |
|
|||||
|
0. |
|
Price List |
|
|
|
|
|
|
|
0. |
|
|
|
|
|
|
|
|
|
0. |
|
|
Susie |
John |
Allys |
Carrie |
Deb |
|
|
0. |
|
Hair Cut |
$20.00 |
$18.00 |
$16.00 |
$14.00 |
$12.00 |
|
|
0. |
|
Shampoo |
$7.50 |
$7.00 |
$6.50 |
$6.00 |
$5.50 |
|
|
0. |
|
Styling |
$12.50 |
$13.50 |
$14.50 |
$15.50 |
$16.50 |
|
|
0. |
|
Colour |
$27.00 |
$29.00 |
$31.00 |
$33.00 |
$35.00 |
|
|
0. |
|
Perm |
$22.00 |
$24.00 |
$26.00 |
$28.00 |
$30.00 |
|
|
0. |
|
Body Treatment |
$50.00 |
$40.00 |
$30.00 |
$20.00 |
$10.00 |
|
|
0. |
|
|
|
|
|
|
|
|
a. The worksheet title should be centered and merged along cells B3 – B3.
b. The names of stylist should be centered in their cell.
c. All the labels in Column B7-B12 should be right aligned.
d. Adjust column widths where necessary to ensure the information in cell fits.
e. Use the currency icon to add $ sign. (Select the cells with figures and click on the Currency Style button.)
0. In cells B13 and H6 key the label TOTAL.
1. In Row 13, enter a formula to calculate the total for the stylists.
Example: To calculate for Susie, place your cursor in cell C13 add all the values from C7 to C12.
Option 1: =C7+C8+C9+C10+C11+C12
Option 2: =SUM(C7:C12)
0. In Column H calculate monies received for each type of hair treatment done.
Example: To calculate monies for Haircuts, place your cursor in cell H7 add all the values from C7 to G7.
Option 1: =C7+D7+E7+F7+G7
Option 2: =SUM(C7:G7)
0. Rename Sheet 1 (tab at the bottom) to Price List.
1. Save the file and close.
EXCEL EXERCISE 8:
1. Open the file XL_06.
2. Save the file as XL_10.
3. Enter the sales data for each person as indicated:
c. John Baker (April 33250, May 29458, June 55678)
c. Pat Smith (April 12998, May 21754, June 11590)
c. Sally Cooper (April 34780, May 45958, June 125650)
c. Jack Johnson (April 54875, May 33560, June 25885)
c. Melanie McMann (April 34780, May 42100, June 29758)
1. Format the sales data using Currency.
1. In cells B11 and F5, key the label TOTAL.
1. In Row 11, find the totals for each month. In Column F, find the total for each person.
1. Save your changes.