LIRA TOWN COLLEGE
DEPARTMENT OF ICT
………………………………………………………………………………………………………………
……………………………………………………………………………………………………………
Microsoft Excel Assignment
1. Define a Spreadsheet.
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
2. What is an electronic Spreadsheet?
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
3. Give three examples of Spreadsheet software.
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
4. Give three advantages of using an electronic Spreadsheet over traditional ledger sheet.
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
5. Describe three components of a Spreadsheet.
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
6. State any five application areas of spreadsheets.
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
7. What is forecasting?
Page 1 of 2
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
8. Differentiate between a formula and function.
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
9. Differentiate between a worksheet and a workbook.
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
10. Define the following:
a) Cell
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
b) Row
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
c) Column
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
11. Differentiate between printing a range and a whole workbook.
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
12. What is a legend?
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
Page 2 of 2