Skip to content
OtisamLMS
Sign in Sign up
Information and Communication Technology

Information and Communication Technology · Quick practice · answer shown after each question

Spreadsheets: cell referencing, formatting and data entry

Question 1 of 10

Question 1 of 10

Freeze Panes is used to

Question 2 of 10

Question 2 of 10

If B2 contains =A2*$E$1 and is copied to B3, the formula in B3 is

Question 3 of 10

Question 3 of 10

The reference A$1 is

Question 4 of 10

Question 4 of 10

Formatting a number as currency changes its actual value.

Question 5 of 10

Question 5 of 10

To refer to cell B2 on a sheet named "Term1" from another sheet, you write

Question 6 of 10

Question 6 of 10

The cell error #DIV/0! means

Question 7 of 10

Question 7 of 10

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

Question 8 of 10

Question 8 of 10

An absolute reference uses dollar signs.

Question 9 of 10

Question 9 of 10

Wrap Text in a cell

Question 10 of 10

Question 10 of 10

A relative reference stays exactly the same when copied.

Questions written by OtisamLMS in the style of the WASSCE. They are not WAEC past questions.