May/June 2012 Level Two – Spreadsheet Management

Welcome to Armstrong Computers College, where vision meets excellence. In this post, we focus on the May/June 2012 Level Two Spreadsheet Management exam paper. This resource is designed to help students better understand spreadsheet-based exams and practice practical tasks in Microsoft Excel.

Our mission is to bring high-quality computer training to students ready to build real-world ICT skills and enhance their career potential. Let's dive into both theory and practical sections of this past question to strengthen your preparation.

SECTION A – Theory Questions

1. Define Electronic Spreadsheet

An electronic spreadsheet is a software application (e.g., Microsoft Excel) used for organizing, analyzing, and storing data in tabular form using rows and columns.

2. Differentiate between Row and Column in Spreadsheet

A row runs horizontally (numbered 1, 2, 3...), while a column runs vertically (labeled A, B, C...).

3. What is a cell?

A cell is the intersection of a row and column, used to input and store data.

4. Explain what is meant by what-if analysis.

It is a process to test different scenarios by changing input values in formulas to see how they affect the output.

5. Describe WYSIWYG in spreadsheet

WYSIWYG means "What You See Is What You Get"—what appears on screen is how it will look when printed.

6. What is a formula in spreadsheet?

A formula is an equation used to perform calculations using cell values (e.g., =A1+B1).

7. Describe the two types of cell entries

Labels (text) and values (numbers or formulas).

8. What is the file extension of Excel files?

.xlsx for Excel 2007 and newer, and .xls for older versions.

9. How can you form an Excel filename?

Use letters, numbers, underscores (e.g., Sales_Report_2022.xlsx). Avoid special characters like / \ : * ? " < > |.

10. What is automatic recalculation?

It means Excel automatically updates formula results whenever a referenced cell value changes.

SECTION B – Spreadsheet Practical Tasks (Excel)

Instructions: Complete the following practical tasks in Microsoft Excel:

Open Microsoft Excel and enter this data:

TYPE         QUANTITY
             APRIL  MAY   
Banku       | 3500
Fufu        | 1475
Yam         | 3200
Kokonte     | 4200
Plantain    | 3200
Rice        | 6500
Tuwo        | 3215        
Total

Create a new column labeled May
Calculate May quantities using 12.5% increase over April:
Example Formula: =B2 * 1.125 and drag down
Apply borders around the table (Home > Borders)
Insert a Bar Chart comparing April and May figures
Save your workbook using a meaningful name (e.g., Spreadsheet2012)
Print your data and chart together