Data Arrangement Worksheet 2 - Beginner Level (information sorting) | 20 Questions

Question 1

A company's five sales representatives each recorded distinct monthly sales. Use the clues to analyze: - Fatima sold more units than Mira. - The highest sale was in Sep. - Gaurav sold fewer units than Ira. Question: Who recorded the highest sales?

Spreadsheet Reasoning
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Fatima | Mar | 144
Mira | Feb | 231
Gaurav | Sep | 315
Ira | May | 159
Jatin | Jan | 213
Identify the maximum sales row to answer the query.
Verification:
- Fatima sold more units than Mira.
- The highest sale was in Sep.
- Gaurav sold fewer units than Ira.

spreadsheet, real-world, sales, medium, months

Question 2

Consider the following five database-like records with unique fields (ID, Name, City, Score). Using the clues, determine relationships and answer: - The record with ID 756 has a higher score than the record from Bengaluru. - Aarav's score is not the lowest. - The person from Hyderabad has an ID greater than 855. Question: Which city corresponds to the highest score?

Relational Reasoning (DB-style)
Think in terms of unique-key constraints across fields (ID, Name, City, Score).
ID | Name | City | Score
--- | --- | --- | ---
912 | Rhea | Chennai | 91
221 | Diya | Bengaluru | 73
774 | Aarav | Mumbai | 84
756 | Fatima | Hyderabad | 98
855 | Jatin | Delhi | 70
Use comparative score clues and ID inequalities to identify maxima/minima.
Verification:
- The record with ID 756 has a higher score than the record from Bengaluru.
- Aarav's score is not the lowest.
- The person from Hyderabad has an ID greater than 855.

database, records, constraints, hard, keys

Question 3

Five students attempted a test and received distinct ranks (1 best to 5 worst), took distinct times, and attempted distinct subjects. Use the clues: - The student ranked 1 finished earlier than the one who attempted Music. - Uma did not take 63 minutes and is not ranked 4. - The fastest finisher attempted Physics. - The one ranked 3 took more time than Priya. Question: Who secured Rank 1?

Multi-Parameter Optimization
Set up a table: Student x (Rank, Time, Subject). Use rank-time inequalities and subject anchors (fastest subject).
Student | Rank | Time(min) | Subject
--- | --- | --- | ---
Omar | 1 | 43 | History
Wafa | 2 | 35 | Music
Uma | 3 | 63 | Science
Yash | 4 | 65 | Physics
Priya | 5 | 60 | Chemistry
Integrate constraints across dimensions and validate uniqueness.
Verification:
- The student ranked 1 finished earlier than the one who attempted Music.
- Uma did not take 63 minutes and is not ranked 4.
- The fastest finisher attempted Physics.
- The one ranked 3 took more time than Priya.

integration, rank, time, subject, hard, olympiad

Question 4

Eight persons sit around a square table facing the center; four at corners and four at middle of sides. How many middle-seated persons are there between Fatima and Ira clockwise starting from Fatima?

Square Seating Strategy
Label positions in clockwise order as C1, M1, C2, M2, C3, M3, C4, M4. Corners are even-indexed if starting at C1=0.
Traverse clockwise from X to Y and count middle positions encountered.
One valid order (clockwise): Kaira -> Mira -> Qadir -> Zoya -> Ira -> Nihal -> Fatima -> Eshan
Verification:
- Corners and middles alternate.
- Counting excludes the starting and ending persons.
- Computed count matches traversal.

rectangular, square-table, corners, middles, medium

Question 5

Eight people Gaurav, Yash, Mira, Vihaan, Tara, Kaira, Zoya, Priya sit in a row facing north. Clues: - Yash sits at an even-numbered position (2, 4, 6, or 8). - There are exactly two persons between Yash and Priya. - Zoya does not sit at any extreme end. - Kaira sits at position 1. Question: How many persons sit between Vihaan and Mira?

Logical Flow:
1. Yash is at position 8 (even position).
2. Distance between Yash and Priya is exactly 3 seats → Priya at position 5.
3. Zoya cannot be at position 1 or 8 → Zoya at position 7.
4. Kaira is fixed at position 1.
Arrangement: Position 1: Kaira; Position 2: Vihaan; Position 3: Gaurav; Position 4: Tara; Position 5: Priya; Position 6: Mira; Position 7: Zoya; Position 8: Yash

