All Courses
Explore Courses UPSC Exam UPSC Test Series Free Notes EduRev Infinity Get the App Login Join for Free
Sign in Open App
CAT Exam  >  CAT Questions  >  The software development team of Cracku has c... Start Learning for Free
SaveJoin the Discussion on the App
The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by '#' followed by the alphabet(s) representing the column.
For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.
Based on the information given above, answer the questions that follow.
If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.
  • a)
    JV#JV
  • b)
    IV#IV
  • c)
    JU#JU
  • d)
    IU#IU
Correct answer is option 'B'. Can you explain this answer?
FREE This question is part of
Download PDF Attempt Test
Download PDF Attempt this Test
Verified Answer
The software development team of Cracku has come up with a new spreads...
65536 = 256 x 256
Hence, the sum of rows and columns will be minimum when the number of rows, as well as the number of columns, is 256.
Hence the last cell should be in the form of (256,256)
256 = 260 - 4 = 26 X 10 - 4
A - Z → 26
AA - AZ → 26
BA - BZ → 26
CA - CZ → 26
DA - DZ → 26
EA - EZ → 26
FA - FZ → 26
GA - GZ → 26
HA - HZ → 26
IA - IZ → 26
IZ is the 260th term, hence the 256th term should be IV
Hence the cell should be represented as IV#IV.
View all questions of this test
Most Upvoted Answer
The software development team of Cracku has come up with a new spreads...
Calculation of Total Rows and Columns
- To find the least possible sum of the number of rows and columns that would result in a total of 65536 cells, we need to consider that the product of the number of rows and columns should equal 65536, while keeping the sum minimal.
- The factors of 65536 are 2^16, so we need to find the closest pair of factors whose sum is minimal.
- The pair of factors closest to each other and whose sum is minimal would be 256 rows and 256 columns.

Determining the Last Cell
- With 256 rows and 256 columns, the last row would be IV and the last column would be IV.
- The last cell would be the intersection of the last row and the last column, which is denoted by IV#IV.
Therefore, the sequence of characters denoting the last cell of the sheet would be IV#IV, making option 'B' the correct choice.
Attention CAT Students!
To make sure you are not studying endlessly, EduRev has designed CAT study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in CAT.
< Previous Question Next Question >
Explore Courses for CAT exam

Similar CAT Doubts

The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.Q. A spreadsheet has 26 rows and 78 columns. All cells whose representations(row#column) has at least 1 vowel in them are called vowel cells. How many non-vowel cells are present in this sheet? Correct answer is '882'. Can you explain this answer?

The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.Q. The distance between 2 cells is calculated as follows:In the new notation, suppose all the rows and columns were numbered starting from 1, 2, 3,.... and so on instead of A, B, C,... AA,... such that A corresponds to 1, AA corresponds to 27 and so on.The distance between 2 cells =where r1,r2are the row numbers of the first and second cells respectively and c1,c2are the column numbers of the first and second cells respectively.If the distance between UVX#AAAZ and VAT#ZWD is d, and the distance between A#XG and XG#A is e.What is the value ofe/d?

The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.Q. The distance between 2 cells is calculated as follows:In the new notation, suppose all the rows and columns were numbered starting from 1, 2, 3,.... and so on instead of A, B, C,... AA,... such that A corresponds to 1, AA corresponds to 27 and so on.The distance between 2 cells =where r1,r2are the row numbers of the first and second cells respectively and c1,c2are the column numbers of the first and second cells respectively.Below mentioned are a few pair of points in the old notation. Which of them are farthest from each other?

Directions for Questions: The figure below shows the street map for a certain region with the street intersections marked from a through l. A person standing at an intersection can see along straight lines to other intersections that are in her line of sight and all other people standing at these intersections. For example, a person standing at intersection g can see all people standing at intersections b, c, e, f, h, and k. In particular, the person standing at intersection g can see the person standing at intersection e irrespective of whether there is a person standing at intersection f.Six people U, V, W, X, Y, and Z, are standing at different intersections. No two people are standing at the same intersection.The following additional facts are known.1. X, U, and Z are standing at the three corners of a triangle formed by three street segments.2. X can see only U and Z.3. Y can see only U and W.4. U sees V standing in the next intersection behind Z.5. W cannot see V or Z.6. No one among the six is standing at intersection d.(2019)Q. Should a new person stand at intersection d, who among the six would she see?

Directions for Questions: The figure below shows the street map for a certain region with the street intersections marked from a through l. A person standing at an intersection can see along straight lines to other intersections that are in her line of sight and all other people standing at these intersections. For example, a person standing at intersection g can see all people standing at intersections b, c, e, f, h, and k. In particular, the person standing at intersection g can see the person standing at intersection e irrespective of whether there is a person standing at intersection f.Six people U, V, W, X, Y, and Z, are standing at different intersections. No two people are standing at the same intersection.The following additional facts are known.1. X, U, and Z are standing at the three corners of a triangle formed by three street segments.2. X can see only U and Z.3. Y can see only U and W.4. U sees V standing in the next intersection behind Z.5. W cannot see V or Z.6. No one among the six is standing at intersection d.(2019)Q. What is the minimum number of street segments that X must cross to reach Y?

Top Courses for CATView all

Top Courses for CAT

The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer?
Question Description
The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer? for CAT 2024 is part of CAT preparation. The Question and answers have been prepared according to the CAT exam syllabus. Information about The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer? covers all topics & solutions for CAT 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer?.
Solutions for The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer? in English & in Hindi are available as part of our courses for CAT. Download more important topics, notes, lectures and mock test series for CAT Exam by signing up for free.
Here you can find the meaning of The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer?, a detailed solution for The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer? has been provided alongside types of The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice The software development team of Cracku has come up with a new spreadsheet viewing and editing application. The rows are denoted by alphabet(s) starting with A, B, C,..., Z, followed by AA, AB,..., AZ, BA,..., ZZ, followed by AAA, AAB,..... and so on. The columns are denoted in the same way. A cell, which is an intersection of a row and column is denoted by the alphabet(s) representing the row followed by # followed by the alphabet(s) representing the column.For example, the cell at the intersection of the 27th row and 8th column is denoted by AA#H.Based on the information given above, answer the questions that follow.If there is a total of 65536 cells in a spreadsheet, such that the sum of the number of rows and the number of columns is the least possible, what is the sequence of characters denoting the last cell of the sheet? The last cell is the cell at the intersection of the last row and the last column.a)JV#JVb)IV#IVc)JU#JUd)IU#IUCorrect answer is option 'B'. Can you explain this answer? tests, examples and also practice CAT tests.
Explore Courses for CAT exam

Top Courses for CAT

Explore Courses

Suggested Free Tests

Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev
Get App
© EduRev
Education Revolution
Follow Us
Signup to see your scores go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup