Merge and center data

1.2. Merge and center data
It is used to combine the selected cells.
Process:
Ø Select required cells
Ø Click on format menu
Ø Choose cells
Ø Choose alignment tab
Ø Choose center from horizontal and vertical alignment
Ø Click on merge cells
Ø Click on ok
1.3. Some common Terms Used in Excel
Spreadsheet
A spreadsheet is an electronic document that stores various types of data .There is Vertical columns and horizontal rows. A cell is where the column and row intersect. A cell can contain data and can be used in calculations of data within the spreadsheet. An Excel spreadsheet can contain workbooks and worksheets. The workbook is the holder for related worksheets.
Row
Set of cells arranged horizontally in a spreadsheet program on in table.
Column
Series of characters, printed or displayed one under the other or set of cells arranged vertically, in Excel, are called columns.
Cell
A cell is an interpreter between rows and columns or is single function or number in a spreadsheet program.
Cell Address
A code that identifies the position of a cell by row and columns. The rows are normally numbered and the columns use the alphabets.
Name Box
This box is situated at the left end of the formula bar that displays the active cell address, chart item, or drawing object. Enter the cell or range.
Current or active cell
The call being edited is an active cell pointer is currently located.
Row Heading
The place where serial numbers of rows are written (on the left side of every rows). There are 65536 rows in a worksheet.
Column Heading
It is the place where alphabetical series of columns are written (at the top of every column). There are 256 columns in a worksheet.
1.4. Moving the cell Pointer
To move the cell pointer (Curser )
One cell left - Left arrow Key
One cell right - Right arrow key
One cell up - Up arrow Key
One cell down - Down arrow key
At the end of the current row - End +Right arrow Key
At the beginning of the row - Home Key
At the beginning of the worksheet
Or in ‘AL’ cell -Ctrl + Home Key
At the end of the data entry cells - Ctrl + End key
At the beginning of the current column - Ctrl +Left arrow Key
Or, click the mouse where you want to enter the data.
Data – Collection of the facts made up of numbers .characters and symbols, stored on a computer in such a way that it can be processed by the computer.
1.5. Basic Idea to Edit Data
Selection of the required data using Keyboard
To Select Press
A single cell -(Move the pointer on the cell)
Cells - Shift +Arrow Keys
From the current cell to beginning of the row - Shift +Home
The current cell to beginning of the worksheet - Ctrl + Shift + Home
The entire column - Ctrl +Spacebar
The entire row - Shift +Spacebar
The entire worksheet - Ctrl +A
With the object selected, select all objects on a worksheet
-Ctrl +Shift +Spacebar