logo

Cambridge IGCSE Information and Communication Technology practice

Paper 1 structured question: Create a data model

Try the question first, then check the answer and practise the same topic again.

Attempt questionCreate a data model revisionRevise the key idea

At a glance

1

Paper

3

Marks

Topic

Create a data model

Exam-style question

Try this first

Paper 1Theory3 marks

Using cell references in spreadsheet calculations is crucial for dynamic data analysis.

Description

Cell References

Cell references can be absolute or relative, affecting how formulas behave when copied across cells.

  1. a

    Describe how absolute and relative cell references differ in a spreadsheet.

    Aim for approximately 3 distinct marking points.

    [3]

0 of 1 part answered

Answer every part before opening the mark scheme.

Common mistake

No common mistake is linked to this question yet.

Related flashcards

Flashcard 1 of 6

Press Space to flip, arrows to move

Related practice questions

Question 1 of 5

Choose an answer, get feedback, then move sideways through the set.

0 of 4 attempted

Paper 1 structured question: Create a data model

Paper 1Theory2 marks

Description

Spreadsheet Model Basics

A spreadsheet model consists of cells arranged in rows and columns. Users can perform calculations using formulas and functions, and manage data using various tools.

  1. a

    Explain the difference between a formula and a function in a spreadsheet.

    Aim for approximately 2 distinct marking points.

    [2]