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.

At a glance

1

Paper

2

Marks

Topic

Create a data model

Exam-style question

Try this first

Paper 1Theory2 marks

Spreadsheet models are used to organize and analyze data efficiently.

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]

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 1Theory3 marks

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]