Class 9th Unit-4 Electronic Spreadsheet
Unit-4 Electronic Spreadsheet Spreadsheet . . Spreadsheet application is tool which is used to perform all kinds of calculations easily and accurately. Spreadsheet is a long sheet of rows and columns on the computer screen to do data analysis and calculation. It is used for managing financial and accounting documents, creating data reports, generating invoices. Features of Spreadsheet • Simple mathematical calculations • Complex calculations using formula and functions • Arranging data in ascending and descending order (sorting) • Filtering the required data • Check the validity of data • Protection of data using passwords • Saving for future use Worksheet: The worksheet in Calc is also referred to as spreadsheet. The spreadsheet can have many sheets. Each sheet can have many individual cells arranged in rows and columns. The sheet tab shows its default 3 sheet in workbook,