linear, single-row, positions, medium, distance, position-number

Question 6

Six people sit in a row facing North. Conditions: - Cyrus sits at the extreme right end (Position 6). - There are three people sitting between Ira and Xavier. - Uma sits third to the right of Xavier. - Neither Diya nor Tara sits at any extreme end. Question: Who is sitting at the immediate right of Uma?

Ambiguity Strategy: Proving Non-Unique Solution
Step 1: Fix D (P6). Use the 'three between' clue (Clue 2) to determine the positions of F (P5) and B (P1).
Step 2: Use E's position (Clue 3) to fix E (P4).
The arrangement is fixed at: B, P2, P3, E, F, D.
Step 3: The remaining people are A and C for positions P2 and P3. Clue 4 prevents them from being at the ends, leaving two cases:
- Case 1: Xavier, Diya, Tara, Uma, Ira, Cyrus
- Case 2: Xavier, Tara, Diya, Uma, Ira, Cyrus
The person immediately right of E is F in both valid cases, so the answer is uniquely determined.

linear, ambiguity, cannot-be-determined, gmat, cat

Question 7

Nine distinct persons are arranged in a 3x3 matrix; each cell has exactly one person with a unique color. - The center cell is occupied by Xavier who likes Purple. - Cyrus sits opposite Mira on the grid edges. - Wafa is at a corner and does not like Pink. - Mira is adjacent to Fatima. Question: In a 3x3 grid (rows and columns numbered 1 to 3), who occupies the cell at row 1, column 1?

Matrix/Spreadsheet Strategy
Label the grid with coordinates (r,c). Use definite placement clues (center, corners, opposites, adjacency) first.
Convert verbal relations to coordinate constraints and eliminate inconsistent options.
A consistent placement is:
C1 | C2 | C3
--- | --- | ---
Uma/Blue | Zoya/Brown | Wafa/Yellow
Cyrus/Orange | Xavier/Purple | Mira/Pink
Gaurav/Green | Nihal/White | Fatima/Red
Verification:
- Center, opposite, and corner constraints satisfied.
- Adjacency satisfied by orthogonal neighbors.
- Each person/color used exactly once.

matrix, 3x3, adjacency, opposite, hard, olympiad

Question 8

Six people scored distinct marks. Use the clues to rank them from highest to lowest: - Laksh scored more than Omar. - Xavier scored less than Nihal but more than Tara. - Sahil scored the least. Question: Who is ranked third by score (1st = highest)?

Inequality Chain
From highest to lowest: Laksh(score=97) > Nihal(score=91) > Omar(score=73) > Xavier(score=67) > Tara(score=66) > Sahil(score=64)
Use pairwise comparisons to place each person in descending order.
Verification:
- Laksh scored more than Omar.
- Xavier scored less than Nihal but more than Tara.
- Sahil scored the least.

ordering, ranking, scores, medium, inequalities

Question 9

A company's five sales representatives each recorded distinct monthly sales. Use the clues to analyze: - Gaurav sold more units than Zoya. - The highest sale was in Dec. - Bhavya sold fewer units than Xavier. Question: Who recorded the highest sales?

Spreadsheet Reasoning
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Gaurav | Jun | 170
Zoya | Nov | 401
Bhavya | Jul | 328
Xavier | Mar | 475
Nihal | Dec | 476
Identify the maximum sales row to answer the query.
Verification:
- Gaurav sold more units than Zoya.
- The highest sale was in Dec.
- Bhavya sold fewer units than Xavier.

spreadsheet, real-world, sales, medium, months

Question 10

8 persons sit around a circular table facing outward. Who sits second to the left of Mira?

Diagrammatic Approach (Circle)
Place the 8 persons on a circle. For 'facing outward', define directions:
- Left of a person is counter-clockwise; right is clockwise.
From Mira's position, move two seats to the left per the facing rule.
Validate the mapping and confirm the second-left occupant.
One valid circular order (clockwise): Vihaan -> Fatima -> Mira -> Ira -> Tara -> Aarav -> Hina -> Uma
Verification:
- Left/right mapping consistent with facing.
- Second-left computed via modular indexing.
- Computed person matches final arrangement index shift.

circular, facing, left-right, medium, clockwise, anticlockwise

Question 11

