Computer Studies Practice Tests – Spreadsheet

Study the MS Excel worksheet below and use it to answer the question that follow:



In what cell is Victor Umoh’s assignment score?

A. D      B. D5    C. D6     D. E5

Spreadsheet packages can be used for the following except _________ (NECO 2016)

A. annual reports of business firm.      B. banking.      C. budgeting.      D. letter writing

The symbol of the tool for enlarging a cell’s width in MS Excel is _______ (WASSCE 2014)

The MS Excel worksheet below shows the salary distribution for four staff of a company. The net salary is paid after deductions have been made.



Which of the following formulas would be used to obtain the value in cell E2? (WASSCE 2016)

A. =B2+C2-D2       B. =B2+C2+D2       C. (B2+C2+D2)/3       D. =C2-D2

Study the MS Excel worksheet below and use it to answer the question that follow:



The highest total score was obtained by _______?

A. Ade Olu      B. Victor Umoh     C. Obi Chidi     D. Ola Bisi