logo

Cambridge IGCSE Information and Communication Technology practice

Which of the following is an example of an absolute cell reference?

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

Show answerCreate a data model revisionRevise the key idea

At a glance

MCQ

Type

cambridge_mcq

Style

Topic

Create a data model

Exam-style question

Try this first

Which of the following is an example of an absolute cell reference?.

  1. A.A1
  2. B.$A$1
  3. C.A$1
  4. D.$A1

Answer and explanation

Attempt the question first, then reveal the model answer and explanation.

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 3 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]