Spreadsheet III

Back to: DATA PROCESSING SS 1

 

Welcome to class! 

In today’s class, we will be talking more about the spreadsheet. Enjoy the class!

Spreadsheet III

Loading excel application

Click on all programs, check the programs and click on the Microsoft suites then click on the Excel application.

Creating an excel document

Once Excel is open, you can enter data into a file by clicking on a particular cell, then typing text, numbers, or formulas. Your changes will be entered into the current cell.

1. Press the tab to enter your data and move the active cell to the right of the current one.
2. Press enter key to enter your data and move the active cell to the next row, usually to the beginning of that row.
3. Use the arrow keys to enter your data and move the active cell in the indicated direction.
4. Press the end key, right-arrow key to move to the last cell in a row.

Entering data in a worksheet

Locate the cell where you want to enter data on the worksheet and click on the cell. For example point and click on cell A1.

Type in your entry from the keyboard and notice the appearance of the entries in the formula bar with the cell address. Press ‘Enter’ key.

Evaluation

1. What are the steps involved in creating a Spreadsheet?
2. Explain how to enter data into Excel.

Editing data in a worksheet

Wrong entries may either be entirely re-typed or the particular cell/range of cells can be corrected.

• To retype:

1. Move the cell pointer to the cell to be corrected or re-type the entry and press ‘Enter’

• To correct only the mistake:

1. Move the cell pointer to the cell and double click on the cell.
2. Make the correction by inserting, deleting or retyping.
3. Press ‘Enter’.

Saving a worksheet

• Saving for the first time:

1. Click on ‘Home’ button,
2. Click ‘Save As’ button and wait for a dialog box to open.
3. Type in your desire filename (i.e. the name of the document).
4. Click ‘Save’ button or press enter on the keyboard.

• Saving while working (after the first saving):

1. Click on ‘save’ icon on the Quick Access toolbar or click on ‘office button’ to open the menu. and click ‘save’ from the options.

Retrieving a saved worksheet

Retrieving a worksheet means to open an already saved worksheet from its location in the computer. This is usually done to view, edit or update the worksheet.

1. Load/start Microsoft Excel
2. Click on ‘Office Button’
3. Click the ‘Open’ option from the list and wait for a dialog box to open.
4. Navigate to the file you want to open and double click on it.

General evaluation

1. Define a cell.
2. State steps involved in saving a worksheet for the first time.
3. Highlight the steps in retrieving a saved document.

Reading assignment

A Handbook on Computer Studies for Schools and Colleges by Niyi Adekolegan

Weekend assignment

1. ___ is a collection of cells organized into rows and columns where data is stored and manipulated. Worksheet B. Graph C. Workbook D. Active cell
2. ___ is a space in a worksheet formed by the intersection of a row and a column.
3. Workbook B. Sheet C. Cell D. Cell Reference.
4. There are ……… rows per worksheet in Excel. A. 1,048,576 B. 1,048,765
5. 1,408,576 D. 1,022,333
6. There are ___ columns per worksheet in Excel. A. 16,387 B. 16,384 C. 16,684
7. 15,341
8. The address of a cell is known as ___ A. Cell space B. Cell reference C. Cell Menu
9. Active cell

Theory

1. Highlight the steps in saving a worksheet
2. In Excel, what do you understand by the term “retrieving”?

 

In our next class, we will be talking about Database Management.  We 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.

Ready to make school management and growth easy? Book your free onboarding session now

Get more class notes, videos, homework help, exam practice on Android [DOWNLOAD]

Get more class notes, videos, homework help, exam practice on iPhone [DOWNLOAD]