Nine distinct persons are arranged in a 3x3 matrix; each cell has exactly one person with a unique color. - The center cell is occupied by Yash who likes Yellow. - Zoya sits opposite Bhavya on the grid edges. - Sahil is at a corner and does not like Black. - Uma is adjacent to Yash. Question: In a 3x3 grid (rows and columns numbered 1 to 3), who occupies the cell at row 2, column 1?

Matrix/Spreadsheet Strategy
Label the grid with coordinates (r,c). Use definite placement clues (center, corners, opposites, adjacency) first.
Convert verbal relations to coordinate constraints and eliminate inconsistent options.
A consistent placement is:
C1 | C2 | C3
--- | --- | ---
Nihal/Pink | Uma/Blue | Rhea/Green
Bhavya/Black | Yash/Yellow | Zoya/Brown
Sahil/Red | Vihaan/White | Priya/Purple
Verification:
- Center, opposite, and corner constraints satisfied.
- Adjacency satisfied by orthogonal neighbors.
- Each person/color used exactly once.

matrix, 3x3, adjacency, opposite, hard, olympiad

Question 12

A company's five sales representatives each recorded distinct monthly sales. Use the clues to analyze: - Sahil sold more units than Kaira. - The highest sale was in Jul. - Ira sold fewer units than Rhea. Question: Who recorded the highest sales?

Spreadsheet Reasoning
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Sahil | Jul | 487
Kaira | Jan | 303
Ira | Sep | 328
Rhea | May | 318
Wafa | Oct | 342
Identify the maximum sales row to answer the query.
Verification:
- Sahil sold more units than Kaira.
- The highest sale was in Jul.
- Ira sold fewer units than Rhea.

spreadsheet, real-world, sales, medium, months

Question 13

Eight people sit in two rows of four each. Row-1 faces south and Row-2 faces north. Opposite seats align by index. - Cyrus sits opposite Tara. - Zoya sits second from one end. - Aarav sits at an extreme end. - The person opposite Vihaan is not at an extreme end. Question: Who sits directly opposite Aarav?

Table Method: Row-1 (top, South-facing) and Row-2 (bottom, North-facing) are parallel.
Fixed: Cyrus opposite Tara. Use the end constraints on Aarav and the non-end constraint for the person opposite Vihaan.
One valid arrangement:
Row-1 (South, L→R): Cyrus, Zoya, Rhea, Wafa
Row-2 (North, L→R): Tara, Gaurav, Aarav, Vihaan
Verification:
- Cyrus sits opposite Tara.
- Zoya sits second from one end.
- Aarav sits at an extreme end.
- The person opposite Vihaan is not at an extreme end.

double-row, facing, opposites, easy, ssc

Question 14

Five students attempted a test and received distinct ranks (1 best to 5 worst), took distinct times, and attempted distinct subjects. Use the clues: - The student ranked 1 finished earlier than the one who attempted Science. - Omar did not take 75 minutes and is not ranked 4. - The fastest finisher attempted Geography. - The one ranked 3 took more time than Gaurav. Question: Who secured Rank 1?

Multi-Parameter Optimization
Set up a table: Student x (Rank, Time, Subject). Use rank-time inequalities and subject anchors (fastest subject).
Student | Rank | Time(min) | Subject
--- | --- | --- | ---
Aarav | 1 | 30 | Math
Kaira | 2 | 66 | Science
Omar | 3 | 75 | English
Uma | 4 | 34 | Geography
Gaurav | 5 | 51 | Music
Integrate constraints across dimensions and validate uniqueness.
Verification:
- The student ranked 1 finished earlier than the one who attempted Science.
- Omar did not take 75 minutes and is not ranked 4.
- The fastest finisher attempted Geography.
- The one ranked 3 took more time than Gaurav.

integration, rank, time, subject, hard, olympiad

Question 15

Seven persons sit in a row facing north. Clues: - B sits second from left. - A is at the right end. - E is immediately right of F. - C is left of D. - G is not at an end. Question: Who is seated third from the left end?

Arrangement: ['G', 'B', 'C', 'F', 'E', 'D', 'A']

linear, single-row, positions, easy, ssc, banking, count-between, ends, north-facing

Question 16

Five persons have distinct heights. Use the clues to determine their relative heights: - Gaurav is taller than Uma. - Kaira is shorter than Yash but taller than Zoya. - Uma is not the tallest. Question: Who is the tallest among them?

