Page 275 - Computer - 10(A&B)

• Open Goal Seek from the Tools menu.

• In the Set cell box, enter E2, the cell where the total profit is calculated.

• In the To value box, enter the desired profit value from cell F2.
• In the By changing cell box, enter D2, the cell representing the quantity sold.
• Click the OK button.

The Goal Seek calculates and displays the result achieved. Click the Yes button to accept the value in cell D2.

• Calculate the quantity sold for each of the remaining products and fill the cells in column D with the result
achieved.
• Save your work.

Database Management System
Project 1
Create an “Order Management” database in LibreOffice Base to manage customer orders by inserting two tables,
setting their relationships, and ensuring referential integrity to ensure data consistency and integerity.
• Launch LibreOffice Base on your computer and create a new database “Order Management”.
• Create a table named “Customers” including the following fields: CustomerId, CustomerName, and
ContactNumber. Set the CustomerId field as the primary key for the table.

157