Objective and skill for spreadsheet are:

​

1. Recognize structure and purpose

2. Recognize the active cell

3. Know how to enter data

4. Interpret simple spreadsheets and data

5. Conduct a search in a simple database

 

How to make a spreadsheet

 

Firstly, you need to start your spreadsheet application. Make sure it automatically open with a new, blank spreadsheet.

Then, identify columns that are letter labels and rows that are number labels. You can use the cursor keys to move around the spreadsheet and continue to identify the active cell. Then, use print preview to see the page layout for your spreadsheet and save the spreadsheet.

 

     

        1. Formatting data and using functions

 

> Editing data in a cell

 

 

   Direct cell editing

• Double click on the cell you wish to edit

• The cell will open for direct editing

• Make the necessary corrections

• Press enter

   Formula bar editing

• Single click on the cell you wish to click

• Edit the entry in the formula bar

• Press enter

 

 

> Columns and Row

 

 

Re-Sizing

Changing the size of a column or row to better show the contents of it can be done by following the steps below:

1. Find the border of the heading to the right of the column you want to change sizes or the border below the row you want to change sizes. Move your mouse pointer to that border.

2. Drag your mouse over that line and stop when your cursor changes from an arrow to a plus sign with arrows on either side.

3. Left click on the line and drag it smaller or larger depending on the width you desire.

 

Re-Sizing Shortcut: To automatically adjust the column or row’s size you will simply double click on the line rather than dragging it. This will automatically adjust to the maximum size of any of your rows or columns.

 

> Adding a Column or Row

Here is what you will need to do to add a new column or row:

1. Left click on either the column letter to the right of where you want the new column to be (for example if adding one between A and B click on the letter B) or the row number below where you would want the new row to be (for example if adding one between 12 and 13 click on the number 13).

2. Then click on the insert button in the ribbon. It is located in the home tab under the cells group.

 

 

> Deleting a Column or Row

When deleting a column or row, the steps will be basically the same just like when adding one. Here is what you will need to do to delete a column or row:

1. Click on the column letter or the row number that you want to delete.

2. Then click on delete in the cells group on the home tab.

 

 

      2. Cell love data and simple formulas

 

 

Firstly, you need to select the cell and identify based on where the column (vertical) and the row (horizontal) intersect. Then, enter the formula in the formula bar. For example:

 

 

=SUM(B2:D2).

 

 

All function must have equal (=). To activate the formula, all you need do is hit the return or tab key. Experiment with entered simple formulas. SUM means addition, AVERAGE means average, and there are many other formulas depending on the purpose of your spreadsheet. The range is also always closed in parentheses ( ).