Computer Studies Practice Tests – Spreadsheet (Questions with Answers and Explanations)

By default, numeric values in worksheet are _______ (WASSCE 2019)

A. centered      B. left-aligned      C. right-aligned      D. unaligned

The Table below is a part of MS Excel worksheet which shows the marks obtained by some students in an examination.

What is the sum total of the total score for Anene Lorreta, Eneh Grace and Bakare Iman is _______

The Table below is a part of MS Excel worksheet which shows the marks obtained by some students in an examination.   



Which of the following formulas would calculate the average score of the students in Mathematics? (WASSCE 2018)

A. =Average(C2:C6)       B. =Average(C2:F2)       C. =Average(C1:C6)       D. Average(C1:F1)

The merge button in Spreadsheet application is used to _______ (WASSCE 2020)

A. combine adjacent tables
B. convert selected cells into a single cell
C. merge two tables
D. split a cell into two or more cells

The Table below is a part of MS Excel worksheet which shows the marks obtained by some students in an examination.

The third position goes to _______