#Belajar dasar microsoft excel 2010 pdf how to

The position of previous row will be next row. INSERT + ROW:- This command is used to insert a blank row at the position of cell pointer. Req step:a) Move cell pointer at desired cell b) Give command c) Check mark on desired position for changing cell shifts.

INSERT + CELL:- To insert a blank cell at the position of cell pointer it settles position or previous cell at right or bottom. d) Select target e) Check mark on option. c) Give вЂњEdit + Move or copy sheetвЂќ command.

#Belajar dasar microsoft excel 2010 pdf how to

How to copy one work book to another:a) Open target work book. Req step:- Give command a) Select position b) Check mark on option. EDIT + MOVE OR COPY SHEET:- To copy the message of active sheet in desired sheet. Req step:a) Select sheet from sheet tab b) Give command. EDIT + DELETE SHEET:- This command is used to delete selected sheet from active work book. Req step:a) Select desired row, column and cell b) Give command.ДЎ1. EDIT + DELETE:- This command is used to delete selected row, column and cell from active sheet. EDIT + CUT :- To repeat previous instruction. FILE + PRINT PREVIEW:- To display the preview of sheet which will be print.Дў. FILE + PRINT:- To print all records of active sheet on paper through printer. FILE + PROPERTY:- To change the attribution property of active work book as hidden, read only, etc. Req step:a) Give command b) Specify marging as left, right, top, buttom, gutter and printing style. You can also change the printing style as line scape or for treat. FILE + PAGE SETUP:- To setup the page according to size of paper as marging, indent, etc. FILE + EXIT (ALT+F+X):- To exit from MS-Excel environment and for come desktop. FILE + SAVE AS (ALT+F+A):- To save the currently active sheet with a new name. FILE + OPEN (CTRL+O):- To open existed sheet at a time. FILE + CLOSE (CTRL+F4):- To close the currently active sheet. FILE + NEW (CTRL+N):- To active a new blank sheet at a time. How to start MS-EXCEL:Click вЂњStart + Program + MS-EXCELвЂќДЇILE + SAVE (CTRL+S):- To save the currently active sheet with a Name. Cell:- The intersection area of a row and column is called cell. Column:- The physical structure of vertically line is called column. The number of total rows in a sheet is 65536. Row:- The physical structure of horizentily line is called row. Work book:- A collection of sheet is called work book. What is spread sheet:- A collection of difference rows and columns is called spread sheet of work book. It is a product of Microsoft company and port of Microsoft office. MS-EXCEL It is spread sheet program, which provides facilities to do data and analysis work. MS-Excel ebook for Beginner Developed by: Ram Krishna Prasad BCA from IGNOU, New Delhi Email: