Data Manipulation and Analysis : แบบฝึกหัด

In a spreadsheet containing student records, you have student names in column A and their scores in column B. To arrange all student records such that the student with the lowest score appears first, and the student with the highest score appears last, which data manipulation technique would you use?

A spreadsheet tracks orders with columns: Region, Product, and Amount. You need to display only orders from the 'East' region for the 'Electronics' product category where the Amount is greater than $$500$$. Which of the following best describes the filtering approach?

A database table ScoreTable contains the fields StudentID, Subject, and Mark. A teacher needs to identify students whose average mark across all their subjects is greater than \( 80 \). Which of the following SQL statements will correctly achieve this?

A spreadsheet contains a list of products in Column A and their prices in Column B. To arrange the products alphabetically by name, which data manipulation technique would be used?

A column in a spreadsheet, from cell D2 to D10, contains the scores of students. Which function would correctly calculate the average score of these students?

Which spreadsheet function would be used to find the smallest number in a range of cells from E1 to E20?

Explain how a 'what-if' analysis in a spreadsheet can help a business decide on the optimal pricing strategy for a new product.

A spreadsheet contains a column of student IDs. If you want to arrange these IDs in ascending order, which data manipulation technique would you apply?