Sign in Sign up free

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

Spreadsheets: charts, sorting and filtering

Question 1 of 9

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

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

Question 2 of 9

Sorting data from A to Z is sorting in

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

Question 3 of 9

A filter in a spreadsheet

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

Question 4 of 9

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

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

Question 5 of 9

Sorting names from A to Z is sorting in

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

Question 6 of 9

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

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

Question 7 of 9

The chart best for showing parts of a whole is a

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

Question 8 of 9

The chart best for showing a trend over time is a

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

Question 9 of 9

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

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

Score so far

0 / 0

Answered0 / 9

1 2 3 4 5 6 7 8 9

New set of questions

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

Past questions, worked solutions and curriculum-mapped study material for JHS and SHS students and teachers in Ghana.

Learn

About