This blog post presents a breakdown of the November/December 2008 Level 1 Spreadsheet Management exam questions. It serves as a learning tool for students preparing for NVTI exams and gaining mastery in Microsoft Excel. This resource was created by Armstrong Computers College to make learning accessible and practical, helping students build essential skills in spreadsheet design and analysis.
Armstrong Computers – Where vision meets excellence.
SECTION A – Theory Questions
1. What is meant by the term spreadsheet?
A spreadsheet is an electronic document used to organize, calculate, and analyze data in tabular form using rows and columns.
2. Explain the difference between worksheet and workbook.
A worksheet is a single sheet within a workbook; a workbook is the complete Excel file that may contain multiple worksheets.
3. What is auto format?
Auto Format is a feature that applies a predefined set of formatting (fonts, borders, colors) to a selected range in a spreadsheet.
4. Mention and describe THREE (3) types of charts in electronic spreadsheet.
Bar Chart – displays data using rectangular bars. Line Chart – shows trends over time using lines. Pie Chart – represents parts of a whole as slices of a circle.
5. What is a chart Wizard?
Chart Wizard is a step-by-step tool that helps users create and customize charts easily in Excel.
6. How can you protect a worksheet?
By going to Review → Protect Sheet, you can set a password to prevent changes to specific parts of a worksheet.
7. What is a cell?
A cell is the intersection of a row and a column in a spreadsheet where data is entered (e.g., A1).
8. What are logical operators? Give THREE (3) examples.
Logical operators are symbols used in formulas to compare values. Examples: =, >, <
SECTION B – Practical (Spreadsheet Task)
Using Microsoft Excel, perform the following steps to analyze employment data:
| Job Category | 2006 | 2007 | % Change |
|---|---|---|---|
| Fishing | 2141 | 2200 | =(C2-B2)/B2 |
| Farming | 4330 | 6421 | =(C3-B3)/B3 |
| Transport | 5400 | 6500 | =(C4-B4)/B4 |
| Retail | 1350 | 4350 | =(C5-B5)/B5 |
| Services | 185 | 200 | =(C6-B6)/B6 |
- Create the above worksheet in Excel.
- Format columns 2006 and 2007 to display commas with no decimal places.
- In the "% Change" column, calculate the percentage increase from 2006 to 2007 using:
=(New - Old)/Old - Format the "% Change" as a percentage with 1 decimal place.
- Insert a pie chart to represent "Job Category vs % Change".
- Save the file as JOB and print your work.