Excel practice questions 2025
QUESTION 1: Spreadsheet Practice (Microsoft Excel)
The following information is obtained from MUFTI Limited for some selected staff members.
| Staff Name | Basic Salary (UGX) |
|---|---|
| Jackie | 660,000 |
| Kent | 760,000 |
| Pauline | 870,000 |
| Unice | 580,000 |
| Xavier | 600,000 |
| Leonald | 610,000 |
| Sonny | 630,000 |
| Christine | 640,000 |
| Philiper | 650,000 |
| Innocent | 555,000 |
Required:
Using Microsoft Excel, perform the following tasks:
-
Enter the above information into a spreadsheet.
-
Calculate the Lunch Allowance for each employee, given that it is 22% of their basic salary.
-
Calculate the Housing Allowance, which is 62% of the lunch allowance.
-
Add a Transport Allowance of 59,000 UGX for all employees.
-
Compute the Gross Pay for each employee.
(Gross Pay = Basic Salary + Lunch Allowance + Housing Allowance + Transport Allowance)
-
Calculate PAYE as 2.5% of the Basic Salary.
-
Compute the NSSF (National Social Security Fund) as 18% of the Gross Pay.
-
Determine the Net Pay for each employee.
(Net Pay = Gross Pay – PAYE – NSSF)
-
Plot a Line Graph of Net Pay against Basic Salary on Worksheet 2.
-
Save your work on the desktop using your Name as the file name.
QUESTION 2: Spreadsheet Practice (Microsoft Excel)
The following students sat for their Term Two examinations in Mathematics (Mat), Computer Studies (Comp), and Entrepreneurship (Ent), and obtained the marks shown below:
| Student Name | Mat | Comp | Ent ( |
|---|---|---|---|
| John | 40 | 20 | 50 |
| Mary | 90 | 60 | 30 |
| Tania | 75 | 65 | 90 |
| Samuel | 55 | 40 | 80 |
| Paul | 50 | 20 | 35 |
| Albert | 50 | 60 | 50 |
Required:
Using Microsoft Excel, perform the following tasks:
-
Enter the above data into a spreadsheet. Ensure all names are in Column A.
-
Compute the Total Marks for each student using a formula, and display them in Column E.
-
Sort the data in Column E (Total Marks) in descending order (from highest to lowest).
-
Determine how many students scored a D1 in Mathematics, given that a D1 is awarded at 75% and above.
-
Format the titles in Columns A, B, C, D, and E so that the text is displayed in an orientation of 45° (diagonal).
-
Give your work a professional appearance by applying suitable formatting (borders, bold headings, and consistent alignment).
-
Plot a Bar or Column Graph showing each student’s marks in the three subjects.
Your graph should have an appropriate title, labeled axes, and a legend.
-
Insert a Header containing your name.
-
Save your work as “Yourname Scores” and print your worksheet.
Responses