Ordering by Comparative Statements
Heights ascending: Zoya(154cm) < Kaira(173cm) < Yash(182cm) < Uma(185cm) < Gaurav(189cm)
Place by pairwise comparisons; confirm unique top and bottom.
Verification:
- Gaurav is taller than Uma.
- Kaira is shorter than Yash but taller than Zoya.
- Uma is not the tallest.

ordering, size, heights, easy, comparatives

Question 17

Eight people Priya, Zoya, Diya, Nihal, Laksh, Kaira, Sahil, Uma sit in a row facing north. Clues: - Uma sits at an even-numbered position (2, 4, 6, or 8). - There are exactly two persons between Uma and Nihal. - Diya does not sit at any extreme end. - Zoya sits at position 2. Question: At which position from the left does Nihal sit?

Logical Flow:
1. Uma is at position 8 (even position).
2. Distance between Uma and Nihal is exactly 3 seats → Nihal at position 5.
3. Diya cannot be at position 1 or 8 → Diya at position 6.
4. Zoya is fixed at position 2.
Arrangement: Position 1: Sahil; Position 2: Zoya; Position 3: Kaira; Position 4: Priya; Position 5: Nihal; Position 6: Diya; Position 7: Laksh; Position 8: Uma

linear, single-row, positions, medium, distance, position-number

Question 18

Seven persons sit in a row facing north. Clues: - B sits second from left. - A is at the right end. - E is immediately right of F. - C is left of D. - G is not at an end. Question: Who is seated third from the left end?

Arrangement: ['G', 'B', 'C', 'F', 'E', 'D', 'A']

linear, single-row, positions, easy, ssc, banking, count-between, ends, north-facing

Question 19

Six persons have distinct preferences across Brand, Sport, and Vehicle. Using the clues, determine the complete mapping and answer: - Jatin does not prefer Delta or Basketball. - The one who prefers Eta drives Bus. - Qadir plays Tennis, and the one who drives Truck prefers Epsilon. - Neither Sahil nor Yash prefers Kappa. - The Volleyball player does not drive Bike. - If someone prefers Beta, then they do not play Hockey. Question: Who drives the Ship?

CAT/GMAT-Style Multi-Parameter Table
Create a 6x4 table (Person x Brand x Sport x Vehicle).
Apply constraints in layers: negative exclusions first, then direct mappings, then conditional implications.
- Jatin does not prefer Delta or Basketball.
- The one who prefers Eta drives Bus.
- Qadir plays Tennis, and the one who drives Truck prefers Epsilon.
- Neither Sahil nor Yash prefers Kappa.
- The Volleyball player does not drive Bike.
- If someone prefers Beta, then they do not play Hockey.
Continue elimination until each row has a unique triplet.
Verified final mapping:
Person | Brand | Sport | Vehicle
--- | --- | --- | ---
Jatin | Eta | Volleyball | Ship
Omar | Delta | Hockey | Truck
Qadir | Kappa | Basketball | Bike
Sahil | Beta | Chess | Bus
Yash | Theta | Tennis | Metro
Cyrus | Epsilon | Athletics | Car
Efficiency tip: Track constraints per attribute as sets; propagate implications ('If A then not B').
Verification:
- Each attribute used exactly once across persons.
- All conditional and negative clues hold.
- No contradictions; unique solution obtained.

multi-parameter, conditional, hard, cat, gmat, table

Question 20

A company's five sales representatives each recorded distinct monthly sales. Use the clues to analyze: - Zoya sold more units than Yash. - The highest sale was in May. - Jatin sold fewer units than Wafa. Question: Who recorded the highest sales?

Spreadsheet Reasoning
Create a table of (Rep, Month, Sales) and use inequality clues to rank.
Rep | Month | Sales
--- | --- | ---
Zoya | May | 475
Yash | Mar | 170
Jatin | Jul | 449
Wafa | Sep | 220
Tara | Jun | 133
Identify the maximum sales row to answer the query.
Verification:
- Zoya sold more units than Yash.
- The highest sale was in May.
- Jatin sold fewer units than Wafa.

spreadsheet, real-world, sales, medium, months

Data Arrangement - Beginner Level: information sorting BEGINNER

What you'll learn in this worksheet:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20