office automation dit notes ms excel

 office automation dit notes ms excel

A spreadsheet is basically a matrix of rows and columns. Consider a sheet of paper with horizontal and vertical lines The result is a grid, ie a cell, designed to get a rectangular grid Of a row intersection with a column. Such a structure is called a Spreadsheet.

The electronic equivalent of a pen in a spreadsheet package, A eraser, and a large sheet of paper with vertical and horizontal lines Enter rows and columns. The position of the cursor is uniquely displayed in the dark The position indicates where the pen is pointing at the moment. We can enter text Or numbers on any position on the worksheet. We can enter a formula In a cell where we want to calculate and have results Obviously a powerful recount facility comes into play every time We update the contents of the cell with new data. MS Excel is a powerful spreadsheet package Microsoft.

There are three main components to this package Electronic spreadsheet Database management Preparation of charts. Each workbook contains 3 worksheets with facilities that are added Number of sheets. Each sheet contains 256 columns and 65536 rows To work with Although the spreadsheet packages were originally Designed for accountants, they have become almost popular Everyone is working with statistics. Sales executives, book holders, Officers, students, research scholars, investors, bankers, etc., almost anyone One finds some form of application for it.

You will learn the following features at the end of this section.

• Excel 2003 is launching
• Using help
• Workbook management
• Cursor management
• Manipulating data
• Use of formulas and functions
• Formatting a spreadsheet
• Printing and layout
• Creating charts and graphs

office automation dit notes ms excel pdf