Bissoy.com
Doctors Medicines MCQs Q&A

What is the maximum number of rows in a MS Excel 2010 worksheet? 

What is the maximum number of rows in a MS Excel 2010 worksheet?  Correct Answer 1,048,576

The correct answer is 1,048,576.

Key Points

  • Excel has a physical limit of about 1 million rows (1,048,576 rows). 
  • 1,048,576 is simply 2 to the 20th power, and thus this number is the largest that can be represented in twenty bits.
  • Old versions of Excel allowed 65536 rows (2 to the 16th power).
  • This was increased to 1048576 to address complaints that 65536 rows were too few.

Additional Information

Worksheet and workbook specifications and limits:

  • The total number of rows and columns on a worksheet - 1,048,576 rows by 16,384 columns.
  • Column width - 255 characters.
  • Page breaks - 1,026 horizontal and vertical.
  • Row height - 409 points.

Related Questions

There are two rows, each containing 3 numbers. Below are some rules to be used to get the resultant number for each row separately. Use the rule from left to right for each row and find the answer to the question. Rule: 1. If an even number is followed by an even number, then the first number will be subtracted from the second. 2. If an odd number is followed by an odd number, then both will be added. 3. If an odd number is followed by an even number, then the even number will be subtracted from the square of the odd number. 4. If an even number is followed by an odd number, then the odd number will be subtracted from the even number. Row I: 9,11, 34 Row II: 16, 9, 8 What is the difference between the resultant numbers in the first row and the second row
Students of a class are made to sit in rows of equal number of chairs. If number of students is increased by 2 in each row, then the number of rows decrease by 3. If number of students is increased by 4 in each row, then the number of rows decreases by 5. What is the number of students in the class?
There are two rows, each containing 3 numbers. Some rules are given below to be used for obtaining the resultant number for each row separately. Apply the rules for each row from left to right and answer the question. Rules: i. If an even number is followed by an even number, the first is to be subtracted from the second. ii. If an odd number is followed by an odd number, both are to be added. iii. If an odd number is followed by an even number, the even number is to be subtracted from the square of the odd number. iv. If an even number is followed by an odd number, the odd number is to be subtracted from the even number. Row I: 28, 19, 12 Row II: 13, 7, 32 What is the average of the resultant numbers of the first row and the second row?
A number of trees are arranged in 3 rows such that the number of trees in each row is co-prime and the product of the number of trees in first two rows is 551 and the product of the number of trees in last two rows is 1073. How many trees were there in the garden?
When all the students in a school are made to stand in rows of 54, 30 such rows are formed. If the students are made to stand in rows of 45, how many such rows will be formed ?
Study the line graph and answer the question that follows. The line graph represents the number of vehicles (in thousands) manufactured by two automobile companies A and B over the years from 2010 to 2015. The X-axis represents the years and the Y-axis represents number of vehicles in thousands. (The data shown here is only for mathematical exercise. They do not represent the actual figures of the country.) Company B is projecting an increase in the number of vehicles to be manufactured in 2016 by 70% with respect to its average number of vehicles from 2010 to 2015. What should be the approximate percentage increase in the number of vehicles (in thousands) to be manufactured by Company A in 2016 with respect to the number of vehicles in 2015, so that it is at par with Company B?
Which test best described this situation: A teacher while preparing a worksheet removes every sixth word from the text and asks the learner to read the text after they have been asked to complete the worksheet with the missing word.
There are job post vacancies in XYZ Company. The candidate Must be a graduate in any discipline with 75% marks. Must be between 25 and 35 years of age as on 05/03/2021. Must have completed CA or CS. Should have knowledge of Excel and Tally. The following exceptions apply: A. If a candidate fulfills all the other criteria except 4 above, the candidate will be referred to the Manager. B. A candidate who is above 35 years of age but has experience of more than 2 years will be referred to the General Manager. Arun is working in IDBI Bank since 3 years. He was born on 5/02/1982. He has completed his CA in 2010. He has done certified courses on Excel and Tally from NIIT. He did his B.Com (H) from TKM Vidyalaya and secured 80 percentage. What decision should be made about this candidate?
A worksheet can have a maximum of ________ number of rows.
A garden has to plant tress in rows containing equal number of trees. If he plants in rows of 6,8,10 or 12. then five tress are ledt unplated. But if he plants in rows of 13 tress each, then no tress is left. What is the number of tress that the gardener plants?