You have a class list with student names and phone numbers, and your teacher asks you to arrange them alphabetically. You are also required to filter out students from a specific city.
1. Which feature would you use to arrange students' names in alphabetical order?
A. Filter
B. Sort
C. Grouping
2. Which feature should be used to display only students from a specific city (e.g., "Delhi")?
A. Sort
B. Filter
C. Format
3. Which tab in Excel contains the Sort option?
A. Home
B. Data
C. View
Read the scenario and select the correct option.
A ______ is a graphical representation of data in Excel.
The ______ displays the name or description of the chart.
A ______ is a tiny chart that fits in a single cell.
The vertical part of a column chart is called the ______.
Answer (2)
In Excel, the 'Sort' feature is used to order data in a specific sequence, such as alphabetically. You would select the column containing the student names and use the 'Sort' option to arrange them from A to Z or Z to A as required.
Which feature should be used to display only students from a specific city (e.g., "Delhi")?
Correct Option: b. Filter
The correct options for your questions are B. Sort for arranging names alphabetically, B. Filter for displaying students from a specific city, and B. Data for the tab where the Sort option is located. Additionally, a chart represents data graphically, the title describes the chart, a sparkline is a small chart in a cell, and the vertical part of a column chart is called the y-axis.
;
