Question 1
A company's five sales representatives each recorded distinct monthly sales. Use the clues to analyze:
- Hina sold more units than Omar.
- The highest sale was in Nov.
- Mira sold fewer units than Fatima.
Question: Who recorded the highest sales?
Spreadsheet Reasoning
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Hina | Jan | 280
Omar | Nov | 409
Mira | Jun | 178
Fatima | Jul | 265
Cyrus | Apr | 195
Identify the maximum sales row to answer the query.
Verification:
- Hina sold more units than Omar.
- The highest sale was in Nov.
- Mira sold fewer units than Fatima.
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Hina | Jan | 280
Omar | Nov | 409
Mira | Jun | 178
Fatima | Jul | 265
Cyrus | Apr | 195
Identify the maximum sales row to answer the query.
Verification:
- Hina sold more units than Omar.
- The highest sale was in Nov.
- Mira sold fewer units than Fatima.