Senior Secondary (HKDSE) · Information and Communication Technology
その場で採点される選択問題 5 問と、解説つきの記述問題 3 問。すべて「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?
まず自分で答えを書いてから、解説と照らし合わせましょう。
※ thinkaのコンテンツはAIにより生成されているため、内容が正確でない場合があります。補助教材としてご使用いただき、公式の教材と合わせてご確認ください。
このページは良い答案の形を示せますが、あなたの答案に何が足りないかは教えられません。thinka は実際の採点基準に沿って記述答案を約 15 秒で採点します。
同じような問題をもっと解きたい？このトピックの新しい問題を、解きながら採点。
練習を始める