Downloaded 136 times
Uploaded byCikgu Bibi
Panduan Asas Excel (ICTL)
Excel allows users to create electronic spreadsheets organized into workbooks and worksheets. Each worksheet is a grid of columns and rows that can contain numbers, text, or formulas. Cells are the intersections of columns and rows and have addresses to identify their location. Formatting options are available for cells to control number formats, text alignment, fonts, borders, and shading. Formulas in cells automatically calculate and update based on referenced cell values.
More Related Content
Similar to Panduan Asas Excel (ICTL)
Panduan Asas Excel (ICTL)
- 1.
- 2.
- 4. Excel allows youto create spreadsheets much like paper ledgers that can perform automatic calculations. Each Excel file is a workbook that can hold many worksheets.
- 5. The worksheet isa grid of columns (designated by letters) and rows (designated by numbers). The letters and numbers of the columns and rows (called labels) are displayed in gray buttons across the top and left side of the worksheet.
- 6. The intersection ofa column and a row is called a cell. Each cell on the spreadsheet has a cell address that is the column letter and the row number. Cells can numbers, formulas. contain either text, or mathematical
- 8.
- 10.
- 12. The data typecan be selected from the options on this tab. Select General if the cell contains text and number, or another numerical category if the cell is a number that will be included in functions or formulas. (1) NUMBER TAB
- 13. (2) ALIGNMENT TAB Theseoptions allow you to change the position and alignment of the data with the cell.
- 14. (3) FONT TAB Allof the font attributes are displayed in this tab including font face, size, style, and effects.
- 15. (4) BORDER AND PATTERN TAB Thesetabs allow you to add borders, shading, and background colors to a cell.
- 16.
- 17. Formula: • Formulas areentered in the worksheet cell and must begin with an equal sign "=". • The formula then includes the addresses of the cells whose values will be manipulated with appropriate operands placed in between. • After the formula is typed into the cell, the calculation executes immediately and the formula itself is visible in the formula bar.
- 19.