This past question is created to help students better understand the concepts and structure of the Spreadsheet Management exam. Students can review the questions online or download them as a PDF for offline study. Note: The answers are only available on the website and not in the PDF version.
SECTION A: (50 MARKS)
1. Write the steps of hiding and unhiding rows and columns.
To hide: Select the rows/columns, right-click and choose "Hide". To unhide: Select surrounding rows/columns, right-click and choose "Unhide".
2. What is the function of spelling in the Review ribbon tab?
It checks and corrects spelling errors in the worksheet.
3. a. Function b. Formulas
a. A function is a predefined formula like SUM().
b. A formula is a user-defined expression to perform calculations, e.g., =A1+B1.
b. A formula is a user-defined expression to perform calculations, e.g., =A1+B1.
4. Symbols used in logical comparisons?
=, >, <, >=, <=, !=
5. What does the following do? a. Ctrl + Backspace b. Left arrow c. Right arrow
a. Shows active cell
b. Moves left
c. Moves right
b. Moves left
c. Moves right
6. Why assign a password to protect a workbook?
To prevent unauthorized changes or access.
7. How to save spreadsheet for the first time?
Click File > Save As > Choose location and file name > Save.
8. What is an argument in spreadsheets?
An argument is input value for functions, like =SUM(A1:A5) where A1:A5 is the argument.
9. IF statement syntax
=IF(condition, value_if_true, value_if_false)
10. Is the red line only for misspelt words?
No. Sometimes it highlights unknown terms or names not in dictionary.
SECTION B – PRACTICAL (50 MARKS)
DEVECOS IT SOLUTION PROVIDER – Mark Sheet for NVTI Exams
Instructions:
- Bold and center all column headings.
- Center the main title and subtitle. Title = font size 16, bold. Subtitle = font size 14.
- Calculate total marks for each student.
- Calculate average for each student.
- Insert index number and name in center footer.
- Insert a line chart showing Name vs Total Marks, with title "DEVECOS I.T.", font = CASTELLAR, size 22, bold.
| Index No. | Student Name | MS Word | MS Excel | MS PowerPoint | Internet | Total | Average |
|---|---|---|---|---|---|---|---|
| NVTI001 | John Mensah | 85 | 78 | 92 | 88 | ||
| NVTI002 | Abena Osei | 92 | 85 | 78 | 90 | ||
| NVTI003 | Kwame Asare | 78 | 82 | 85 | 80 | ||
| NVTI004 | Esi Boateng | 88 | 90 | 92 | 85 | ||
| NVTI005 | Yaw Appiah | 75 | 80 | 78 | 82 |