Spread Sheet
Microsoft Excel is a spreadsheet program that is used to record and analyze numerical data. Think of a spreadsheet as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns and numbers are usually assigned to rows. The point where a column and a row meet is called a cell. The address of a cell is given by the letter representing the column and the number representing a row.
Ribbon components explained
Ribbon start button - it is used to access commands i.e. creating new documents, saving existing work, printing, accessing the options for customizing Excel, etc.
Ribbon tabs – the tabs are used to group similar commands together. The home tab is used for basic commands such as formatting the data to make it more presentable, sorting and finding specific data within the spreadsheet.
Ribbon bar – the bars are used to group similar commands together. As an example, the Alignment ribbon bar is used to group all the commands that are used to align data together.
Understanding the worksheet (Rows and Columns, Sheets, Workbooks)
A worksheet is a collection of rows and columns. When a row and a column meet, they form a cell. Cells are used to record data. Each cell is uniquely identified using a cell address. Columns are usually labelled with letters while rows are usually numbers.
A workbook is a collection of worksheets. By default, a workbook has three cells in Excel. You can delete or add more sheets to suit your requirements. By default, the sheets are named Sheet1, Sheet2 and so on and so forth. You can rename the sheet names to more meaningful names i.e. Daily Expenses, Monthly Budget, etc.
Important Excel shortcuts
| Ctrl + P | used to open the print dialogue window |
| Ctrl + N | creates a new workbook |
| Ctrl + S | saves the current workbook |
| Ctrl + C | copy contents of current select |
| Ctrl + V | paste data from the clipboard |
| SHIFT + F3 | displays the function insert dialog window |
| SHIFT + F11 | Creates a new worksheet |
| F2 |
Check formula and cell range covered
|
- Chapters 6
- Department Education
- Teacher
Mr. Tariq Saleem Ghayyur
