Page 102 - Computer - 5
P. 102
Database Subject Enrichment
Some fun facts about Excel are:
• A single cell in Excel can contain up to 32767 characters.
• Excel 3.0 was the first ever desktop application to implement a toolbar in 1990.
• You cannot rename a worksheet History as it’s a keyword reserved for internal working
of Excel.
• Every Excel worksheet has 1048576 rows and 16384 columns, which is 17179869184 cells.
Post-Processing
A Spreadsheet organises data in a tabular format, made up of rows and
columns.
A file in Excel is called a Workbook. Each workbook contains one or more
pages called Worksheets.
A worksheet in Excel 2019 contains 1048576 rows and 16384 columns.
Data in Excel can be number, text, or formula.
A group of cells is called a Cell Range.
A Workbook in Excel 2019 contains only one worksheet by default. More
worksheets can be added as required.
INFO RETENTION
INFO RETENTION
A. Tick [3] the correct option.
1. A workbook in Excel 2019 is saved with the extension ______.
.exls .xlsx .wrbk .wrks
2. The number of columns in a worksheet in Excel 2019 is ______.
16384 256 4096 65536
3. The cell in a worksheet that can accept data is called ______.
Active cell Ready cell Action cell Current cell
4. The default number of worksheets in Excel 2019 workbook is ______.
3 1 2 10
5. The address of the active cell is displayed in the ______.
Formula bar Title bar Name box Ribbon
100