Computer Science JSS3 Second Term
Week 1
Topic: Work Sheet
WORK SHEET
Worksheet commonly refers to a sheet of paper with questions for students and places to record answers. The term may also refer to a single array of data in spreadsheet software or an informal piece of paper that an accountant uses to record information.
A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Excel or Google Spreadsheets. A worksheet is used to store, manipulate, and display data. A worksheet is a collection of cells where you keep and manipulate the data. By default, each Excel workbook contains three worksheets.
Each worksheet is composed of a very large number cells – which are the basic storage unit for data in a file or workbook.
The cells are arranged in a grid pattern using rows and columns.
In Excel 2013:
- there are 1,048,576 rows per worksheet;
- there are 16,384 columns per worksheet;
- by default, each new file contains only one worksheet;
- the number of sheets per file is limited only by the amount of memory available on the computer.
* In earlier versions of Excel, the default number of worksheets per file was three.
For Google Spreadsheets:
- there is a maximum of 256 columns per sheet;
- the maximum number of cells for all worksheets in a file is 400,000;
- the current default number of worksheets for new files is one;
- there is a maximum of 200 worksheets per spreadsheet file.
Each worksheet also has a name. By default, the worksheets are named Sheet1, Sheet2, Sheet3 and so on.
STARTING A WORKBOOK FILE
Workbooks are file that can be created in excel. You can start workbook any time you want to create a new file for your excel data. Steps are
- Open a new workbook in Excel
- Point start on the screen of your monitor
- Click on all programs
- Point to Microsoft office tab
- Select Microsoft excel (this will take you to the excel environment)
A good example of how a spreadsheet may be used is creating an overview of your bank’s balance. Below is a basic example of what a Microsoft Excel spreadsheet looks like, as well as all the major portions of a spreadsheet highlighted.
What is an active worksheet?
An active worksheet is the worksheet that is currently open. For example, in the picture above, the sheet tabs at the bottom of the window show “Sheet1”, “Sheet2”, and “Sheet3”, with Sheet1 being the active worksheet. The active tab usually has a white background behind the tab name.
Examples of spreadsheet programs
Today, Microsoft Excel is the most popular and widely used spreadsheet program, but there are also many alternatives. Below is a list of spreadsheet programs that can be used to create a spreadsheet.
- Google Docs – Online and collaborative spreadsheet
- iWork Numbers – Apple Office Suite
- Lotus 1-2-3
- OpenOffice – Calc
- Lotus Symphony – Spreadsheets
- Microsoft Excel
- VisiCalc
For more class notes, visit: http://passnownow.com/classwork-support/
