Question 1
A company's five sales representatives each recorded distinct monthly sales. Use the clues to analyze:
- Diya sold more units than Priya.
- The highest sale was in Jun.
- Uma sold fewer units than Mira.
Question: Who recorded the highest sales?
Spreadsheet Reasoning
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Diya | Aug | 201
Priya | Feb | 295
Uma | Jul | 379
Mira | Oct | 195
Ira | Jun | 392
Identify the maximum sales row to answer the query.
Verification:
- Diya sold more units than Priya.
- The highest sale was in Jun.
- Uma sold fewer units than Mira.
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Diya | Aug | 201
Priya | Feb | 295
Uma | Jul | 379
Mira | Oct | 195
Ira | Jun | 392
Identify the maximum sales row to answer the query.
Verification:
- Diya sold more units than Priya.
- The highest sale was in Jun.
- Uma sold fewer units than Mira.