Armstrong Computers College · Exam Preparation Resource
This comprehensive past question resource helps students prepare effectively for their upcoming Spreadsheet Management exams. Click on each question to reveal the answer instantly.
To download the complete question set, please support our work with any amount. Your contribution helps us create more educational resources.
To add a column: Right-click on the column letter > Insert.
To delete a row: Right-click on the row number > Delete.
Range Operator (colon): A1:A5 selects all cells from A1 to A5.
Union Operator (comma): A1, A3, A5 selects specific non-adjacent cells.
Select cells to print > Page Layout tab > Print Area > Set Print Area.
Sheet tab shows the name of the worksheet. Actions: Rename, Move/Copy, Delete.
- Save
- Undo
- Redo
- Quick Print
Enter a value in the first cell > Drag the fill handle across or down to fill other cells.
It returns the current date from your computer's system clock.
AutoSum automatically adds a column or row of numbers using the SUM function.
Click the cell below and right of the rows and columns to freeze > View tab > Freeze Panes.
- Text
- Number
- Date/Time
- Boolean (TRUE/FALSE)
- Currency
SECTION B – PRACTICALS
Joshua was given an amount of GH¢500.00 to purchase items from Kaneshie Market. Use the instructions below to complete the task.
- Create a spreadsheet with the following entries and save as your Name and Index Number.
| ITEM | QUANTITY | UNIT PRICE (GH¢) | TOTAL PRICE (GH¢) |
|---|---|---|---|
| Okro | 4 | 3.5 | |
| Plantain | 3 | 15.00 | |
| Gari | 5 | 30.00 | |
| Garden Eggs | 4 | 5.00 | |
| Cassava | 20 | 0.25 | |
| Milk | 3 | 5.00 | |
| Sugar | 2 | 4.00 | |
| GRAND TOTAL (GH¢) | |||
- Calculate the total price for items listed using Quantity × Unit Price.
- Calculate for the GRAND TOTAL using the SUM function.
- Find the balance: =500 - [GRAND TOTAL]
- Insert a multiple column bar chart showing ITEM and TOTAL PRICE.
- Print your work.
Support Our Educational Resources
Enter any amount you wish to contribute to download the past questions:
