JSS 3 WEEK 10 SECTION B: (PRACTICAL)

SECTION B:  (PRACTICAL)

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

1.       Open a new workbook in Excel 

2.       Point start on the screen of your monitor

3.       Click on all programs

4.       Point to Microsoft office tab

5.       Select Microsoft excel (this will take you to the excel environment)

 

Fig 1: Example of a new spreadsheet window

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.

More 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 document.

·         Google Docs – Online and collaborative spreadsheet

·         iWork Numbers – Apple Office Suite

·         Lotus 1-2-3

·         OpenOffice – Calc

·         Lotus Symphony – Spreadsheets

·         Microsoft Excel

·         VisiCalc

ASSIGNMENT

1.      Find and write out five mathematical functions and their formulas in MS Office Excel.

2.      Find more differences between a worksheet and a workbook.