Spreadsheet Packages; Meaning and Uses

Back to: COMPUTER SCIENCE JSS3

 

Welcome to JSS3 Second Term!

We are eager to have you join us in class!!

In today’s class, We will be discussing Spreadsheet Packages, Their Meaning and Uses. We hope you enjoy the class!

 

TOPIC: SPREADSHEET I

DEFINITION OF SPREADSHEET: A spreadsheet is a collection of cells organized into rows and columns where data is stored and manipulated. The spreadsheet is known as a worksheet. A spreadsheet begins with row number one and column A. A cell is a space in a worksheet formed by the intersection of a row and a column. Each cell can contain a number, text or formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook. Each cell has an address called Cell Reference e.g. A1, B3, C7 etc. combination of more than one sheet is referred to as workbook. The worksheets can accept thousands of rows of data and columns in the form of fields. Active Cell is recognized by heavy border surrounding. It is the cell that is currently worked upon.

A SPREADSHEET

 

CONTENT OF SPREADSHEET

When you are setting out a spreadsheet, you have to enter values, labels and formulas.
• VALUES: Values are those numbers you already know before starting the spreadsheet operation. These values are inserted into cells of the spreadsheet.
• LABELS: Labels are words you enter to explain the values. You would not just enter a list of numbers without explanation. Putting labels next to each of the numbers makes it easier to check it through.
• FORMULA: Formulas are the mathematical equations you insert into the cells. Formulas are commands that instruct the computer on what to do.

EVALUATION
1. Define a worksheet.
2. What do you understand by cell reference?

 

USES OF SPREADSHEET

There are various uses of a spreadsheet. It uses varies according to the intended purpose. Some of its uses are as follows:
1. Spreadsheets are used for administrative functions.
2. Spreadsheets are used for creating reports.
3. They are used for the preparation of daily sales.
4. They are used in computing school results.
5. They are used for project budgeting control.
6. They are used for drawing balance sheets.
7. Excel can store and calculate the data as directed using existing data.
8. A spreadsheet can be used for analysis and decision making.
9. It makes calculations much easier than working things out yourself.

GENERAL SELF EVALUATION
1. State the uses of a spreadsheet.
2. Excel can be used to create analysis, Explain.
3. What is an active cell?
4. What are the contents in a spreadsheet?

 

READING ASSIGNMENT: Modern Computer studies by Victoria, page 25

WEEKEND ASSIGNMENT
1. A cell can also reference another cell in the same……..     A. worksheet   B. workbook  C. cellular D. sheet
2. A spreadsheet can be used for data analysis and…………making.     A. cell    B. decision    C. data     D. reference
3. The………….. can contain thousands of rows of data and columns in the form of fields.     A. cell        B. worksheet            C. reference cell D. excel
4. The cell that is been currently worked upon is known as …… cell.    A. current   B. active   C. reference   D. initial
5. A ……….. can also reference another cell in the same worksheet. A. cell     B. sheet   C. worksheet    D. none

 

THEORY

1. Define an active cell.
2. List and explain the THREE major contents in a spreadsheet.

 

We have come to the end of this class. We do hope you enjoyed the class?

Should you have any further question, feel free to ask in the comment section below and trust us to respond as soon as possible.

In our next class, we will be talking about Spreadsheet Packages II (Features and Terminologies). We are eager to meet you there.

 

For more class notes, homework help, exam practice, download our App HERE

Join ClassNotes.ng Telegram Community for exclusive content and support HERE