Exercise
Create A Bio Data For Chs Computer Institute. 20 Staff Includes: S/N, Staff
Name, Address, Date of Birth, State Of Origin, Local Govt., Marital Status,
Religion, E-Mail Address and Phone Number.
Create 20 Student Record Sheet For Chs Computer Institute Include: Metric
Num., Student Name, Department, 10 Subject are required to be calculate.
i. Summation, Ii. Average, Iii. Minimum, Iv. Maximum
Formula
Summation =sum (select the num from the first to the last num) press enter
Average= type average (select the num from the first to the last num) press enter
Minimum= type min (select the num from the first to the last num) press enter
Maximum= type max (select the num from the first to the last num) press enter
Create A Product Records Of 20 Goods Includes: S/N, Product, Quantity, Cost
Price, Selling Price, Qty Sold, Qty Unsold, Amount Sold, Amount Unsold, Profit,
Total Profit.
Formula
Quantity Unsold= Quantity – Quantity sold
Amount sold=selling price * Quantity sold
Amount unsold=cost price * Quantity unsold
Profit=selling price – cost price
Total profit= profit * Quantity
Create A Staff Payroll For Chs Computer Institute For 20 Staffs Includes: S/N,
Name, Gender, Position, Basic Salary, Feeding Allowance 2%, House Allowance
2.5%, Transport Allowance 3%, Wardrobes Allowance 4%, Medical Allowance
2%, Tax 3%, Insurance 2%, Pension 2.5%, Total Allowance, Gross Income, Total
Deduction, Net Income.
Formula
How to calculate allowance = Basic salary * the allowance given e.g = 20,000 *2%
enter
Total Allowance= sum (select all the allowancetogether) enter
Gross Income= basic salary + total allowance
Total deduction= Pension + Tax+ Insurance enter
Net income= Gross income – Total deduction
Create Lapo Micro Finance BankFor 20 Customers Includes: S/N, Name,
Gender, Principal, Rate, Time, Simple Interest, Amount, Day/Yrs, Daily
Payment, Week/Yrs, Weekly Payment, Month/Yrs, Monthly Payment, Annual
Payment.
Formula
Simple Interest= principal*rate*time
Amount= principal + simple interest
Days/yrs= 365*time
Daily payment= amount / day/yrs
Week/yrs= 52*time
Weekly payment= amount / week/yrs
Month/yrs= 12*time
Monthly payment= Amount / month/yrs
Annual payment= amount * time
If Function
The IF function is one of the most popular functions in Excel,and it allows you to make
logical comparisons between a value and what you expect. So an IF statement can have
two results. The first result is if your comparison is True, the second if your comparison is
False.
Dancer ltd is a company that employs the services of five sales men who are placed
on commission. The instruction below
Any person that has due sales of #500,000 and above will attract 20%, 15%
commission
Each salesmen are given a target of one data below represents the performance
of the sales at the end of the months.
Salesmen target actual sales evaluation rate commission
Grace 550,000 400,000
John 750,000 780,000
Juliet 800,000 680,000
Bola 750,000 450,000
Kemi 250,000 450,000
Formula
Evaluation= If(actual sales >= target, “yes”, “no”) enter
Rate= If(actual sales >= 500000,20%,15%) enter
Commission= If(actual sales >= 500000,actual sales*20%,actual sales*15%) enter
Student Record Grade and Remark
Create 3rd Term Promotion Exam for OrileAgege High School Include
Name Gender Score Grade Remark
Fatai M 30
Bola F 40
Tuned M 50
Titi F 70
Ola F 50
yusuf M 73
75 - Above A1 EXCELLENT
65 - 74 B3 VGOOD
55 - 64 C5 GOOD
45 - 54 D7 PASS
35 - 44 F9 Fail
Formula
Grade= If(average>=75, “A1”,If(average>=66,”B3”,If(average>=55,”C5”,If(average>=45,”D7”,
If(average<=35,”f9”))))) enter
Remark= If(average>=75, “excellent”, If(average>=66,”[Link]”,If(average>=55,”good”
,If(average>=45,”pass”,If(average<=35,”fail”))))) enter
Sum If
The Excel SUMIF function returns the sum of cells that meet a single
condition. Criteria can be applied to dates, numbers, and text. The SUMIF function
supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching
Safe world Nigeria Ltd
Year Date Items Value Criteria Taffy Criteria Taffy
2000 2/1/2000 Flours 2,000 2001 Flours
-=
2000 25/1/2000 Rice 2,000 2001 Rice
2001 11/4/2001 Beans 3,450 2002 beans
2002 20/6/2002 Drinks 2,500 2003 Drinks
2003 12/3/2003 Flour 1,500 2000 Flours
2003 22/12/200 Drinks 2,500 2001 Rice
3
2000 15/7/2000 Rice 1,800 2002 Beans
2001 10/5/2001 Drinks 2,200 2003 Drinks
2003 4/8/2003 Flours 1,500 2000 Flours
2000 14/2/2000 Rice 1,550 2001 Rice
2002 30/1/2002 Rice 1,200 2002 Beans
2002 28/6/2002 Drinks 1,390 2000 Flours
2001 4/10/2001 Beans 1,545 2001 Drinks
Formula
=Sum if (Year, Criteria, Value) i.e. (Year Select all, Select just one criteria, Select all value)
=Sum I f(Item, Criteria, Value) i.e. (Year Select all, Select just one criteria, Select all value)
