Spreadsheets Question Paper
Spreadsheets
Course:Secondary Level
Institution: Mock question papers
Exam Year:
1) Define spreadsheet (2mks)
2) what is an electronic spreadsheet ? (2mks)
3) state four advantages of an electronic spreadsheet over manual spreadsheets (4mks)
4) explain three components of spreadsheet. (3mks)
5) state and explain five application areas of spreadsheet (10mks)
6) what is forecasting ? And how can a spreadsheet help a person to do this ? (3mks)
7 give any two methods you can use to start microsoft excel (2mks)
8) differentiate between a formulae and a function (2mks)
9) the formula =A1 + C2 is initially typed in cell D1. What will it be when copied to cell E1? (3mks)
10) differentiate between a worksheet and a workbook (2mks)
11) define each of the following (3mks)
A)cell
b) Row
c) Column
12) state four data types acceptable to spreadsheets and explain each of them (8mks)
13) what is a template ? Explain how you can start a spreadsheet template in microsoft excel ? (4mks)
14) differentiate between single and multiple cell referencing (3mks)
More Question Papers
Exams With Marking Schemes