SPREADSHEET PACKAGE 3 - BASIC OPERATION IN WORKSHEET/PRACTICAL (JS3 NOTES)

 SPREADSHEET PACKAGE 3 

 BASIC OPERATION IN A WORKSHEET/PRACTICAL

Data Entry
This is the process of inputting data into the cells of the worksheet. There are three basic types of data in spreadsheet packages and they are:
a. Values or Numbers
b. Formula
c. Labels
Editing Worksheet
This is the process of customizing the worksheet so that it could be neatly arranged on the pages when printing. Check spelling, preview layout, page setup and sheet setting, etc are parts of the editing process. 
Saving Worksheet
This can easily be done using the Save As found on the file menu or by pressing ctrl + S keys simultaneously. 
Retrieving or Opening Worksheet
To retrieve or open a worksheet, click on office button on the menu and click on Open button from the file sub-menu or by pressing Ctrl + O keys together. A dialog box will be displayed asking you to choose the worksheet to be opened or retrieve.

Formatting Worksheet

a. Changing column width
i. Pull down the Format Menu and select Column and then width
ii. Type the desired width in the space provided
b. Changing Row Height
i. Pull down the Format Menu and select Column and then width
ii. Type the desired height in the space provided

Adding Formulae and Performing Calculations
To tell the spreadsheet package that you will be entering a formula, you must start the formula with a particular symbol. Excel uses the sign = and lotus 1-2-3, uses the @, - or + signs.
The operators used in spreadsheet formulae include

Operators	Symbols
Addition	+
Subtraction	-
Multiplication	*
Division	/
Exponentiation	^

Using Functions in Microsoft Excel

Sum Function
The sum function adds up the total values of a group of cells, depending on which cells you choose. The general form is:
=SUM(First cell:Last cell)
Average Function
This will compute the average of the values of a group of cells depending on which cells you choose. The general form is:
=AVERAGE(First cell:Last cell)
Count Function
This function will count the number of entries in the range from first cell to last cells you choose. The general form is:
=COUNT(First cell:Last cell)
Max Function
The max function is used to find the largest value in a set of values in the row or column. The general form is:
=MAX(First cell:Last cell)
Min Function The Min function is used to find the smallest value in a set of values in a row or column. The general form is:
=MIN(First cell:Last cell)

Graphs

MS Excel gives options of creating charts from data entries in your spreadsheets. Charts like line graph, histogram, pie charts and bar charts could be created from the supplied data basically numeric data.
All charts are created in the same way by selecting range of cells within a worksheet called chart range after which one selects chart wizard option.
There are different parts of chart namely:
a. Legend: In a chart or graph in spreadsheet programs such as Excel, the legend is most often located on the right hand side of the chart or graph and can sometimes be surrounded by a border. The legend is linked to the data being graphically displayed in the plot area of the chart
b. Axis: As in normal mathematical operations every chart must carry axis i.e. axis X and Y, where X and Y stands for horizontal and vertical lines respectively which are displayed on data scale
c. Data series: These are set of numbers in either row or column

Steps to Create Graph In Microsoft Excel

To create graph in Excel, follow the steps below:

1. Enter the data that will be used in the graph into the worksheet.

2. Select the cells that contain the data for the graph

3. Use the Chart Wizard to create the graph

Editing Graphs

Graphs can be edited and formatted in a number of different ways to display the information as requires.

Steps to edit graph in Excel are as follows:

1. Click on the graph to select it.

2. On the "Insert tab" in the Charts' group, select "Column", and then select the graph type 'Clustered Column'

Class Activities

1. State the steps to edit and open a worksheet in a spreadsheet package

2. State the steps to create graphs in a spreadsheet package