Alternative Learning System-Practical Examination in Spread Sheet

I. Formatting [ Do it in 30 Minutes only ]

a. Merge and Center

Encode the following data’s below. Follow the Correct Range.
A B C D E F
1 Tensile Strength of Cement*       1. Select range B6:G6.
2 1 13 13.3 11.8     2. From Excel's formatting 3. 1. Select Range A2: A6 Color the cell Yellow
toolbar click the "Merge and
3 2 21.9 24.5 24.7  
Center" 3.2. Select Range B2: B6 Color the Cell Blue
4 3 29.8 28 24.1 24.2 26.2 tool.
5 7 32.4 30.4 34.5 33.1 35.7
3.3. Select Range E2: F3 Color the Cell Light Green, with pattern color
6 28 41.8 42.6 40.3 35.7 37.3
White, Pattern Style: Thin Diagonal Stripe.
III.4. Select Range C2: C6 Color the Cell Light Blue
II. Add a cell comment [ Do it in 5 Minutes only ] III.5. Select Range D2: D6 Color the Cell Orange
A B C D E F 1. Select A1 and right click
1 Tensile Strength of Cement* the cell and choose Insert
Comment from the pop-up IV. INSERT [ Do it in 20 Minutes]
2 1 13 13.3 11.8    
3 2 21.9 24.5 24.7   menu that displays 1. From Cell A7 Type the Word: TOTAL, Highlight the Cell from
2. Enter your comment: A7: F7, Go to Border tool and Select Think Box Border. Color
4 3 29.8 28 24.1 24.2 26.2
Number of Unit” the range Purple and the Font Color is White.
5 7 32.4 30.4 34.5 33.1 35.7
6 28 41.8 42.6 40.3 35.7 37.3 2. Calculate the Total of Range A2:A6
3. Calculate the Total of Range B2:B6
4. Calculate the Total of Range of C2:C6
III. Apply Borders and Shade [ Do it in 15 Minutes ]
5. Calculate the Total of Range D2: D6
A B C D E F 1.Select the range A1:F1 6. Calculate the Total of Range E4:E6
1 Tensile Strength of Cement* use a border tool on the 7. Calculate the Total of Range F4:F6
2 1 13 13.3 11.8     formatting tool bar and add
a thick border around the
3 2 21.9 24.5 24.7  
outside.
4 3 29.8 28 24.1 24.2 26.2 2.From the border tool select
5 7 32.4 30.4 34.5 33.1 35.7 MORE BORDER and go
6 28 41.8 42.6 40.3 35.7 37.3 to FILL TAB.
3. Select Color, Fill
Effects and Pattern you
desire.
V. Transpose Data [ Do it in 40 Minutes ] Items Level of Competencies Remarks
1. Calculate the Average of Master Nearly Average Needs Not
Alex 90 80 75 66 each student. Master Practice Competen
2. Arrange the student in
Norman 80 90 78 65 t
rank, according to its GPA
I [5] [4] [5] [4] [5] [4] [5] [4]
Joshua 76 67 70 80 [3] [2] [3] [2] [3] [2] [3] [2]
[1] [1] [1] [1]
Nelly 98 90 89 87

Brix 76 89 90 70 II [5] [4] [5] [4] [5] [4] [5] [4]

[3] [2] [3] [2] [3] [2] [3] [2]
Betty 89 90 98 89 [1] [1] [1] [1]
Kris 78 70 60 80
III [5] [4] [5] [4] [5] [4] [5] [4]
[3] [2] [3] [2] [3] [2] [3] [2]
[1] [1] [1] [1]
1. Create a Purchase
Request Table with
IV [5] [4] [5] [4] [5] [4] [5] [4]
VI. Create a Purchase Request of the following Header : Quantity, Unit,
[3] [2] [3] [2] [3] [2] [3] [2]
[ Do this in 45 Minutes] item, Price.
2. Calculate the Price and [1] [1] [1] [1]
Number of Pieces
45 pcs Laundry Soap 25.00 each V [5] [4] [5] [4] [5] [4] [5] [4]
3. Calculate the total Sum of
65 pcs Brush 20 each [3] [2] [3] [2] [3] [2] [3] [2]
the Purchase Item.
10 pcs Walis ting ting 140 each [1] [1] [1] [1]
5 pcs Mop 150 each
2 gallons of Chlorine 65 each VI [5] [4] [5] [4] [5] [4] [5] [4]
2 gallons of zonrox 120 each [3] [2] [3] [2] [3] [2] [3] [2]
8 gallons of Toilet Liquid Cleaner 250 each [1] [1] [1] [1]
VII [5] [4] [5] [4] [5] [4] [5] [4]
[3] [2] [3] [2] [3] [2] [3] [2]
VII. Calculate the remaining Amount from the Purchased items. [ Do this in 55 minutes ] [1] [1] [1] [1]

ABC trading has a monthly budget of 565,560.00 for its cleaning materials and tools, how
much is the remaining money from the created purchase request?
Find the percentage disburse money from the purchase. Student Signature _________________________ Date Exam: ___________________

Facilitators Signature: ______________________ Admission Slip ________________