Introduction of MS Excel 2007
- MS Excel is a spreadsheet package.
- This is application software which is part of MS Office.
- Its extension name is .xlsx
- In this work related to data entry and calculations.
(WorkBook Configuration)
How to Open MS Excel 2007
Workbook :-
MS Excel's file is called Workbook. A workbook is a group of worksheets. It means a workbook can contain many worksheets. Three worksheets are found by default in a workbook.
WorkSheet:-
A worksheet is a type of table made up of rows and columns. The worksheet is also known as spreadsheet.
Columns:-
The group of cells running downwards from the top of the sheet is called a column, they are represented by alphabet. In MS Excel 2007, they start from A and run till XFD and their total number is 16384.
Rows:-
When the row and column cut each other. Small boxes creates, which are called cells. Each cell has its own identity which is called cell reference or cell address.
Cells:-
When the row and column cut each other. Small boxes creates, which are called cells. Each cell has its own identity which is called cell reference or cell address.
Types of cell reference :-
Relative Cell Reference:-In this, the heading of the column is followed by the heading of the row for cell reference.
Absolute cell reference:- Put a dollar ($) sign before writing the column and row headings.
Mixed/Hybrid Cell Reference:- Once the dollar ($) symbol appears in it, if you want it before the column heading or before the row heading name.
Example - $A1 OR A$1
No comments:
Post a Comment