Page 317 - IT_V1.0_Class10
P. 317
18. Consider the following spreadsheet:
• Calculate the average unit sold in cell B8.
• Maximise the average number of units sold to 95.
• The criteria for maximising the average number of units sold is as follows:
B2 <= 88
B3 >= 82
B4 <= 90
B5 >= 60
19. Create a table named Sales in Design View with the columns: product_id, product_name, unit_price,
and units_sold.
• Insert some sample data into the Sales table. You can include at least 5 different products with varying
prices and unit sales.
• Display all products and their total sales amount (unit_price * units_sold).
• Find the product with the highest total sales amount.
• Show all products with a unit price greater than a specific value (user input).
• Calculate the average unit price across all products.
20. Consider the following Employee table:
EmployeeID FirstName LastName Department Salary
1 Aarav Patel IT 60000
2 Riya Sharma HR 55000
3 Kabir Gupta Sales 62000
4 Ananya Reddy IT 58000
5 Advik Joshi Sales 60000
• Create a report by using the Employee table.
• Format the report according to the requirement.
• Add the page number in the footer of the report.
Practical Work 315

