Information Communication Technology ICT – 18 Databases | e-Consult
18 Databases (1 questions)
Login to see all questions.
Click on a question to view the answer
To sort the products by price in descending order using a spreadsheet program, I would follow these steps:
- Enter the Data: I would enter the product names and their corresponding prices into two separate columns in the spreadsheet. For example:
Product Price (£) Laptop 1200 Tablet 300 Phone 800 Headphones 50 Smartwatch 200 - Select the Data: I would select both columns of data (Product and Price).
- Apply the Sort Function: I would go to the 'Data' tab and click on the 'Sort' button.
- Specify the Sorting Criterion: In the Sort dialog box:
- Under 'Sort by', I would select the 'Price (£)' column.
- Under 'Order', I would select 'Largest to Smallest' (which corresponds to descending order).
- Confirm the Sort: I would click 'OK'.
The spreadsheet program will then sort the products based on their prices, with the most expensive product (Laptop) appearing first.
| Product | Price (£) |
| Laptop | 1200 |
| Phone | 800 |
| Tablet | 300 |
| Smartwatch | 200 |
| Headphones | 50 |