ICF_8 WEEK 2

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 6

SILVINO LUBOS VOCATIONAL HIGH SCHOOL

SILVINO LUBOS, NORTHERN SAMAR


TLE-ICT
JUNIOR HIGH SCHOOL

INTERNET AND COMPUTER FUNDAMENTALS

TESSIEBELLE T. LABAYDAN
ICF Teacher
Question
s? Text
or Call
092073
TOPIC : MS EXCEL: PARTS AND FUNCTIONS
COMPETENCY : IDENTIFY THE PARTS AND FUNCTIONS OF MS EXCEL
DURATION : Week 2 (October 19-23)

Introduction:

This module covers the knowledge and appreciation required in identifying the parts and
determining the function of each.

Learning outcomes:

Upon completion of this module, the students are expected to:

 Identify the different parts of MS Excel


 Determine the function of the parts of MS Excel

DO NOT WRITE ANYTHING ON THIS LEARNING MODULE!

Going
back!

Activity 1: REVIEW
Complete the paragraph below, choose your answer inside the box. Write the word of your answer.
Refer on the LEARNING ACTIVITY SHEET in writing your answer.

Microsoft Excel columns calculations spreadsheet rows

(1)____________ is a (2) _____________ developed by Microsoft for Windows, macOS and


iOS. It is the computer equivalent to a paper ledger sheet. It consists of a grid made from
(3)________and (4) ________. It is an environment that can make number manipulation easy and
somewhat effortless. It is used whenever you need to perform (5)_________. These calculations
may involve mathematical, financial, and scientific data.

Let’s start!
Many times, you see on the MS Excel are standard in most other Microsoft software programs like Word,
PowerPoint, while some elements are specific to MS Excel. Let us get to know MS Excel.

THE EXCEL WINDOW

PARTS AND FUNCTIONS

Title bar

- This is where the name of the workbook can be found, typically the default name of the workbook
is “ Book1” and can be change once you save your workbook for the first time.
- This includes the minimize, maximize and close button found at the upper right most corner of the
workbook.

Quick Access Toolbar

- It is a customizable toolbar that contains commands that you may want to use. You can place the quick
access toolbar above or below the ribbon. To change the location of the quick access toolbar, click on
the arrow at the end of the toolbar and click Show Below the Ribbon.
- You can also add items to the quick access toolbar. Right click on any item in the Office button or the
Ribbon and Click Add to Quick Access Toolbar and a shortcut will be added.
Office Button

- This button allows you to create a New workbook, Open an existing file, Save a file, Print a file, View the
information about your workbook, Share, Export and more.

Ribbon
- It is the panel at the top portion of the document. It consists the tabs: Home, Insert, Draw, Page Layout,
Formulas, Data, Review, View. The Draw tab was added in the latest version of MS Excel 2019. Each Tab
is divided into groups. The Groups are logical collections of features designed to perform function that
you will utilize in developing or editing your Excel spreadsheets.

A glance in every Tab


Home

Insert

Draw

Page Layout

Formulas

Data
Review

View

_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_

Activity II. Identification


Direction. Identify the part of MS Excel being described in the following sentences.
Refer on the Learning Activity Sheet in writing your answer.

1. It is the panel at the top portion of the document.


2. They are logical collections of features designed to perform function that you will utilize in developing or
editing your Excel spreadsheets.
3. This button allows you to create a New workbook, Open an existing file, Save a file, Print a file, View the
information about your workbook, Share, Export and more.
4. It is a customizable toolbar that contains commands that you may want to use.
5. This is where the name of the workbook can be found.
6. Typically, the default name of the workbook is ________ and can be change once you save your workbook
for the first time.
7. This includes the minimize, maximize and close button found at the upper right most corner of the
workbook.
8. After clicking the arrow in the quick access toolbar, you have to click _________ to place the quick access
toolbar below the ribbon.
9. In MS Excel 2019 the _______tab was added.
10. Glancing from the tabs, it is where you can modify the paper size of your workbook, adjust the margin,
change the orientation and more.

Now, let us check your answer.


Refer at the back for the answer key 😊
ANSWER KEY

Activity I
1. Microsoft Excel
2.spreadsheet
3.columns
4.rows
5.calculations

Activity II
1.Ribbon
2.Groups
3.Office button
4.Quick Access Toolbar
5.Title bar
6.book1
7.Title bar
8.Show Below the Ribbon
9.Draw
10.Page Layout

You might also like