Spreadsheets: cell referencing, formatting and data entry

Question 1 of 10

The reference A$1 is

Question 2 of 10

The small square used to drag and copy formulas is the fill ___.

Question 3 of 10

The key that cycles through relative and absolute references while editing a formula in Excel is

Question 4 of 10

Typing "Jan" and dragging the fill handle across produces

Question 5 of 10

##### in a cell usually means the column is too narrow.

Question 6 of 10

Explain how data validation can reduce errors when entering pupils' marks.

Question 7 of 10

State five ways to format a spreadsheet to make it easier to read.

Question 8 of 10

Formatting a number as Currency (GH₵)

Question 9 of 10

Describe how to use conditional formatting to highlight marks below 50 in red.

Question 10 of 10

Conditional formatting is used to