Prepare for your Spreadsheet Management exam with these comprehensive MAY/JUNE 2023 Level 2 past questions and answers.
This past question is created to help students better understand the concepts and format of the Spreadsheet Management exam.
SECTION A: (50 MARKS)
1. State the difference between a Worksheet and Workbook.
A worksheet is a single spreadsheet page within Excel, while a workbook is the entire file that contains one or more worksheets.
2. What is 'Wrap text' function as used in MS-Excel?
Wrap text allows the contents of a cell to be displayed on multiple lines if it's too long to fit in the cell width.
3. a. State the other name for "cell reference".
b. Identify the column and row of cell "SRC2021".
b. Identify the column and row of cell "SRC2021".
a. Another name is "cell address."
b. Column = SRC, Row = 2021
b. Column = SRC, Row = 2021
4. Explain the term 'Range' as used in Excel.
A range is a group of selected cells in a spreadsheet, e.g., A1:A10 or B2:D6.
5. Name the TWO ways data in Excel can be sorted.
Data can be sorted in Ascending order and Descending order.
6. What is the default alignment for: a. Text b. Numbers
a. Text = Left aligned
b. Numbers = Right aligned
b. Numbers = Right aligned
7. What is the order of sequence of mathematical operations in Excel?
The order is: Parentheses, Exponents, Multiplication/Division, Addition/Subtraction (PEMDAS).
8. State the THREE data forms that can be entered in Excel.
Numbers, Text, and Formulas.
9. To move to a designated cell, you press ………………….
Press Ctrl + G or use the Name Box to go to a specific cell.
10. To know the last row in Excel, you press …………………
Press Ctrl + ↓ (down arrow).
SECTION B: PRACTICAL (50 MARKS)
A loan officer of a Rural Bank has the following records for field loan installments collection on 23/06/2021. The Rural Bank tasks you to create an Excel tool based on the details below:
| NO | CLIENT NAME | LOAN(P+1) | BAL | DURATION(Months) | PAID MONTHS | INSTALMENT | PAYMENT DATE | DAYS LATE |
|---|---|---|---|---|---|---|---|---|
| 6904 | FELLA VENTURE | 12,000.00 | 6 | 5 | 23-JUN-21 | |||
| 6996 | ABIGAIL AGBEDENU | 2,200.00 | 4 | 0 | 23-JUN-21 | |||
| 7302 | JOHN NANA KUSI | 5,360.00 | 8 | 2 | 17-JUN-21 | |||
| 7510 | AKWASI GYIMAH | 1,125.00 | 5 | 0 | 23-JUN-21 | |||
| 9791 | GRACE KOOMSON | 8,780.00 | 10 | 5 | 23-JUN-21 | |||
| 9846 | CHRIST ENTERPRISE | 19,895.00 | 10 | 9 | 01-JUN-21 |
- Installments = Loan amount / Duration
- Format amounts to 2 decimal places and date to dd-mm-yy format
- Loan Balance = (Duration - Paid Months) × Installment
- Days Late =
=TODAY() - [Payment Date]
Formatting: Use Times New Roman, 12pt font size.
