Microsoft Excel is a powerful digital tool used in most workplaces to organise, handle, and understand large amounts of data in an easy way. It is primarily used to find information easily, perform complicated mathematical calculations, and display data through visual charts and graphs.
The Structure of an Excel Worksheet
An MS Excel file is often referred to as a workbook or a worksheet. According to the sources, it consists of four main parts:
- Sheets: These are the individual pages within a workbook, located at the bottom left of the screen.
- Cells: These are the small rectangular boxes that make up the sheet where you type your data.
- Rows: A single line of cells running from left to right, numbered 1, 2, 3, and so on.
- Columns: A single line of cells running from top to bottom, identified by letters like A, B, and C.
Naming Cells and Entering Data
Every cell in Excel has a unique name based on its location, combining the column letter and the row number. For example, a cell in column B and row 5 is named B5.
To enter data into a worksheet:
- Select a cell using the 'Select Mode' cursor.
- Type your information, which can include both numbers and letters.
- Navigate to other cells using the arrow keys on your keyboard.
Saving and Printing Work
It is vital to save your worksheets to ensure you do not lose information.
- To Save: Click the floppy disk icon at the top left or use the keyboard shortcut Ctrl + S. You must provide a clear file name and choose a storage location on your computer.
- To Print: Navigate to 'File' then 'Print', or use the shortcut Ctrl + P. You can preview the pages using the arrows at the bottom before clicking the final 'Print' button.
Using Simple Functions
Excel can perform mathematical calculations on thousands of numbers instantly through the Auto-sum feature found in the 'Formulas' tab.
- SUM: This function adds the values of a specific range of cells. For example,
=SUM(B1:B6)adds all the numbers in cells B1 through B6. - AVERAGE: This function calculates the average value of a range. For example,
=AVERAGE(B1:B6)finds the average of the numbers in those cells. - Execution: After selecting the function and the cells to be calculated, simply press the 'Enter' key to see the final answer.