COURSE PAYMENT FOR JALLOW'S COMPUTER TRAINING
NAME COURSE COURSE FE AMOUNT PABALANCE
Musa Web Develo 15000 8474
Lamin TrawaDatabase Pr 28930 12038
Isatou BadjieProgramming 12780 9483
Muhammed D Networking I 12859 3832
Rohey MannMicrosoft Of 10928 4523
Bintou Sann Networking I 10329 4647
Lala Tamba ACCA 38343 17580
Sankung JarjBanking and 14920 3638
Rahman BahWeb Develo 15000 4748
Demba TourACCA 38343 7595
Total
Maximum
Minimum
Average
Instructions:
1 - Select cell range A1:E17 and apply a font style of Aptos Narrow and font size of
2 - Select cell range A1:E1 and apply Merge and Center alignment
3 - Select cell range A1:E17 and apply Autofit Column Width
4 - Select cell range A1:E1 and apply a Row Height of 20pt, a Middle Align,
5 - Select cell range A2:E2 and apply Bold, Fill Color Light Gray, Background 2, Darker 10% and a slim
6 - Calaculate Musa Dumbuya's Balance by subtract Amount Paid from Course Fee
7 - Select cell range C3:E12 and apply a Gambia Dalasi currency code and apply
8 - Select cell range C13:E13 and apply Thick Bottom Border
9 - In cell C14 calculate the Total of Course Fee using autosum feature but the cell range selected is wrong. Correct
10 - As in item 9 above use the MAX function for Maximum, MIN function for Minimum, and
11 - Select cell range A14:A17 and apply Bold
12 - Use the Sort feature to Sort the Balance of students in Ascending Order
13 - Filter and extract those who are doing ACCA and WEB Development, then
14 - Remove the filtering applied in item 13 above. Filter and extract those students with
15 - Now the remove filter to show all the students
16 - Apply Freeze on Row 3
17 - Hide Rows 15 to 17
18 - Rename the Worksheet to COURSE PAYMENT
19 - Select cell range A1:E12 then Copy, Open a new worksheet(rename the sheet: COPIED DATA) and
20 - Select columns A:E and use the Autofit Column Width to exapnd the columns respectively
21 - Select cell range A2:E12 and convert the dataset as a Table
22 - Save your Excel file as such (example: Mr. L. Kassama_EXCEL_ASSIGNMENT_01)
NOTE: This assignment (15%) to be submitted before our next clsss . Failure to observe this instruction will attract
Please email me the fnished assignment : lkassama26@[Link]
w and font size of 11pt
nt
ddle Align, Bold, and a slim Bottom Border
Background 2, Darker 10% and a slim Bottom Border
d from Course Fee then use the Autofill Handle to calculate for the rest of the other students
ode and apply Zero Decimal Places
ature but the cell range selected is wrong. Correct it by selecting the correct cell range then after use the Autofill Handle
N function for Minimum, and Average function for Average to calculate in respective cells references
ing Order
lopment, then Copy the entire students records including the headers: Name, Course, Course Fee, Amount Paid, and
ct those students with Balance of more than 10,000 dalasis. Like in item 13 Copy and Paste the information in cell
ename the sheet: COPIED DATA) and Paste the copied data in Cell A1
apnd the columns respectively
EL_ASSIGNMENT_01)
sss . Failure to observe this instruction will attract you a 0%
assama26@[Link] 24th March 2025:: Time: 17:07pm
Autofill Handle to find Totals for Amount Paid in cell D14 and Balance in cell E14
ount Paid, and Balance and Paste the information in cell J5
ation in cell J10
07pm
