Mastering Spreadsheet Skills for Business and Beyond, Schemes and Mind Maps of Mathematics

Download Mastering Spreadsheet Skills for Business and Beyond and more Schemes and Mind Maps Mathematics in PDF only on Docsity!

Advance

Spreadsheet

Skills

Lesson 4

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

LibreOffice Calc

OpenOffice.org Calc

Google Sheets

Apple iWork Numbers

Kingsoft Office

Spreadsheets

StarOffice Calc

Microsoft Excel

Examples of Spreadsheet Software:

Statistical

Treatment

Grading System

Payroll System

Sales Transaction

Sales Inventory

List of uses:

Ribbon

• where the category of settings are found

Formula Bar

• show values, formulas or labels in a cell

Column Letter clicking one selects all columns

Function Button

• insert a function to a selected cell

Row Number

clicking one selects

all rows

Sheet Selection Tab Switch, insert, delete or change tab

imating the Product Cost using Microsoft E

Let us assume that we are going to sell

milk tea with the following information:

Product Information

Product Name/Brand: Starbuko Organic Milk Tea

Company/Group Name: Starbuko Foods Corporation

Product Description: Starbuko Milk Tea is a special

milk tea using organic ingredients especially made for

Filipinos.

Ingredients: tea, water, condensed milk, ice, special

sweetener

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:

Check if our estimated price will earn

us profit. Type the additional information

shown below then apply the arithmetic

formula for subtraction:

The result is PHP 7.80. This is

definitely profitable at this price.

However, this does not guarantee our

product success.

Save your file as L4 Cost

Ingredients.xlsx.

Analyzing Data using Microsoft Excel

It is now time for us to collect data

from our 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.

Tip: To change the orientation of the text,

press CTRL+1. To open the format cell

Dialog box. Alignment Tab > under

Orientation, specify the degrees you want. Obviously, this data is raw. Assuming

that we have a huge sample, we have to

apply several formulas to be able to

easily analyse the result of this survey.

Let us start by a simple average

formula to determine the average rating

of Quality Taste, Presentation and

The syntax would be: =AVERAGE(cells

involved)

Example: Using Figure 1, determine the

average for Quality: =AVERAGE(F5:F19)

COUNTIF Function Syntax:

=COUNTIF(Range,criteria)

ANGE – the cells where the counting will take

ce. CRITERIA – the label or value that

determines if it is to be

counted.

Example: Using Figure 1, the formula for

getting the number of YES for the

criteria is

=COUNTIF(J5:J19, “YES” )

Determine the number of YES answers

in both criteria and place them at the

bottom of your survey results similar to

the screen shot below: