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.
 
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?
    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...
    Let us consider the 26 rows and the first 26 columns.
    It is in the form of 

    All the cells in column A are vowel cells, similarly, for all other vowels, all cells in that particular column are vowel cells. 
    Also, all cells in row A are vowel cells, similarly, all cells in other rows denoted by vowels are vowel cells. Hence, in this 26 x 26 grid, number of vowel cells = 26 x 5 + 26 x 5 - number of cells counted twice
    The number of cells counted twice = number of cells that fall in the intersection of a vowel row and a vowel column = 5 x 5 = 25.
    Hence, total vowel cells = 26 x 5 + 26 x 5 - 25 = 235
    Hence, non-vowel cells = 26 x 26 - 235 = 441
    If we consider a similar grid, but instead of columns A to Z, we consider columns AA to AZ, in this grid, since all columns have A in them, all the cells are vowel cells. 
    Considering the last grid, columns BA to BZ, and rows A to Z, it is exactly similar to the first grid. Hence, the number of non-vowel cells are 441
    Hence, total count = 882.
    View all questions of this test
    Most Upvoted Answer
    The software development team of Cracku has come up with a new spreads...
    Understanding the Problem:
    To solve this problem, we need to first understand the concept of vowel cells in the given spreadsheet. Vowel cells are those cells whose representation contains at least one vowel.

    Calculating the Total Cells:
    Given that the spreadsheet has 26 rows and 78 columns, the total number of cells in the spreadsheet can be calculated by multiplying the number of rows and columns. Therefore, Total cells = 26 * 78 = 2028.

    Finding Vowel Cells:
    To find the number of vowel cells, we need to determine the total number of cells that do not contain any vowels in their representation. Since there are 5 vowels (A, E, I, O, U), there are 21 consonants in the English alphabet. Therefore, the number of non-vowel cells = 21 * 21 = 441.

    Calculating Non-Vowel Cells:
    To find the number of non-vowel cells, we subtract the number of vowel cells from the total number of cells. Therefore, Non-vowel cells = Total cells - Vowel cells = 2028 - 441 = 1587.

    Final Answer:
    Hence, there are 882 non-vowel cells present in the spreadsheet.
    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. 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?

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

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

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