Spreadsheet Management (Level 2 & 3) – Past Questions & Answers
Complete solutions to both theory and practical Microsoft Excel examination questions. Click each question below to reveal the answer.
Spreadsheet Management (Level 2 & 3) – November/December 2025
Subject: Spreadsheet Management
Examination Level: Level 2 & 3
This article contains the complete theory answers for Section A, a step-by-step explanation of Section B (Practical), a practical video lesson, and a downloadable PDF of the past questions.
Whether you're a student preparing for your exams or an instructor looking for reference material, this guide will help you understand the concepts and improve your practical spreadsheet skills.
SECTION A – THEORY QUESTIONS
1(a). State the uses of a Text Box.
A Text Box is used to:
- Add text anywhere on a worksheet.
- Insert titles, comments, labels and instructions.
- Add explanatory notes to charts and diagrams.
1(b). Outline the steps of showing a formula in Microsoft Excel.
- Open the worksheet.
- Click the Formulas tab.
- Select Show Formulas.
Shortcut: Press Ctrl + `
2(a). State the two page orientations and explain them.
Portrait: The page is taller than it is wide.
Landscape: The page is wider than it is tall.
2(b). Which page orientation is the default in Excel?
Portrait Orientation
3(a). What is a Chart?
A chart is a graphical representation of worksheet data used to make comparisons and analysis easier.
3(b). Explain the axes of a 3D Chart.
- X-Axis: Category Axis
- Y-Axis: Value Axis
- Z-Axis: Series/Depth Axis
4(a). What is Split Window?
Split Window divides a worksheet into multiple panes so different parts of the worksheet can be viewed simultaneously.
4(b). State the steps in applying Split Window.
- Select the desired cell.
- Click View.
- Click Split.
5(a). Explain Freeze Panes.
Freeze Panes keeps selected rows or columns visible while scrolling.
5(b). Freeze only the first three columns.
- Select cell D1.
- Click View.
- Click Freeze Panes.
- Select Freeze Panes.
6(a). Explain What-If Analysis.
What-If Analysis allows users to test different values to see how they affect formula results.
6(b). Mention the three What-If Analysis tools.
- Goal Seek
- Scenario Manager
- Data Table
7(a). Define Header.
A Header is information printed at the top of every worksheet page.
7(b). Steps to insert a Header.
- Insert Tab
- Header & Footer
- Click Header
- Type the required text.
8(a). Explain Goal Seek.
Goal Seek finds the input value needed to achieve a desired formula result.
8(b). Goal Seek is also known as?
Backward Calculation (or What-If Analysis Tool)
9(a). Explain Copy and Paste.
Copy duplicates selected data while Paste places it in another location.
9(b). Explain Cell Referencing.
Cell referencing allows formulas to automatically use and update values from other cells.
Example: =A2+B2
10. Explain AutoSum with an example.
AutoSum automatically inserts the SUM function.
Example: =SUM(A1:A5)
If A1:A5 contains: 100, 200, 300, 400, 500
Result: 1500
SECTION B – PRACTICAL
Practical Question
Reproduce the worksheet below in Microsoft Excel.
| Years | January | February | March | April | May | June | Jan–June |
|---|---|---|---|---|---|---|---|
| 2001 | 2,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 6,000.00 | 1,500.00 | |
| 2002 | 2,500.00 | 1,200.00 | 8,000.00 | 2,000.00 | 5,000.00 | 2,500.00 | |
| 2003 | 3,000.00 | 1,800.00 | 1,600.00 | 3,000.00 | 4,000.00 | 3,500.00 | |
| 2004 | 3,500.00 | 2,200.00 | 3,200.00 | 4,000.00 | 3,000.00 | 4,500.00 | |
| 2005 | 2,000.00 | 2,000.00 | 2,300.00 | 2,200.00 | 2,300.00 | 2,400.00 | |
| 2006 | 4,000.00 | 2,400.00 | 6,400.00 | 5,000.00 | 2,000.00 | 6,500.00 | |
| 2007 | 4,500.00 | 2,800.00 | 1,280.00 | 6,000.00 | 1,000.00 | 7,500.00 | |
| 2008 | 5,000.00 | 3,200.00 | 4,000.00 | 7,000.00 | 7,000.00 | 8,500.00 | |
| 2009 | 5,500.00 | 3,400.00 | 1,200.00 | 8,000.00 | 8,000.00 | 9,500.00 | |
| 2010 | 6,000.00 | 4,000.00 | 7,400.00 | 9,000.00 | 9,000.00 | 9,800.00 |
Required Formulas
=SUM(B2:G2)/4
=SUM(B2:B11)
=AVERAGE(B2:B11)
=MAX(B2:B11)
=MIN(B2:B11)
Practical Tasks
- Reproduce the worksheet exactly as shown.
- Format all values to 2 decimal places.
- Calculate the missing values using formulas.
- Bold all calculated values.
- Create a Column Chart on a new worksheet.
- Use the title: MONTHLY SALES FOR 6 MONTHS
- Label the Horizontal Axis as Months.
- Label the Vertical Axis as Sales (GH₵).
- Round the TOTAL row to 0 decimal places.
- Print the worksheet.
- Display the formulas (Ctrl + `) and print again.
Practical Video Lesson
Watch the complete Microsoft Excel practical tutorial for Section B below.
Download Past Question
Want the original examination paper? Click the button below.
Before Your Download Begins...
To support the creation of more free solved past questions and practical lessons, kindly subscribe first.
Get access to:
- Solved Past Questions
- Practical Video Tutorials
- Microsoft Excel Lessons
- Spreadsheet Management Notes
Subscribe to our YouTube Channel
Click the button below to subscribe – your download will start automatically after subscription.
Conclusion
This lesson covers both the Microsoft Excel theory and practical examination questions. Practice each formula, reproduce the worksheet accurately, and complete the chart exercise to strengthen your Excel skills. If you found this guide helpful, watch the accompanying practical video and download the past questions for additional practice.
Join Our Tech Family
Get new lessons, tech tips, and updates directly on your phone. Be part of our growing IT community, never miss a tutorial or Windows tip!
World Class IT Solutions Across the Globe.
Empowering Businesses, Students & Organizations with World Class IT Solutions Across the Globe.
USA
UK
Canada
Australia
Germany
France
India
Nigeria
Ghana
Kenya
South Africa
Brazil
Mexico
Japan
China
Russia USA UK Canada Australia Germany France India Nigeria Ghana Kenya South Africa Brazil Mexico Japan China RussiaOur Other Plans
Explore our professional services tailored to meet your business needs. Click "Get a Quote" to start a conversation on WhatsApp.
Front-End Development
Responsive UIs, interactive components, modern frameworks & performance.
Get a QuoteOur Services Membership Plans
Get instant access to the full script library — activate online in minutes, no waiting. Choose the plan that fits your needs and unlock premium resources, source code, and commercial licenses.
VIP MEMBERSHIP
One Plan. Every Script. Full Source Code.
Instead of buying scripts one by one, get access to everything — every template and source code we have built, plus everything we ship in the future. One plan, no restrictions.
- Full Script Library
- Complete Source Code
- Future Scripts Included
- 6 Months Direct Support
PHP + Apps Script
- Full Access — PHP & Apps Script projects
- Step-by-step video guides
- Commercial-use license
- AI Prompts included — Free
- Ready-to-use projects
- Bug fixes & free future updates
- Future video releases auto added
- Installation help included
- No recurring charges
- 1 downloads/day
- Full source code access
- Files you download stay yours for lifetime
- Resale rights included
- Modification rights included
- 24/7 WhatsApp support
PHP + Apps Script
- Full Access — PHP & Apps Script projects
- Step-by-step video guides
- Commercial-use license
- AI Prompts included — Free
- Ready-to-use projects
- Bug fixes & free future updates
- Future video releases auto added
- Installation help included
- No recurring charges
- 2 downloads/day
- Full source code access
- Files you download stay yours for lifetime
- Resale rights included
- Modification rights included
- 24/7 WhatsApp support
PHP + Apps Script
- Full Access — PHP & Apps Script projects
- Step-by-step video guides
- Commercial-use license
- AI Prompts included — Free
- Ready-to-use projects
- Bug fixes & free future updates
- Future video releases auto added
- Installation help included
- No recurring charges
- 3 downloads/day
- Full source code access
- Files you download stay yours for lifetime
- Resale rights included
- Modification rights included
- 24/7 WhatsApp support
Languages & Technologies We Work With
Core competencies and the business problems each one solves. From automation to full-stack solutions, these tools power our services.
