14 Sep 2011

TN-PIN/STD/ISD Code Finder

How Big Is a Worksheet?

It's interesting to stop and think about the actual size of a worksheet. Do the arithmetic (16,384 × 1,048,576), and you'll see that a worksheet has 17,179,869,184 cells. Remember that this is in just one worksheet. A single workbook can hold more than one worksheet. If you're using a 1024 × 768 video mode with the default row heights and column widths, you can see 15 columns and 25 rows (or 375 cells) at a time - which is about .000002 percent of the entire worksheet. In other words, more than 45 million screens of information reside within a single worksheet.If you were to enter a single digit into each cell at the relatively rapid clip of one cell per second, it would take you about 545 years, nonstop, to fill up a worksheet. To print the results of your efforts would require more than 40 million sheets of paper - a stack more than a mile high. As you might suspect, filling an entire workbook with values is not possible.

2 Sep 2011

Useful Excel Websites

Microsoft (MS) Excel is a powerful spreadsheet that is easy to use and allows you to store, manipulate, analyse, and visualize data. There are many websites are available to learn & share our knowledge. The below websites provides you several online help options, such as interactive tutorials and topic specific searchable help files.