- An Excel sheet contains 1,048,576 rows, 16,384 columns, and more than 17 Billion cells.
- Width of a column can be maximum 255 characters i.e. one can type maximum 255 characters in a column. And the characters that can be entered in header and footer in Excel 2007 are 255.
- An Excel sheet can be split in maximum four panes and you can add 64000 sheets in.xls or.xlsx file created using MS Excel 2007. These sheets can be used to refer each other.
- Maximum 256 users can open and share the already shared the.xls or.xlsx file at the same time, which is a good for people working in sharing mode.
- Data form - the most commonly used feature of MS Excel 2007. A form is often used to collect information in fast and flawless manner. You can add maximum of 32 fields like Sr. No, Name, Address Line 1, Address Line 2, Contact Number, etc. in a Data form.
- List of the available functions is quite large. Here, in this spreadsheet application, you are provided with more than 300 built-in functions that can be used for various functions like calculation, subtraction, etc. Some of the available functions are Sum, Average, Max, Min, And, If, Else, Not, Or, True, etc.
- Functions can be nested up to 64 levels.
- While using a spreadsheet, you may need to undo any recent entry. MS Excel 2007 allows you to undo actions up to 100 times.
- You can zoom an Excel sheet from 10% to 400% depending on your needs. For example, if you want to view the data in large mode then you can simply zoom the file.
- You cannot add more than 8192 characters while creating a function in this spreadsheet application.
2: subjects in school you might need to use a spreadsheet:
maths to do maths coclacoions
social studies to do chaets
- Letters at the top
- Numbers down the side
- Cell reference
- Active cell
- formula
- =
- +
- -
- *
- /
