WAEC Data Processing 2024 Question 20

Question 20

Spreadsheet

The Microsoft Excel menu bar icon shown in Figure 2 is used to

Diagram for this question
  1. A.automatically add up selected values.
  2. B.create label that spans multiple columns.
  3. C.spot trends and patterns in user's data using bars, columns and icons.
  4. D.organize data for easy analysis.
Show the answer and explanation

Answer: D (organize data for easy analysis.)

Explanation

The A–Z and funnel icon is Sort & Filter, which arranges and filters data for easy analysis.