Employee Sales
Name Amount Bonus
John $4500
Emily $7000 You have data of Employees and their sales calculate 10% bonus for each employees
Michael $3000
Sarah $5500
David $800
Sophia $9500
Liam $4000
Emma $6200
Benjamin $1500
Olivia $4800
Use a text function to extract the first name and last name separately from the "Student Name" column.
Separate the first name and last name to create a new column "First Name", "Last Name".
Calculate the average score for each student.
Use a logical function to determine if a student's average score is above or equal to 85. If yes, label them as "Pass", otherw
Complete the following:
Exam 1 Exam 2 Exam 3 Exam 4
Student Name Score Score Score Score First Name Last Name Average Score Result
John Doe 85 90 88 92
Alice Smith 78 82 79 85
Bob Johnson 92 88 95 90
Sarah Lee 80 85 83 88
Emily Brown 75 78 80 82
hem as "Pass", otherwise label them as "Fail".
Actual Expenditure
S. No Account Head
2017-18 2018-19 2019-20
1 Salaries 800000 830000 850000
2 Travel Expenses 70000 90000 100000
3 Medical Charges 60000 70000 75000
4 Office Expenses 110000 130000 170000
5 Advt., Sales & Publicity Expenses 8000 9000 12000
Total :
1) Calculate the Average of last 3 years
2) Calculate the estimate for 2020-21
Estimate for 2020-21=Average+0.15×Average
3) Calculate the percent increase over 2017-18
Increase=Estimate for 2020-21−Expenditure for 2017-18/Expenditure for 2017-18×100
Average of last three years Estimate for 2020-21 % increase over 2017-18
2017-18×100
Product ID Product Name Category Brand Model
1 Apple iPhone 12 Pro Max Electronics
1) Separate the Brand Name with Model
2 Samsung Galaxy Watch 4 Electronics
3 Sony PlayStation 5 Electronics
4 Nike Air Zoom Pegasus 38 Footwear
5 Adidas Ultraboost 21 Footwear
6 HP Pavilion Laptop Electronics
7 Canon EOS Rebel T7i Electronics
8 Bose QuietComfort 35 II Electronics
9 Levi's 501 Original Fit Clothing
10 Calvin Klein Men's Shirt Clothing
the Brand Name with Model name Using text functions
Customer ID Customer Name Email
1 John Doe [Link]@[Link]
2 Alice Smith [Link]@[Link]
3 Bob Johnson [Link]@[Link]
4 Sarah Lee [Link]@[Link]
5 Emily Brown [Link]@[Link]
6 Michael Anderson [Link]@[Link]
7 Olivia Garcia [Link]@[Link]
8 David Martinez [Link]@[Link]
9 Sophia Wilson [Link]@[Link]
10 Ethan Taylor [Link]@[Link]
Create a new column and Use a logical function to categorize customers based on their email domains:
"Personal" if the domain is "[Link]".
"Organization" if the domain is "[Link]".
"Network" if the domain is "[Link]".
"Other" for any other domain.
The table below contains details of high school students names and ages, use IF formula t
1 If the student's age is 18 or above, he/she is eligible for a driver's license and below 18 n
2 If the student is younger than 18 years old he/she is a minor. for Minor return "Minor" a
Column F
Number Name Age Driver Licence
1 Arik 16
2 Ben 18
3 Cermit 15.5
4 Dan 19
5 Eliko 18
6 Fage 13
7 George 18
8 Herzl 17
mes and ages, use IF formula to complete columns F and G
driver's license and below 18 not eligible.
or. for Minor return "Minor" and non minor = "Adult" anwswer in column G
Column G
Minor/Adult?
An A+ student gets 100% scholarship and non A+ gets 50% scholarship as shown in the table below:
Amount
A+ 100%
A- 50%
The following table contains the names of students from 2024 class.
Use IF function to calculate the scholarships' amounts each of them will get
Name GPA Tuition Scholarship
Sam A+ 46,866
Ari A- 33,495
Xena A- 35,087
Gabe A+ 42,603
Eliko A- 36,971
Daniela A+ 41,286
Rotem A- 37,732
wn in the table below: