MAY JUNE 2012 LEVEL: TWO SPREADSHEET MANAGEMENT

16 Jun 2025
Prince Armstrong
Tech Questions & Answers

Master your Spreadsheet Management skills with this comprehensive exam preparation resource featuring actual questions from the May/June 2012 examination. This interactive guide helps Armstrong Computers College students:

Test your knowledge with click-to-reveal answers
Understand core spreadsheet concepts through clear explanations
Prepare efficiently with authentic exam-style questions
Practice real-world skills with practical exercises

Exam Success Tips

Focus on understanding formulas, cell references, and data visualization techniques - these account for over 60% of typical spreadsheet exam questions.

Note: The downloadable PDF version contains questions only. Answers are exclusively available in this interactive format to encourage active recall - the most effective learning technique.

1. Define Electronic Spreadsheet

An electronic spreadsheet is a software application used for data entry, calculation, and analysis using a grid of rows and columns (e.g., Microsoft Excel).

2. Differentiate between Row and Column in spreadsheet.

Row: Runs horizontally and is identified by numbers.
Column: Runs vertically and is identified by letters.

3. What is a cell?

A cell is the intersection of a row and a column where data is entered in a spreadsheet.

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

What-if analysis is a technique used to determine how changing values in a spreadsheet affects the outcome of formulas.

5. Describe WYSIWYG in spreadsheet.

WYSIWYG (What You See Is What You Get) means the printout will match what is displayed on the screen.

6. What is a formula in spreadsheet?

A formula is an expression used to perform calculations in a spreadsheet, e.g., =SUM(A1:A5).

7. Describe the two types of cell entries.

1. Label (Text)
2. Value (Numeric or formula-based)

8. What is the file extension of excel files?

The default Excel file extension is .xlsx

9. How can you form an excel filename?

Use letters, numbers, underscores, and dashes. Avoid special characters like /, *, \.

10. What is automatic recalculation?

Automatic recalculation is a feature where Excel updates formula results instantly when data changes.

SECTION B – PRACTICAL

Apply your spreadsheet skills to this realistic data analysis task. Follow the instructions carefully to format, calculate, and visualize food quantity data for April and May.