O-Level Computing (7155) Spreadsheets and Data Processing quiz: cells and formulae, functions, references, IF and VLOOKUP, charts quiz

Into folders and files

Into packets and protocols

Into cells arranged in rows and columns

Into registers and the ALU

A hash sign

A full stop

A dollar sign

An equals sign

=A1+B1

A1+B1

=SUM A1 B1

ADD(A1,B1)

SUM

AVERAGE

COUNT

MAX

The total of the values in B2 to B10

The largest value in B2 to B10

How many cells in B2 to B10 contain numbers

The average of B2 to B10

It stays as A2

It becomes blank

It changes to B2

It changes to A3

They make the reference absolute so it does not change when the formula is copied

They convert the value to currency

They delete the contents of A1

They turn A1 into a chart

When each copy of the formula should point to its own row of data

When every copy of the formula must keep pointing to one fixed cell, such as a single rate

When you never plan to copy the formula

When the cell contains text instead of a number

=A2*$E$1

=A3*$E$1

=A3*$E$2

=A2*$E$2

Adds two ranges together

Sorts the data into order

Returns one value when a condition is true and another when it is false

Draws a chart automatically

Counts how many cells are empty

Encrypts the spreadsheet

Reverses the order of a list

Searches the first column of a table and returns a value from another column in the same row

So the formula can be copied down a column without the table reference drifting

So the result is shown as currency

So the lookup runs faster

So the table is deleted after use

Pie chart

Line chart

Bar chart of unrelated categories

No chart can show change over time

To permanently delete records

To show only the records that meet a condition

To change all references to absolute

To convert numbers to text