Scribd
Upload
11 views

Excel_Assignments_with_Formulas

excel

Uploaded by

excellearning80
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views

Excel_Assignments_with_Formulas

excel

Uploaded by

excellearning80
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Product Units

TotalSold
Sales
Price(Formula:
per Unit Units Sold * Price per Unit)
Product A 50 100
Product B 30 150
Product C 20 200
Product D 40 120
Student Name Day 1 Day 2 Total
DayPresent
3 (Formula: COUNTIF)
Student 1 P A P
Student 2 A P P
Student 3 P P A
Student 4 P A P
Employee
Net Salary
Name
Basic
(Formula:
SalaryBonus
Basic(%)
Salary
Deductions
+ (Bonus%
(%) * Basic Salary) - (Deductions% * Basic Salary))
Emp 1 30000 10 5
Emp 2 40000 15 7
Emp 3 50000 20 10
Emp 4 45000 10 5
Student Name
Subject 1 Subject 2 Subject 3 Subject 4 Subject
Total Marks
Average
5 (Formula:
Marks (Formula:
SUM) AVERAGE)
Student 1 80 75 90 85 70
Student 2 70 85 60 75 80
Student 3 90 80 70 65 85
Student 4 60 70 80 95 60
Percentage
Category
of Total
Amount
(Formula: Amount / SUM(Amount) * 100)
Rent 20000
Food 10000
Travel 5000
Miscellane 3000

You might also like