Grade IX • Information Technology

Spreadsheet Worksheet

Creating a Spreadsheet • Formulas & Functions • Formatting Data • Referencing • Charts

Maximum Marks: 20

Student Information

Name:
Class & Section:
Roll No.:
Date:

General Instructions

  1. Read each question carefully before answering.
  2. Attempt all questions.
  3. Use appropriate spreadsheet terminology.
  4. Write formulas with the correct syntax wherever required.
  5. Give suitable examples wherever required.
  6. The worksheet carries a total of 20 marks.

Topics Covered

  • Creating a Spreadsheet
  • Applying Formulas and Functions
  • Formatting Data in the Spreadsheet
  • Understanding and Applying Referencing
  • Creating and Inserting Charts

Section A – Objective Type Questions 5 Marks

1. Multiple Choice Questions

Questions 1–2: 1 × 2 = 2 Marks

1. Which symbol is generally used to begin a formula in LibreOffice Calc?

  • ☐ a) #
  • ☐ b) =
  • ☐ c) @
  • ☐ d) $

2. Which type of chart is most suitable for showing changes or trends over a period of time?

  • ☐ a) Line chart
  • ☐ b) Pie chart
  • ☐ c) Area of a cell
  • ☐ d) Text box

2. Fill in the Blanks

Questions 3–4: 1 × 2 = 2 Marks

3. The intersection of a row and a column in a spreadsheet is called a .

4. A cell reference that does not change when a formula is copied is called an reference.

3. True / False

Questions 5a–5b: 0.5 × 2 = 1 Mark

5a. The SUM function can be used to add a range of numbers.

Answer: ☐ True     ☐ False

5b. A relative cell reference remains unchanged when a formula is copied to another cell.

Answer: ☐ True     ☐ False

Section A Total: 5 Marks

Section B – Short Answer Type Questions 6 Marks

Questions 6–8: 2 × 3 = 6 Marks

6. What is a spreadsheet? Mention any two uses of a spreadsheet application.

7. What is the difference between a formula and a function in LibreOffice Calc? Give one example of each.

8. Differentiate between relative and absolute cell references with suitable examples.

Section B Total: 6 Marks

Section C – Long Answer Type Questions 9 Marks

Questions 9–11: 3 × 3 = 9 Marks

9. Explain how to create a spreadsheet in LibreOffice Calc. Describe how data can be entered into cells and how formulas and functions can be applied to perform calculations.

10. Explain relative, absolute and mixed cell referencing in a spreadsheet. Give a suitable example showing why different types of references are useful when copying formulas.

11. Explain the steps for creating and inserting a chart in LibreOffice Calc. Mention any three types of charts and state a suitable use for each.

Section C Total: 9 Marks

Spreadsheet Concept Reminders

Formula

A formula is an expression entered into a spreadsheet cell to perform a calculation. It normally begins with =.

Example: =B2+C2

Function

A function is a predefined formula that performs a particular calculation using supplied arguments.

Example: =SUM(B2:B10)

Cell Referencing

Cell referencing identifies the cells used in formulas. Common types include relative, absolute and mixed references.

Charts

Charts represent spreadsheet data graphically, making comparisons, patterns and trends easier to understand.

Types of Cell References

Type Example Behaviour when copied
Relative A1 Row and column references can change.
Absolute $A$1 Both row and column remain fixed.
Mixed $A1 or A$1 Either the column or the row remains fixed.

Useful Spreadsheet Functions

Function Purpose Example
SUM Adds values. =SUM(B2:B10)
AVERAGE Calculates the arithmetic mean. =AVERAGE(B2:B10)
MAX Returns the largest value. =MAX(B2:B10)
MIN Returns the smallest value. =MIN(B2:B10)
COUNT Counts cells containing numbers. =COUNT(B2:B10)

Formatting Checklist

  • Apply appropriate font and font size.
  • Use bold, italic or underline where appropriate.
  • Align headings and data appropriately.
  • Adjust column width and row height where necessary.
  • Apply suitable number, date or percentage formats.
  • Use borders and cell background formatting to improve readability.
  • Keep spreadsheet formatting consistent and purposeful.

Common Chart Types

Chart Type Suitable Use
Column Chart Comparing values across different categories.
Bar Chart Comparing categories, especially when category names are long.
Line Chart Showing trends or changes over time.
Pie Chart Showing parts of a whole as proportions.
Area Chart Showing trends while emphasising the magnitude of values.

Assessment Blueprint

Section Question Type Question Numbers Marks per Question Total Marks
A MCQ 1–2 1 × 2 2
A Fill in the Blanks 3–4 1 × 2 2
A True / False 5a–5b 0.5 × 2 1
B Short Answer 6–8 2 × 3 6
C Long Answer 9–11 3 × 3 9
Grand Total 20

Self-Check

Before submitting your worksheet:

  • Have you attempted all 11 questions?
  • Can you explain the difference between a formula and a function?
  • Can you distinguish relative, absolute and mixed references?
  • Can you identify an appropriate chart type for a given dataset?
  • Have you explained the steps for creating a chart?
  • Have you included appropriate spreadsheet examples?
  • Have you checked your calculations and presentation?