Embedded Files
definition
definition
Tabulation
Tabulation
Tabulation is the act or process of tabulating or arranging in tabular form – that is, into a table. A table is both a mode of visual communication and also a means of arranging data.
Spreadsheet basics
Spreadsheet basics
Spreadsheet: A spreadsheet is a computer application that simulates a paper accounting worksheet.
Worksheet: A worksheet is a single working area in a spreadsheet file, consisting of a grid of lettered columns and numbered rows. Each worksheet has a tab that may be renamed.
Workbook: A workbook is a collection of related spreadsheets that are saved as one file. A new workbook contains three worksheets – Sheet1, Sheet2 and Sheet3. Sheet1 is the active worksheet.
YouTube Video on the basics of Microsoft Excel
YouTube Video on the basics of Microsoft Excel
Activity 1
Activity 1
Create a new Microsoft Excel worksheet:
Right-click on your desktop, then New, then Microsoft Office Excel Worksheet.
Observe that a new icon labelled ‘New Microsoft Office Excel Worksheet’ is placed on your desktop.
Change the name of the worksheet to ‘EDPM_Activity1-1’.
Activity 2
Activity 2
Rename worksheet tabs:
Open the workbook named ‘EDPM_Activity1-1’ that was saved on your desktop.
Double-click the sheet tab labelled ‘Sheet1’.
Type ‘PriceList’ then press Enter.
Double-click the sheet tab labelled ‘Sheet2’.
Type ‘Invoice’ then press Enter.
Save the file as ‘EDPM_Activity1-2’ and close Excel.
some key elements in an excel worksheet
some key elements in an excel worksheet
Activity 3
Activity 3
Follow the YouTube video below and create the same table using Microsoft Excel.
Type the following documents on A4 paper in Microsoft Excel and follow ALL instructions given.
Type the following documents on A4 paper in Microsoft Excel and follow ALL instructions given.
Page updated
Google Sites
Report abuse