Empowerment Lesson 4

ALUBIJID NATIONAL COMPREHENSIVE HIGH SCHOOL

SENIOR HIGH SCHOOL

OPEN HIGH SCHOOL
EMPOWERMENT TECHNOLOGY

Name: _______________________________ Year Level: ___________________
Section: _____________________________
ADVANCED SPREADSHEET SKILLS

Learning Objectives
1. familiarize with the most commonly used functions in Microsoft Excel;

2. use several conditional functions available in Microsoft Excel; and
3. use Microsoft Excel as a viable tool in market research and product development.
Review/Lesson Preview
From our previous class, we have discussed about ADVANCE MOCROSOFT WORD SKILL. Write the
correct letter of your answer in the space provided:
A. Shapes.
B. Pictures
C. Chart.
D. Smart Art.
E. Clip Art
F. Screenshot.
1. Generally, these are electronic or digital pictures or photographs you have saved in any local storage
device._________________
2. This is generally a .GIF type; line art drawings or images used as generic representation for ideas and
objects that you might want to integrate in your document. ________________
3. These are printable objects or materials that you can integrate in your document to enhance its
appearance or to allow you to have some tools to use for composing and representing ideas or
messages. ________________
4. Generally, these are predefined sets of different shapes grouped together to form ideas that are
organizational or structural in nature.____________________
5. Another type of material that you can integrate in your Word document that allows you to represent
data characteristics and trends. ____________________
6. Sometimes, creating reports or manuals for training or procedure will require the integration of a
more realistic image of what you are discussing on your report or manual. _____________
Lessons & Concepts

WHAT IS A MICROSOFT EXCEL?
Microsoft Excel provides an automated way of displaying any statistical data. It can be used to automatically compute for
several factors that are not easy to notice especially when faced by a large data. Microsoft Excel includes several arithmetic
and basic functions that help you compute faster.
Basic Excel Formulas:
Addition (+) Subtraction (-)

Multiplication (*) Division (/)
*type <=> before the formula,
thus: =a1+a2 <then, hit the ENTER key>
SENIOR HIGH SCHOOL
OPEN HIGH SCHOOL
COMMON BUILT IN FORMULAS/FUNCTIONS IN EXCEL

Average – a function used to compute for the average of the number of a range.
COUNTIF – a function used to count the cells with a specified content within a range.
SUMIF – a function used to compute for the summation of a range if a certain condition is met
AVERAGEIF – a function used to compute for the average of a range if a certain condition is met
Activity 1
Whether you work in the field of accounting or not, the truth is whatever you do should be accounted for.
This is because the resources you use cost you expenses. Whether you become a scientist, an engineer, a yoga
instructor, a bartender, or an airline pilot, it is important to understand how a company spends to be able to deliver
a product or service. These factors could easily be computed using spreadsheet programs like Microsoft Excel or
Google Sheets.
Estimating the Product Cost using Microsoft Excel Let us assume that we are going to sell milk tea with the
following information:
We will use Microsoft Excel to find out if our estimated sale price is reasonable considering the actual price of the
ingredients. 1.) Copy the information below:
SENIOR HIGH SCHOOL
OPEN HIGH SCHOOL
2.) Use the SUM formula to get the summation of the values
from C4 to C7. The SUM formula is =SUM(C4:C7). Type this
on cell C8 as shown below:
3.) Check if our estimated price will earn us profit. Type the
additional information shown below then apply the arithmetic
formula for subtraction:
4.) The result is PHP 2.20. Our estimated price is not profitable.
Let us make an adjustment. Include the information below and
deduct the Total from the New Sale
5.) The result is PHP 7.80. This is definitely profitable at this price. However, this does not guarantee our product
success. 6.) Save your file as L4 Cost Ingredients.xlsx
SENIOR HIGH SCHOOL
OPEN HIGH SCHOOL
Activity 2:
Analyzing Data using Microsoft Excel It is now time for us to collect data from out target market. In reality,
researchers would also come up with survey questions before they release the product. The data they gathered
would help them determine if the product has any chance of succeeding in a target market.
Let us start by a simple average formula to determine the average rating of Quality, Taste , Presentation and
Product
The syntax would be =AVERAGE(cells involved).
Using the figure above , determine the average for QUALITY;
=AVERAGE(F5:F19)
Determine the AVERAGE of all your criteria and place them at the
bottom of your survey results similar to the screenshot ==➔>>>
Save your files and pass it to your instructor.

SENIOR HIGH SCHOOL
OPEN HIGH SCHOOL
Independent Learning
Multiple Choice. Write the letter of the correct answer on the space before each number.
___1.) A program designed to create spreadsheets which can later be used to analyze statistical data.
a. Microsoft Excel c. Microsoft Publisher
b. Microsoft Word d. Microsoft OneNote
___2.) A number format that puts a dollar symbol before each value by default.
a. percent c. comma
b. accounting d. date/time ___
3.) A function that adds a range of cells.

a. ADD c. SUM
b. PLUS d. TOTAL
___4.) This is the tab in the format Cells dialog box where you can change the orientation of a text.
a. alignment c. file
b. orientation d. view
___5.) A function that gets the average of a range of cells.

a. AVERAGE c. MEAN
b. SUM d. MEDIAN ___
______6.) Which among the following is not part of the syntax for AVERAGEIF?
a. average range c. logical test
b. range d. criteria ___
______7.) A function used to count the number of cells that contains something in them if the criteria are met.
a. COUNT c. COUNTING
b. COUNTNOW d. COUNTIF
_____8.) A function used to add a certain range of cells if a condition is met.

a. SUMIF c. TOTALIF
b. ADIF d. PLUSIF
______9.) The shortcut key for the format Cells dialog box.
a. Ctrl + F c. Ctrl + 1
b. Shift + F d. Alt + 1
___10.) A syntax in the AVERAGE function that includes the value or label that determines if the cell is part of the range to
be averaged.
a. range c. average range
b. criteria d. logical test
SENIOR HIGH SCHOOL
OPEN HIGH SCHOOL
Closure Activity:
Visit the link below and do the activity given:
https://lifehacker.com/four-skills-that-will-turn-you-into-a-spreadsheet-ninj-1525058930
Feedback:
How do you feel about the activity?
_____________________________________________________________________________________________
____________________________________________________________________________________________
References:
https://lifehacker.com/four-skills-that-will-turn-you-into-a-spreadsheet-ninj-1525058930
https://www.slideshare.net/daki01/lesson-4-advanced-spreadsheet-skills
file:///C:/Users/Teacher/Downloads/22-180314004725.pdf

Empowerment Lesson 4

Uploaded by

Copyright:

Available Formats

Empowerment Lesson 4

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Empowerment Lesson 4

Uploaded by

Copyright:

Available Formats

ALUBIJID NATIONAL COMPREHENSIVE HIGH SCHOOL

SENIOR HIGH SCHOOL

Name: _____________ Year Level: _

ADVANCED SPREADSHEET SKILLS

1. familiarize with the most commonly used functions in Microsoft Excel;

Lessons & Concepts

Addition (+) Subtraction (-)

COMMON BUILT IN FORMULAS/FUNCTIONS IN EXCEL

Save your files and pass it to your instructor.

3.) A function that adds a range of cells.

___5.) A function that gets the average of a range of cells.

_____8.) A function used to add a certain range of cells if a condition is met.

Visit the link below and do the activity given:

How do you feel about the activity?

You might also like