ICT 7 Activity Sheet - Excel Basics

ICT 7 Activity Sheet - Quarter 3, Week 1

• This activity sheet is for basic Excel operations.
• The learning activity sheet guides learners to complete tasks at their own pace.
• The sheet uses resources from the community, helping acquire essential lifelong learning skills, knowledge and attitudes for employment.
• Learners will complete activities independently using provided references/links.
• Facilitators can use this material to teach specified learning competencies.

Introductory Message

• The learning activity sheet is self-directed, allowing learners to work at their own pace.
• It uses contextual resources to support the learning process.
• The goal is to assist learners in acquiring lifelong learning skills, knowledge, and attitudes for productivity and employment.
• Instructions are provided for facilitators and for learners.

ICT-7 Activity Sheet - Basic Operations in Excel Environment

• The document presents the process of performing basic operations in Excel.
• Learners will identify different parts of the Excel Window.
• Learners will demonstrate how to open and close workbooks.
• The document explains the components of a cell within a worksheet.
• Adding worksheets is demonstrated.

Parts of Excel Window

• Quick Access Toolbar: Provides common commands, customizable.
• Ribbon: Contains commands for common tasks, organized into tabs and groups.
• Active Cell: Marked with a border, the cell in focus for actions.
• Name Box: Displays the cell reference of the active cell.
• Formula Bar: Displays the data or formula in the active cell.
• Column: Vertical section, labeled by letters (A, B, C).
• Row: Horizontal section, labeled by numbers (1, 2, 3).
• Sheet Tabs: Used to navigate between worksheets within a workbook.

Working with Excel Environment

• Learners are required to demonstrate starting Excel by double clicking the icon.
• They need to find the 'File' tab and select the option to create a new, blank workbook.
• Additional instructions are provided, such as selecting a cell.
• Several methods are described for selecting multiple cells.
• Learners understand that opening a new worksheet is possible using sheet tabs.
• To move to the last row, learners use Ctrl + key
• To move to the last column, learners use Ctrl + key
• Learners are asked to demonstrate moving to cell A1 using Ctrl + Home.
• Instructions to close Microsoft Excel are given.