Calculate how many employees are part of the IT Department.
Calculate the total salary of the IT Department.
Determine the average salary of the IT Department.
Calculate the total salary of employees with more than 5 years of work, working in the IT Department.
Calculate how many order is connected to Alpha Ltd.
Calculate how many order is connected to Alpha Ltd. and was completed.
Determine the total order amount of Alpha Ltd.
Determine which cookie is fatty.
Determine which cookie contains cocoa and is not very sweet.
Determine that the cookie which has a price in the [100,200] interval, does contain cocoa.
A school's academic coordinator has recorded information about the students of Class 12.A in a spreadsheet.
The Students worksheet contains the following table:
Column A
Name
Anna Kovács
Bence Szabó
Lili Tóth
Márk Nagy
Dóra Farkas
The Lookup worksheet contains the following fields:
B2: Name of the student to search for
B4: ID of the selected student (to be returned by a formula)
B5: Mathematics grade of the selected student
B6: Computer Science grade of the selected student
Write a formula in cell B4 that returns the student's ID from the Students worksheet based on the name entered in B2, using the INDEX–MATCH function combination.
Write a formula in cell B5 that returns the Mathematics grade of the specified student.
Write a formula in cell B6 that returns the Computer Science grade of the specified student.
VLOOKUP must not be used. Only INDEX and MATCH are allowed in the solution.
Calculate the gross inventory value.
Determine the category discount as follows:
Category A: 5%
Category B: 10%
Category C: 15%
Apply an additional 8% discount if the product has been in storage for more than 120 days.
Calculate the spoilage adjustment: Gross Inventory Value * Spoilage Factor
Calculate the final inventory value:
Gross Inventory Value - Category Discount - Additional Discount - Spoilage Adjustment
Create a summary showing:
Total Gross Inventory Value
Total Final Inventory Value
Difference between the two