Question 1
A company's five sales representatives each recorded distinct monthly sales. Use the clues to analyze:
- Mira sold more units than Zoya.
- The highest sale was in Nov.
- Ira sold fewer units than Hina.
Question: Who recorded the highest sales?
Spreadsheet Reasoning
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Mira | Mar | 277
Zoya | Jun | 147
Ira | Nov | 324
Hina | Feb | 226
Cyrus | May | 253
Identify the maximum sales row to answer the query.
Verification:
- Mira sold more units than Zoya.
- The highest sale was in Nov.
- Ira sold fewer units than Hina.
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Mira | Mar | 277
Zoya | Jun | 147
Ira | Nov | 324
Hina | Feb | 226
Cyrus | May | 253
Identify the maximum sales row to answer the query.
Verification:
- Mira sold more units than Zoya.
- The highest sale was in Nov.
- Ira sold fewer units than Hina.