This post provides both theory and practical solutions to the November/December 2020 Level Two Spreadsheet Management past question. Designed and curated by Armstrong Computers College, this content is tailored to help students understand Microsoft Excel better, especially in preparation for exams.
At Armstrong Computers, our vision is to bring quality ICT education to your doorstep and help shape your digital future.
SECTION A – Theory Questions
1. What is the filename extension for all MS Excel files?
The file extension is .xlsx for Excel 2007 and later versions, and .xls for earlier versions.
2. What is meant by freeze rows and columns?
Freezing rows or columns keeps them visible while scrolling through the rest of the worksheet.
3. Explain the term sorting.
Sorting is arranging data in a specific order, such as ascending or descending based on a selected column.
4. Sorting from high order to low order is called __________ order.
Descending order.
5. Sorting from low order to high order is called __________ order.
Ascending order.
6. What is a dialog box?
A dialog box is a pop-up interface element that prompts the user to input information or make a decision.
7. Explain filtering in spreadsheet.
Filtering allows you to display only the rows that meet specific criteria, hiding the rest.
8. Mention TWO (2) statistical functions.
=AVERAGE(), =MAX()
9. Mention TWO (2) financial functions.
=PMT(), =FV()
10. What is worksheet protection?
Worksheet protection prevents users from accidentally changing formulas or locked cells.
SECTION B – Timesheet Practical (Excel)
Create the following table structure in Excel:
| DAY | TOTAL HOURS | REGULAR HOUR | OVERTIME HOUR | ADJUSTED TOTAL HOUR |
|---|---|---|---|---|
| MONDAY | 10 | 8 | =B2-C2 | =C2+(B2-C2)*1.5 |
| TUESDAY | 11 | 8 | =B3-C3 | =C3+(B3-C3)*1.5 |
| WEDNESDAY | 8 | 8 | =B4-C4 | =C4+(B4-C4)*1.5 |
| THURSDAY | 9 | 8 | =B5-C5 | =C5+(B5-C5)*1.5 |
| FRIDAY | 7 | 7 | =B6-C6 | =C6+(B6-C6)*1.5 |
| WEEKLY TOTAL | =SUM(E2:E6) | |||
- Use Excel formulas to calculate the Overtime Hour (Total - Regular) × 1.5
- Adjusted Total Hour = Regular + Overtime
- Calculate the Weekly Total using =SUM()
- Create a pie chart showing Day vs Adjusted Total Hour
- Print your spreadsheet and chart with your name and index number
