Skip to main content
Super TutorResources
Chapter 2 of 7
Concept Maps

Spreadsheets: Functions and Charts — Concept Maps

ICSE · Class 8 · Computer Studies

4 concept maps of Spreadsheets: Functions and Charts for ICSE Class 8 Computer Studies, each also written out as a text outline.

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 concept maps and more.

Try Super Tutor — Free

Free trial, no card needed.

4 Concept Maps

Spreadsheet Functions and Charts - Complete Overview

Spreadsheet Functions and Charts - Complete Overview

The map in words

  • root((Spreadsheets:
  • Functions and Charts))
    • Cell Basics
      • Cell Address
        • Column Letter
        • Row Number
      • Active Cell
      • Cell Range
    • Selecting Ranges
      • Rows
        • Entire Row
        • Consecutive Rows
        • Non-Consecutive Rows
      • Columns
        • Entire Column
        • Consecutive Columns
        • Non-Consecutive Columns
      • Range in Rows and Columns
    • Worksheet Management
      • Sheet Tabs
      • Naming Sheets
      • Renaming Sheets
      • Deleting Sheets
    • Cell References
      • Relative Referencing
        • Changes with Copy
      • Absolute Referencing
        • Dollar Signs
        • Stays Fixed
      • Mixed Referencing
        • Partial Absolute
    • Mathematical Functions
      • SUM
        • Adds Values
      • AVERAGE
        • Mean Value
      • MAX
        • Highest Value
      • MIN
        • Lowest Value
      • COUNT
        • Counts Numbers
    • Charts
      • Creating Charts
        • Select Data
        • Choose Type
        • Insert
      • Chart Types
        • Column Chart
        • Bar Chart
        • Pie Chart
        • Line Chart
      • Chart Elements
        • Title
        • Axis Labels
        • Legend
      • Customizing
        • Colors
        • Styles
        • Fonts
      • Editing
        • Update Data
        • Change Type

Spreadsheets: Functions and Charts — Chapter Overview

Spreadsheets: Functions and Charts — Chapter Overview

The map in words

  • root((Spreadsheets
  • Functions and Charts))
    • Range of Cells
      • Cell Address
        • Column Letter + Row Number
        • Example A1 B3 F7
      • Active Cell
        • Default is A1
        • Dark border around it
      • Selecting Rows
        • Single Row
        • Consecutive Rows
        • Non-Consecutive Rows with Ctrl
      • Selecting Columns
        • Single Column
        • Consecutive Columns
        • Non-Consecutive Columns with Ctrl
    • Sheet Tab
      • Located at Bottom Left
      • Default Sheet1
      • Rename by Double Click
      • Delete by Right Click
      • Add using Plus Button
    • Cell Referencing
      • Relative
        • Address Changes on Copy
        • Default Type
        • Example SUM C4 to E4
      • Absolute
        • Address Fixed
        • Uses Dollar Sign
        • Example Dollar F Dollar 3
      • Mixed
        • Part Fixed Part Relative
        • Example Dollar B 3 or B Dollar 4
    • Functions
      • SUM
        • Adds all values
      • AVERAGE
        • Finds mean
      • MAX
        • Highest value
      • MIN
        • Lowest value
      • COUNT
        • Counts numeric cells only
    • Charts
      • Types
        • Column Chart
        • Bar Chart
        • Line Chart
        • Pie Chart
      • Create
        • Select Data
        • Insert Tab
        • Choose Chart Type
      • Edit
        • Add Chart Title
        • Add Axis Title
        • Change Chart Type
        • Update Data

Spreadsheets Functions and Charts - Complete Overview

Spreadsheets Functions and Charts - Complete Overview

The map in words

  • Spreadsheets Functions and Charts
    • Cell Management
      • Cell Address
        • Column Letter
        • Row Number
      • Ranges
        • Continuous Ranges
        • Non-continuous Ranges
      • Selection Methods
        • Single Cells
        • Rows and Columns
        • Ranges
    • Sheet Organization
      • Sheet Tabs
      • Naming Sheets
      • Deleting Sheets
      • Multiple Sheets in Workbook
    • Cell Referencing
      • Relative References
        • Changes when copied
        • Example A1
      • Absolute References
        • Fixed with $
        • Example $A$1
      • Mixed References
        • Partial absolute
        • Example $A1 or A$1
    • Functions
      • SUM Function
        • Adds values
        • SUM range
      • AVERAGE Function
        • Calculates mean
        • AVERAGE range
      • MAX Function
        • Finds highest
        • MAX range
      • MIN Function
        • Finds lowest
        • MIN range
      • COUNT Function
        • Counts numbers
        • COUNT range
    • Chart Creation
      • Data Selection
        • Range selection
        • Include headers
      • Chart Types
        • Column Charts
        • Bar Charts
        • Pie Charts
        • Line Charts
      • Chart Elements
        • Title
        • Axis Labels
        • Legend
        • Gridlines
      • Customization
        • Design Tab
        • Format Tab
        • Colors Styles

Spreadsheets: Functions and Charts

Spreadsheets: Functions and Charts

The map in words

  • Spreadsheets: Functions and Charts
    • Range of Cells
    • Cell Referencing
    • Relative Referencing
    • Absolute Referencing
    • Mixed Referencing
    • Functions
    • SUM()
    • AVERAGE()

Explore these maps interactively

Explore Diagrams

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.
What do the concept maps for Spreadsheets: Functions and Charts show?
The 4 maps show how the ideas in Spreadsheets: Functions and Charts connect: Spreadsheet Functions and Charts - Complete Overview; Spreadsheets: Functions and Charts — Chapter Overview. Each map is also written out as an outline on this page.
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 Concept Maps

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