Information and Communication Technology

Question 1

1The chart best for showing a trend over time is a

Easy

A. organisation chart B. pie chart C. line graph D. doughnut chart

Question 2

2To show only students who scored above 50, you would use a

Easy

A. chart B. border C. filter D. font

Question 3

3Filtering a list of students so that only those in Form 2 show is done with

Easy

A. a chart B. a filter C. a macro virus D. a hyperlink

Question 4

4Sorting data from A to Z is sorting in

Easy

A. reverse order B. random order C. descending order D. ascending order

Question 5

5Which chart best shows how each part makes up a whole, such as shares of a budget?

Easy

A. scatter chart B. line chart C. pie chart D. histogram

Question 6

6The chart best for showing parts of a whole is a

Easy

A. scatter plot B. pie chart C. histogram D. line graph

Question 7

7=COUNTIF(A1:A10, ">50") counts

Easy

A. all cells B. blank cells C. cells in A1:A10 with values greater than 50 D. cells equal to 50

Question 8

8Sorting names from A to Z is sorting in

Easy

A. ascending order B. reverse order C. descending order D. random order

Question 9

9A filter in a spreadsheet

Easy

A. shows only the rows that meet a condition B. adds colours C. deletes data D. creates a chart