Skip to main content
Super TutorResources
Chapter 2 of 7
Syllabus

Spreadsheets: Functions and Charts — Syllabus

ICSE · Class 8 · Computer Studies

What Spreadsheets: Functions and Charts covers in ICSE Class 8 Computer Studies: 4 topics, for the 2026-27 session.

45 questions34 flashcards7 formulas & key relations5 concepts

Interactive on Super Tutor

Studying Spreadsheets: Functions and Charts? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for syllabus and more.

Try Super Tutor — Free

Free trial, no card needed.

4 Topics · ICSE Class 8 Computer Studies · 2026-27

Topics in Spreadsheets: Functions and Charts

1

Cells, Active Cell, and Range of Cells

  • A cell is the smallest unit of a worksheet formed at the intersection of a row and column.
  • The address of a cell consists of the column letter followed by the row number.
  • The active cell is the cell in which the cell pointer is located in a worksheet.
2

Selecting Rows, Columns, and Ranges

  • An entire row can be selected by clicking its row header.
  • An entire column can be selected by clicking its column header.
  • Multiple consecutive rows or columns can be selected by dragging with the mouse.
3

Sheet Tab and Worksheet Management

  • In MS Excel, the tab which displays various worksheets in a workbook is called the Sheet Tab.
  • The Sheet Tab is located at the bottom left corner of the excel window.
  • By default, the system displays only one sheet named Sheet1.
4

Cell Referencing

  • Using a cell address in a formula is known as cell referencing.
  • There are three types of cell referencing: relative, absolute, and mixed.
  • Relative referencing uses the relative position of a cell in a formula.

Key Concepts

Central concept: Spreadsheets: Functions and Charts

Range of CellsCell ReferencingRelative ReferencingAbsolute ReferencingMixed ReferencingFunctionsSUM()AVERAGE()

Work through every topic in Spreadsheets: Functions and Charts with notes and quizzes

Start This Chapter

Frequently Asked Questions

What are the important topics in Spreadsheets: Functions and Charts for ICSE Class 8 Computer Studies?
Key topics in Spreadsheets: Functions and Charts include Cells, Active Cell, and Range of Cells, Selecting Rows, Columns, and Ranges, Sheet Tab and Worksheet Management, Cell Referencing. Study these first, then practise questions on each for Class 8 exams.
How should I revise Spreadsheets: Functions and Charts for Class 8 exams?
Learn the core ideas first, then work through the 45 practice questions on Spreadsheets: Functions and Charts. Revise definitions regularly and use flashcards for quick recall before the exam.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

More resources for Spreadsheets: Functions and Charts

All ICSE Class 8 Computer Studies Syllabus

For serious students

Get the full Spreadsheets: Functions and Charts chapter — start free.

Quizzes, flashcards, an AI doubt solver and a study plan for ICSE Class 8 Computer Studies. Free to start, no card needed.

Try Super Tutor Free
Try this chapter free