DigitalSkill Loft

  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,  

  Unit-4       Advanced Features of Web – Design     Code View, Add-Ins, Snippets ad Page Transitions:-   Code view IntelliSense is a feature that automatically provides you a list of codes and attributes as a popup when you work in the code view mode. Add-ins Add-ins extends the capability of the main program by adding enhanced custom commands and specialized features. You can download a variety of Add-ins from: ·   http://msdn.microsoft.com/en-us/expression/jj873995.aspx ·         http://www.webassist.com/go/xweb-add-ins ·         http://www.expressionextras.com/products/lightbox.htm ·         http://www.dotnetcurry.com/ShowArticle.aspx?ID=534 Snippets Snippets are pieces of programs re-used by most developers. Snippets are useful as you can keep reusing the code created many times across multiple web pages or web sites saving enormous amount of time and effort.   PSD Templates You need