Information and Communication Technology

Question 1

1Freeze Panes is used to

Medium

A. delete rows B. lock a password C. keep headings visible while scrolling D. stop the computer

Question 2

2Conditional formatting can colour cells automatically based on their value.

Easy

A. True B. False

Question 3

3The reference A$1 is

Hard

A. invalid B. a mixed reference with the row fixed C. fully relative D. fully absolute

Question 4

4A spreadsheet file containing several sheets is a ___.

Easy

Your answer (fill in the blank)

Question 5

5A workbook can contain several worksheets.

Easy

A. True B. False

Question 6

6The display ##### in a cell usually means

Easy

A. the column is too narrow to show the number B. there is a virus C. the file is corrupt D. the formula is wrong

Question 7

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

Easy

A. True B. False

Question 8

8The error #NAME? appears when

Medium

A. a function or name in the formula is not recognised B. a value is missing in a lookup C. dividing by zero D. the column is narrow

Question 9

9A relative cell reference such as A1

Medium

A. never changes when copied B. always refers to the first sheet C. changes when the formula is copied to another cell D. is a text value

Question 10

10The fill handle is used to

Easy

A. delete a cell B. copy formulas or continue a series by dragging C. insert a chart D. print a sheet