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?a)andradic;2b)andradic;5c)2d)5Correct answer is option 'D'. Can you explain this answer?

EduRev

All Courses

Explore Courses UPSC Exam UPSC Test Series Free Notes EduRev Infinity

Open App

CAT Exam > CAT Questions > The software development team of Cracku has c...

Join the Discussion on the App

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 r₁, r₂ are the row numbers of the first and second cells respectively and c₁, c₂ are 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 of e/d?

a)
√2
b)
√5
c)
2
d)
5

Correct answer is option 'D'. Can you explain this answer?

FREE This question is part of

CAT Mock Test- 4

Attempt Test

Attempt this Test

Verified Answer

The software development team of Cracku has come up with a new spreads...

UVX#AAAZ and VAT#ZWD

Difference between UVX and VAT:

UVX - UWW -> 26

UWX - UXW -> 26

UXX - UYW -> 26

UYX - UZW -> 26

UZX - VAT -> 23

Hence, the difference between UVX and VAT = 26 + 26 + 26 + 26 + 23 - 1 = 126

Difference between AAAZ and ZWD:

ZWD - ZXC -> 26

ZXD - ZYC -> 26

ZYD - ZZC -> 26

ZZD - AAAC -> 26

AAAD - AAAZ -> 23

Hence, the difference between AAAZ and ZWD = 26 + 26 + 26 + 26 + 23 - 1 = 126

Hence, distance d = 126√2

A#XG and XG#A

Difference between A and XG

A - Z -> 26

AA - AZ -> 26

....

WA - WZ -> 26

XA - XG -> 7

Difference between A and XG = 26 + 26 X 23 + 7 - 1 = 630

Hence, the distance between A#XG and XG#A is e = 630√2

Hence, e = 5d.

View all questions of this test

View all answers Start learning for free

< 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. 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?

View 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. 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?

View 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.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.

View answer

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?

View answer

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. Who can V see?

View answer

Top Courses for CATView all

Top Courses for CAT

View all

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?a)√2b)√5c)2d)5Correct answer is option 'D'. Can you explain this answer?

Share with a Friend

Answer this doubt

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.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?a)√2b)√5c)2d)5Correct answer is option 'D'. 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.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?a)√2b)√5c)2d)5Correct answer is option 'D'. 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.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?a)√2b)√5c)2d)5Correct answer is option 'D'. 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.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?a)√2b)√5c)2d)5Correct answer is option 'D'. 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.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?a)√2b)√5c)2d)5Correct answer is option 'D'. 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.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?a)√2b)√5c)2d)5Correct answer is option 'D'. 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.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?a)√2b)√5c)2d)5Correct answer is option 'D'. 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.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?a)√2b)√5c)2d)5Correct answer is option 'D'. 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.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?a)√2b)√5c)2d)5Correct answer is option 'D'. Can you explain this answer? tests, examples and also practice CAT tests.

Explore Courses for CAT exam