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
   312   313   314   315   316   317   318   319   320   321   322