MS-EXCEL
MS-EXCEL
A Spread sheet is meant for the software package and a Worksheet is a work file created with spread sheet software. The default extension: - XML.
WORKSHEET:-
It is a grid of cells made up of horizontal rows and vertical columns. Numbers of rows and columns vary from package to package.
Ms-Excel worksheet contains 65,536 rows and 256 columns .Each intersection of a row and column is called a cell where in data can be stored.
ROW NUMBER:-
Data in a worksheet are divided in rows and columns. Each row is given a number that identifies it. Row numbers start from 1 and go as 2, 3, 4… 65,536.
COLUMN LETTER:-
Each column is given a letter that identifies it. Column letters start from A and go as B, C….. Z, AA, AB, AC, .AZ, BA, BB….BZ ….IV. That is columns are lettered A-Z, AA-A-Z, BA-BZ….IA-IV.
CEL L:-
Cell is a basic unit of work sheet where numbers, text, formulas etc. Can be placed. Cell is formed by intersection of a row and a column, which gives a cell a unique address. For instance, if row 3 is intersected by a column F, then the cell formed out of it gets an address F3. Similarly, C5 identifies the cell in column C, row 5
CELL POINTER:-
It is a cell boundary that specifies which cell is active at that moment.
RANGE OF CELLS:-
A Range of cells is a group of contiguous cells that forms a rectangular area in shape. A Range may contain just a single cell or a group of cells. But most form a rectangle in order to be valid. A Range is specified by giving the addresses of the first cell in the range and the last cell of the range. For instance, a range starting from F7 till G14 would be written as F7:G14 in MS-EXCEL (: is the Range indicator in Ms-Excel).
WORK BOOK:-
A Work sheet is a grid of cells made up of Rows and Columns. Multiple Worksheets can be combined under a file known as work book.
FORMULAS:-
Formulas is a sequence of values, cell addressed, Names, functions or operators in a cell that produces a new value from existing values. Formulas in Ms-excel start with “=” sign. If you enter 12+75rather than =12+75, then Excel will treat it as text and display it as it is 87.
FUNCTIONS:-
Functions are predefined formulas that perform calculations by specific values, arguments.
To display current date the short cut is: - CTRL+:
To display current time the short cut is: - CTRL+SHIFT+:
= Now ( ):- It will display current date and time.
Any Name followed by two parentheses is called functions
“( )”.
CTRL+RIGHT ERROW KEY: - A TO IV
CTRL+LEFT ERROW KEY: - IV TO A
CTRL+UP EROW KEY: - 1 TO 65,536
CTRL+DOWN ERROW KEY: - 65,536 TO 1
FILE MENU
1. NEW:-
This sub option is used to create a New Blank File.
2. OPEN:-
This sub option is used to open an existing file.
3. CLOSE:-
This sub option is used to close the current file.
4. SAVE:-
This sub option is used to save a modified name.
5. SAVE AS:-
This sub option is used to save as a newly created a file name.
6. SAVE AS WEB PAGE:-
This document can be saved as web page. By using this option the user can see a document in internal explorer. The default extension is HTML. HTML means hypertext mark of language.
7. SAVE WORK SPACE:-
By using this option the user can save a file in a single work space area.
1.Go to file menu.
2.Click on open.
3.Select a file.
4.Click on open.
5.Go to file menu.
6.Click on open.
7.Select a file.
8.Click on open.
9.Go to file menu.
10.Click on open.
11.Select a file.
12.Click on open.
13.Go to file menu.
14.Click on save workspace.
15.Write a file menu.
16.Click on save.
17.Click on close.
18.Click on close.
19.Click on close.
20.Go to file menu.
21.Click on open select a file.
22.Click on open.
23.Click on close.
24.Click on close.
8. FILE SEARCH:-
This sub option is searching the file.
9. WEB PAGE PREVIEW:-
Allows you to preview the current file as web page in your browser so that you can see how it will look before publishing it.
10. PRINT AREA:-
This option is used to select the print area. The print area is two types:-
1. Set print area
2. clear print area
1. SET PRINT AREA:-
This option is used to set the print area.
2. CLEAR PRINT AREA:-
This option is used to clear the print area.
1.Write a matter.
2.Select a matter.
3.Go to file menu.
4.Click on print area.
5.Click on set print area.
6.Go to file menu.
7.Click on print preview.
8.Click on close.
9.Go to file menu.
10.Click on print area.
11.Click on clear print area.
11. PRINT PREVIEW:-
Shows how a file will look when you print it.
12. SEND TO:-
This option is used to transfer or send any document created to different devices like to fax machine etc.
13. PRINT:-
This option is used to prints the active file or selected item.
14. PROPERTIES:-
Displays the properties sheet for the active file.
15. EXIT:-
This sub option is used to exit the ms-word in to current document.
16. PAGE SET UP:-
To set the page, when you want to print your document, such as to set the size of the paper, set the margin at the top, bottoms, and either edge of the paper, customize the Header and Footer on each page.
1.Write a matter.
2.Go to file menu.
3.Click on page set up.
4.Click on page.
5.Click on portrait or land scape.
6.Click on print preview. Click on close.
7.Click on adjust to.
8.Click on print preview. Click on close.
9.Click on margins.
10.Click on top,bottom,left,right.
11.Click on print preview. Click on close.
12.Click on header / footer.
13.Click on custom header.
14.Click on left section,center,and right section.
15.Click on ok.
16.Click on custom footer.
17.Click on left,center,right section.
18.Click on ok.
19.Click on print preview.
20.Click on close.
21.Click on sheet.
22.Click on print area.
23.Select a matter.
24.Click on print preview.
25.Click on close.
26.Clear the print area.
27.Click on rows to repeat at top.
28.Select a rows heading area.
29.Click on columns to repeat at left.
30.Select a columns heading area.
31.Click on print preview.
32.Click on close.
33.Click on grid lines.
34.Click on rows and column headings.
35.Click on print preview.
36.Click on close.
37.Click on down then over.
38.Click on ok.
39.Go to view menu.
40.Click on page break preview.
41.Click on normal.
42.Click on over then down.
43.Click on ok.
44.Go to view menu.
45.Click on page break preview.
46.Click on normal.
EDIT MENU
1. UNDO:-
This sub option is used to cancel the last action done by the user.
2. REDO:-
This sub option is used to repeat the last action the user can undo.
3. CUT:-
This sub option is used to cut the selected text.
4. COPY:-
This option is used to copy selected text into the current document.
5. PASTE:-
This sub option is used to paste copied text in to the current document.
6. OFFICE CLIP BOARD:-
The store house of cut and copy is called office clip board.
7. PASTE AS HYPERLINK:-
By using this option the user can inserts the contents of the clip board as a hyperlink at the insertion point, replacing any selection. This command is available only if you have cut or copied the contents of a cell or data from another program.
8. CLEAR:-
This sub option is used to clear the current document.
1.Write a matter.
2.Select a matter.
3.Go to edit menu.
4.Click on clear.
5.Click on all.
6.Select a matter.
7.Go to format tool bar.
8.Click on font color.
9.Select a color.
10.Go to edit menu.
11.Click on clear.
12.Click on format.
13.Select a matter.
14.Go to edit menu.
15.Click on clear.
16.Click on contents del.
17.Select a matter.
18.Go to insert menu.
19.Click on comment.
20.Select a comment matter.
21.Go to edit menu.
22.Click on clear.
23.Click on comments.
9. DELETE SHEET:-
This sub option is used to delete the current sheet.
1.Go to edit menu.
2.Click on delete sheet.
3.Click on delete.
10. DELETE: - (CTRL + -)
This sub option is used to delete the current document.
1.Shift cell left.
2.Shift cell up.
3.Entire column.
4.Entire row.
1.Write a matter.
2.Select a one cell matter.
3.Go to edit menu.
4.Click on delete.
5.Click on shift cell left.
6.Click on ok.
7.Select a one cell matter.
8.Click on delete.
9.Click on shift cell up.
10.Click on ok.
11.Select a one cell matter.
12.Click on delete.
13.Click on entire row.
14.Click on ok.
15.Select a one cell matter.
16.Click on delete.
17.Click on entire column.
18.Click on ok.
11. MOVE OR COPY SHEET:-
This sub option is used to display the move or copy sheet.
1.Go to edit menu.
2.Click on move or copy sheet.
3.Click on before sheet.
4.Click on create a copy.
5.Click on ok.
12. FIND:-
This sub option is used to search a particular word or character with another.
13. REPLACE:-
This option the user can replace a particular word or character with another.
14. GOTO:-
This option the user can jump from one line to another line, into the current document.
1.Create a data table.
2.Go to edit menu.
3.Click on goto.
4.Click on reference.
5.write a reference. ex:- b5:e7
6.Click on ok.
7.Select one cell.
8.Go to insert menu.
9.Click on comment.
10.Go to edit menu.
11.Click on goto.
12.Click on special.
13.Click on comment.
14.Click on ok.
15.Click on goto.
16.Click on special.
17.Click on constants.
18.Click on ok.
19.Click on goto.
20.Click on special.
21.Click on blanks.
22.Click on ok.
23.Select one matter cell.
24.Go to edit menu.
25.Click on special.
26.Click on current region.
27.Click on ok.
28.Select a one row.
29.Go to edit menu.
30.Click on special.
31.Click on row difference.
32.Click on ok.
33.Select a one column.
34.Goto edit menu.
35.Click on special.
36.Click on column difference.
37.Click on ok.
38.Select a total mark cell.
39.Goto edit menu.
40.Click on special.
41.Click on precedents.
42.Click on ok.
43.Select a one mark cell.
44.Goto edit menu.
45.Click on goto.
46.Click on special.
47.Click on dependents.
48.Click on ok.
49.Goto edit menu.
50.Click on special.
51.Click on last cell.
52.Click on ok.
15. PASTE SPECIAL:-
Pastes, links, or embeds the clipboard contents in the current file in the format you specify.
1.Create a data table.
2.Select a all table.
3.Go to edit menu.
4.Click on copy.
5.Click on paste special.
6.Click on all.
7.Click on ok.
8.Select a total mark.
9.Click on copy.
10.Click on blank area.
11.Click on paste special.
12.Click on formulas.
13.Click on ok.( it will display zero)
14.Write a number 10 , 20, 20 =50 .
15.Select a total mark.
16.Click on auto sum.
17.Select a matter.
18.Click on copy.
19.Click on paste special.
20.Click on values.
21.Click on ok.
22.And change the number .(It is doesn’t change the auto Sum number).
23.Select a heading area.
24.Goto formatting tool bar.
25.Click on font color.
26.Click on copy.
27.Click on blank area.
28.Click on paste special.
29.Click on formats.
30.Click on ok.
31.And write a matter.(it will display the format change
Color.
32.Select one cell matter.
33.Go to insert menu.
34.Click on comment.
35.Select a comment matter.
36.Click on copy.
37.Click on blank area.
38.Click on paste special.
39.Click on comment .
40.Click on ok.
41.Select a total table.
42.Go to format menu.
43.Click on cell.
44.Click on border.
45.Click on outside.
46.Click on ok.
47.Select a total table.
48.Click on copy.
49.Click on paste special.
50.Click on blank area.
51.Click on paste special.
52.Click on all except borders.
53.Click on ok.
54.Drag a one column area.
55.Select a drag cell.
56.Click on copy. Click on blank cell.
57.Click on paste special.
58.Click on column widths.
59.Click on ok.
60. Select a total mark.
61.Click on copy.
62.Click on blank area.
63.Click on paste special.
64.Click on formulas.
65.Click on ok.( it will display zero)
66.Write a number 10 , 20, 20 =50 .
67.Select a total mark.
68.Click on auto sum.
69.Select a matter.
70.Click on copy.
71.Click on paste special.
72.Click on values.
73.Click on ok.
74.And change the number .(It is doesn’t change the auto Sum number).
75.Write a number 10.
76.Write a second number 20.
77.Click on first number copy.
78.Click on second number paste special.
79.Click on add.
80.Click on ok.
81.Write a number 10.
82.Write a second number 20.
83.Click on first number copy.
84.Click on second number paste special.
85.Click on subtract.
86.Click on ok.
87.Write a number 10.
88.Write a second number 20.
89.Click on first number copy.
90.Click on second number paste special.
91.Click on multiply.
92.Click on ok.
93.Write a number 10.
94.Write a second number 20.
95.Click on first number copy.
96.Click on second number paste special.
97.Click on add.
98.Click on ok.
99.Write a number 10.
100.Write a second number 20.
101.Click on first number copy.
102.Click on second number paste special.
103.Click on add.
104.Click on ok.
105.Select a total table.
106.Click on copy .
107.Click on blank area.
108.Click on paste.
109.And paste item to some item delete.
110.Select a total table.
111.Click on copy.
112.Select a delete item and click on paste special.
113.Click on skip blank.
114.Click on ok.
115.Write a matter.EX:- have
a
nice
day.
116.Select a matter.
117.Click on copy.
118.Click on blank area.
119.Click on paste special.
120.Click on transpose.
121.Click on ok.
122.Select a matter.
123.Click on copy.
124.Click on blank area.
125.Click on paste special.
126.Click on paste link.
127.Click on ok.
128.Double click on paste link item.
16.FILL:-
1.DOWN:-
1.Write a matter.
EX:- 1 2 3
4 5 6
7 8 9
2.Select a Center matter.
3.Go to edit menu.
4.Click on fill.
5.Click on down.
6.Click on undo.
2.RIGHT:-
1.Select a Center matter.
2.Go to edit menu.
3.Click on fill.
4.Click on right.
5.Click on undo.
3.UP:-
1.Select a Center matter.
2.Go to edit menu.
3.Click on fill.
4.Click on up.
5.Click on undo.
4.LEFT:-
1.Select a Center matter.
2.Go to edit menu.
3.Click on fill.
4.Click on left.
5.Click on undo.
5.ACROSS WORK SHEET:-
1.Select a some matter.
2.Press ctrl and click on sheet 2.
3.Go to edit menu.
4.Click on fill.
5.Click on across work sheet.
6.Click on all.
7.Click on ok.
6.JUSTIFY:-
1.Write a cell suni.
2.Write a next cell ta.
3.Select a two cell.
4.Go to edit menu.
5.Click on justify.
7.SERIES:-
1.Write a matter:- 2.
2.Select a matter.
3.Go to edit menu.
4.Click on fill.
5.Click on series.
6.Select a row or columns.
7.Click on linear.
8.Write a step value 3 and stop value 30.
9.Click on ok.
10.Write a matter:- 3.
11. Select a matter.
12.Go to edit menu.
13.Click on fill.
14.Click on series.
15.Select a row or columns.
16.Click on growth.
17.Write a step value 5 and stop value 700.
18.Click on ok.
19.Write a date.1/1/2009.
20.Select a date.
21.Go to edit menu.
22.Click on fill.
23.Click on series.
24.Click on date.
25.Click on day.
26.Write a step value 2 and stop value1/30/2009.
27.Click on ok.
28.Write a date.
29.Select a date.
30.Go to edit menu.
31.Click on fill.
32.Click on series.
33.Click on date.
34.Click on week day.
35.Write a step value 7 and stop value .
36.Click on ok.
37.Write a date.1/1/2009
38.Select a date.
39.Go to edit menu.
40.Click on fill.
41.Click on series.
42.Click on date.
43.Click on month.
44.Write a step value 3 and write a stop value 12/12/2009.
45.Click on ok.
46.Write a date 1/1/2009.
47.Select a date.
48.Go to edit menu.
49.Click on fill.
50.Click on series.
51.Click on year.
52.Write a step value 3 and stop value 1/1/2050.
53.Click on ok.
54.Write a matter.
55.Write a matter 1.
56.Write a matter 2.& select some blank cell.
57.Go to edit menu.
58.Click on auto fill.
59.Click on ok.
60.Write a matter 1.
61.Write a matter 2.& select some blank cell.
63.Go to edit menu.
64.Click on fill.
65.Click on series.
66.Click on trend.
67.Click on ok.
VIEW MENU
1. NORMAL :-
Normal view helps to view the documents when you want to do a lot of serious typing in a hurry. Normal view shows text formatting but simplifies the layout of the page so that you can examine and work with the structure of a document.
1.Go to view menu.
2.Click on normal.
2.PAGE BREAK PREVIEW:-
Shows you what data will go on each page so you can adjust the print area and page break.
1.Go to view menu.
2.Click on page break preview.
3.Go to view menu.
4.Click on normal.
3.TASK PANE:-
Displays the task pane, an area where you can create new files, search for information, view the contents of the clip board and perform other tasks.
1.Go to view menu.
2.Click on task pane.
4.TOOLS BAR:-
We can activate the existing tool bar which will be available with all the tool bars option. |There are 16. Nos of tool bar available under this toolbar. With the tool bar option we have option that we can create a new tool bar with selected tools under customization of tool bar. The all available 16 tools bar are standard , formatting , auto text, clip board, control tool box, data base , drawing, forms, frames, pictures, reviewing, tables, and boarders, visual basic, web, web tools, and word arts.
1.Go to view menu.
2.Click on tools bar.
3.Click on tools.
5.FORMULA BAR:-
A formula bar at the top of the excel window that you use to enter or edit values or formulas in cells or charts. Display the constant value or formula stored in the active cell. A formula starts with an equal sign (=).
1.Go to view menu.
2.Click on formula bar.
6.STATUS BAR:-
This allows you to display the status bar at the bottom of the window. The status bar displays information about the active document or the task on which you are currently working. This includes the page number that you are on, the column, and line number on which you have positioned the cursor and so on.
1.Go to view menu.
2.Click on status bar.
7.FULL SCREEN:-
Hides all screen elements, such as toolbars, menus, scrollbars, title bars, the ruler, the style area and the status bar.
1.Go to view menu.
2.Click on full screen.
3.Go to view menu.
4.Click on full screen.
8.ZOOM:-
Controls how large or small a document appears on the screen. You can enlarge the display to make it easier to read or reduce the display to view and entire page.
1.Go to view menu.
2.Click on zoom.
3.Select a magnification.
4.Click on ok.
9.CUSTOM VIEW:-
A set of display and print setting that you can name and apply to a work book. You can create more than one view of the same work book with out saving separate copies of the workbook.
1.Select a matter.
2.Go to view menu.
3.Click on custom view.
4.Click on add.
5.Write a name .
6.Click on ok.Click on blank area.
7.Go to view menu.
8.Click on custom view.
9.Select a name.
10.Click on show.
MENTS:-
People insert viewers comment into a document to provide suggestions and criticisms they may have the regarding the document. Your comments into the document, those comments are read on screen. If your receive a document that contains comments. You can read these by selecting this option.
1.Select a matter.
2.Go to insert menu.
3.Click on comment.
4.Go to view menu.
5.Click on comment.
6.Go to view menu.
7.Click on comment.
11.HEADER AND FOOTER:-
Adds or changes text that word repeats at the top of every page(header) or to the bottom of every page(footer) in a section or in an entire document’s and footers offers lots of flexibility in the way page numbers and others document statistics can be displayed.
INSERT MENU
1.CELL:-
Cell is formed by intersection of a row and a column, which gives a cell. This option the the user can insert the new cell.
Shift cell rights
Shift cell downs
Entire row
Entire column
1.Write a matter.EX:-
1 2 3
4 5 6
7 8 9
2.Select a Second cell matter.
3.Go to insert menu.
4.Click on cell.
5.Click on shift cell right.
6.Click on ok.
7.Select a Second cell matter.
8.Go to insert menu.
9.Click on cell.
10.Click on shift cell down.
11.Click on ok.
12.Select a Second cell matter.
13.Go to insert menu.
14.Click on cell.
15.Click on entire row.
16.Click on ok.
17.Select a Second cell matter.
18.Go to insert menu.
19.Click on cell.
20.Click on entire column.
21.Click on ok.
2.ROWS:-
This option the user can inserts the rows.
1.Write a matter.
2.Click on one cell.
3.Go to insert menu.
4.Click on rows.
3.COLUMNS:-
This option the user can inserts the columns.
1.Write a matter.
2.Click on one cell.
3.Go to insert menu.
4.Click on columns.
4.WORK SHEET:-
It is a grid of cells made up of horizontal rows and verticals columns. The primary document that you use in excels to store and work with data, also called a spread sheet. A work sheet consists of cells that are organized into columns and rows; a work sheet is always stored in a workbook. This option the user can insert a new workbook.
1.Go to insert menu.
2.Click on work sheet.
5.PAGE BREAK:-
Divider that breaks a work sheet into separate pages for printing. Excel inserts automatic page breaks based on the paper size, margin settings, scaling options of any manual page breaks that you insert.
1.Go to insert menu.
2.Click on page break.
3.Go to view menu.
4.Click on page break preview.
5.Go to view menu.
6.Click on normal.
7.Go to insert menu.
8.Click on remove page break.
6.SYMBOL:-
You can insert a whole set of typographical symbols into your document. These include mathematical, Greek, Japanese and winding symbols. The numbers of symbols available to you depends on what fonts are installed on your computer.
MENTS:-
People insert viewer’s comments into a document to provide suggestions and criticisms; they may have regarding the document. Your comments into the document, these comments are read on screen. If your receive a document that contains comments, you can read thee by selecting this option
8.HYPERLINK:-
A hyperlink is text or a picture that causes you to jump to another document or web page when it is clicked. Text that is hyperlinked is underlined and often has a different font color. Pictures that are hyperlink often have colored border.
9. OBJECT:-
An object is information created in another software program that you might want to insert into your word document. For instance, you can insert or embed an excel worksheets or chart as an object into your word document.
10. DIAGRAM:-
If you want to resize a diagram a long with the space around it with in the drawing, drag the sizing handle at the corner of the size you want.
11.PICTURE:-
By using this option the user can insert a picture into the current document.
1. CLIP ART:-
By using this option the user can insert a picture into the current document.
2. FROM FILE:-
By using this option the user can insert picture file into the current document.
3. AUTO SHAPE:-
By using this option the user can insert predifferent types of shapes into the current document.
4. WORD ART:-
Creates text effects by inserting a Microsoft office drawing object.
12.FUNCTIONS:-
1.DATE AND TIME:-
1.DATE:-
1.Go to insert menu.
2.Click on function.
3.Click on date and time.
4.Click on date.
5.Click on ok.
6.Write the year 2009.
7.Write the month 01.
8.Write the day 01.
9.Click on ok .(It will display the date 01/01/2009).
2.DATE VALUE:-
1.Click on date value.
2.Click on ok.
3.Write the date text :- “01/01/2009”.
4.Click on ok.(It will display the date value).
3.DAY:-
1.Click on day.
2.Click on ok.
3.Write the day “4” or select the day.
4.Click on ok.(It will display the day 4).
4.DAYS 360:-
1.Click on days 360.
2.Click on ok.
3.Write the date :- “6/30/2008”.
4.Write the date :- “7/31/2008”.
5.Click on ok. (It will display the 31 day distance).
5.HOUR:-
1.Write the time :- 7:26
2.Click on hour.
3.Click on ok.
4.Select the cursor in time cell 7:26
5.Click on ok.( It will display the 19).
6.MINUTE:-
1.Write the time 7:26
2.Click on minute.
3.Click on ok.
4.Select the cursor in time cell 7:26
5.Click on ok.(It will display the 26 minute ).
7.MONTH:-
1.Write the date :- 7/7/2008.
2.Click on month.
3.Click on ok.
4.Select the date cell :- 7/7/2008.
5.Click on ok.(It will display the 7 month).
8.NOW:-
1.Select the blank cell.
2.Click on now.
3.Click on ok.
4.Click on ok.( It will display the date and time ).
9.SECOND:-
1.Write the time :- 7:22:24.
2.Click on second.
3.Click on ok.
4.Select the 7:22:24.
5.Click on ok.(It will display the 24 second ).
10.TIME:-
1.Click on time .
2.Click on ok.
3.Write the hour 22.
4.Write the minute 10.
5.Write the second 11.
6.Click on ok.( It will display the time).
11.TIME VALUE:-
1.Click on time value.
2.Click on ok.
3.Write the time :- “22:42:36”
4.Click on ok. (It will display the number of time ).
12.TODAY:-
1.Click on today.
2.Click on ok.
3.Click on ok.( It will display the current date.)
13.WEEK DAY:-
1.Click on weekday.
2.Click on ok.
3.Write the date “8/15/2008”
4.Click on ok.
14.YEAR:-
1.Write the date 7/30/2009
2.Click on year.
3.Click on ok.
4.Select the date 7/30/2009
5.Click on ok.( It will display the current year 2009).
2.TEXT:-
1.CHARACTER:-
1.Click on character.
2.Click on ok.
3.Write the number 65.
4.Click on ok.(It will display the capital A).
2.CODE:-
1.Click on code.
2.Click on ok.
3.Write the text “a”.
4.Click on ok. (It will display the 97 ).
3.CONCATENATE:-
1.Write the text first cell :- suni
2.Write the text second cell :- ta.
3.Select a blank cell.
4.Click on concatenate.
5.Click on ok.
6.Select a suni.
7.Select a ta.
8.Click on ok.( It will display the sunita ).
4.DOLLAR:-
1.Click on dollar.
2.Click on ok.
3.Write a number 5.
4.Click on ok. (It will display $5).
5.EXACT:-
1.Write a first cell :- A.
2.Write a second cell :- a
3.Click on exact.
4.Click on ok.
5.Select a first cell :- A
6.Select a second cell :- a
7.Click on ok.( It will display false ).
OR
1.Write a first cell :- sunita.
2.Write a second cell :- sunita.
3.Click on exact.
4.Click on ok.
5.Select a first cell sunita.
6.Select a second cell sunita.
7.Click on ok. (It will display true ).
6.FIND:-
1.Write a matter sunita.
2.Click on find .
3.Click on ok.
4.Write a find text u.
5.Write the with in text sunita.
6.Click on start num.
7.Click on ok. ( It will display 2 ).
7.LEFT:-
1.Click on left.
2.Click on ok.
3.Write a text sunita.
4.Write a num char 4.
5.Click on ok. ( It will display suni).
8.LEN:-
1.Click on len.
2.Click on ok.
3.write a text sunita.
4.Click on ok.(It will display 6 ).
9.LOWER:-
1.Click on lower.
2.Click on ok.
3.Write a text SUNITA.
4.Click on ok. ( It will display sunita ).
10.MID:-
1.Click on mid.
2.Click on ok.
3.Write a text sunita.
4.Write a start num 3.
5.Write a num char 6.
6.Click on ok. ( It will display nita ).
11.PROPER:-
1.Click on proper.
2.Click on ok.
3.Write a text :- have a nice day.
4.Click on ok. ( It will display Have A Nice Day ).
12.REPLACE:-
1.Click on replace.
2.Click on ok.
3.Write a old text suneeta.
4.Write a start num 4.
5.Write a num chars 2.
6.Write a new text sunita.
7.Click on ok. ( It will display sunita ).
13.REPT:-
1.Click on rept.
2.Click on ok.
3.Write a text suman.
4.Write a number times 3.
5.Click on ok. ( It will display suman suman suman ).
14.SEARCH:-
1.Click on search .
2.Click on ok.
3.Write a find text m.
4.Write a with in text suman.
5.Click on ok.( It will display 3 ).
15.SUBSTITUTE:-
1.Click on subtitute.
2.Click on ok.
3.Write a text sunita suman.
4.Write a old text sunita.
5.Write a new text sweetu.
6.Click on ok. ( It will display the sweetu suman ).
16.T:-
1.Click on T.
2.Click on ok.
3.Write a value “5”.
4.Click on ok. (It will display 5 ).
17.RIGHT:-
1.Click on right.
2.Click on ok.
3.Write a text sunita.
4.Write a num 2.
5.Click on ok.( It will display the ta ).
18.UPPER:-
1.Click on upper.
2.Click on ok.
3.Write a text sunita.
4.Click on ok. ( It will display the SUNITA ).
19.VALUE:-
1.Click on value.
2.Click on ok.
3.Write a value 5.
4.Click on ok. (It will display 5 ).
3.MATH AND TRIG:-
1.ABS:-
1.Click on abs.
2.Click on ok.
3.Write a number :- -2
4.Click on ok. (It will display 2).
2.EVEN:-
1.Click on even.
2.Click on ok.
3.Write a number 3.
4.Click on ok. ( It will display 4).
3.FACT:-
1.Click on fact.
2.Click on ok.
3.Write a number 6.
4.Click on ok. ( It will display 720 ).
4.FLOOR:-
1.Click on floor.
2.Click on ok.
3.Write a number 50.
4.Write a significance 2.
5.Click on ok.( It will display 50 ).
5.INT ( INTGER):-
1.Click on intger.
2.Click on ok.
3.Write a number 5.
4.Click on ok. (It will display 5).
6.M MULT (MATRIX MULTIPLICATION):-
1.Click on m mult.
2.Click on ok.
3.Write a array 1:- 5
4.Write a array 2:- 5
5.Click on ok.( It will display 25).
7.MOD:-
1.Click on mod.
2.Click on ok.
3.Write a number 9.
4.Write a divisor 5.
5.Click on ok. ( It will display 4 ).
8.ODD:-
1.Click on odd.
2.Click on ok.
3.Write a number 4.
4.Click on ok.( It will display 5 ).
9.POWER:-
1.Click on power.
2.Click on ok.
3.Write a number 5.
4.Write a power 3.
5.Click on ok.( It will display 125).
10.PRODUCT:-
1.Click on product.
2.Click on ok.
3.Write a number 1:- 5
4.Write a number 2:- 2
5.Write a number 3:- 5
6.Click on ok.( It will display 50 ).
11.ROMAN:-
1.Click on roman
2.Click on ok.
3.Write a number 12.
4.Click on ok.(It will display xii ).
12.SIGN:-
1.Click on sign.
2.Click on ok.
3.Write a number 5 or -5 or 0.
4.Click on ok. ( It will display 1 or -1 or 0 ).
13.SQRT:-
1.Click on sqrt.
2.Click on ok.
3.Write a number 16.
4.Click on ok.( It will display 4).
14.SUM:-
1.Click on sum.
2.Click on ok.
3.Write a number 1:- 3.
4.Write a number 2:- 3
5.Click on ok.( It will display 6).
15.SUM PRODUCT:-
1.Click on sum product.
2.Click on ok.
3.Write a array 1:- 2
4.Write a array 2:- 5
5.Write a array 3:- 2
6.Click on ok . (It will display 20 ).
16.SUM SQ:-
1.Click on sum sq.
2.Click on ok.
3.Write a number 1:- 2
4.Write a number 2:- 3
5.Click on ok. ( It will display 13 ).
17.SUMX2 MY2:-
1.Click on sumx2 my2
2.Click on ok.
3.Write a array –x:- 5
4.Write a array –y:-2
5.Click on ok. (It will display 21 ).
18.SUMX2 PY2:-
1.Click on sumx2py2
2.Click on ok.
3.Write a array 1:- 2
4.Write a array 2:- 3
5.Click on ok. (It will display 13 ).
19.SUMXMY2:-
1.Click on sumxmy2.
2.Click on ok.
3.Write a array –x:- 10
4.Write a array –y:- 2
5.Click on ok.(It will display 64).
13.NAME:-
1.DEFINE:-
1.Select a one blank cell.
2.Go to insert menu.
3.Click on name.
4.Click on define.
5.Write a name suman.
6.Click on ok.
7.Go to address bar.
8.Click on suman.(It will display the suman blank cell.).
2.PASTE :-
1.Select a suman blank cell.Click on blank cell.
2.Click on copy.
3.Go to insert menu.
4.Click on name.
5.Click on paste.
6.Select a name suman.
7.Click on paste list.
8.Click on ok.
9.Double click the paste list.(It will display the link item).
FORMAT MENU
1. CELL:-
By using this option the user can applies formats to the selected cells. This command might not available if the sheet is protected.
1.NUMBER:-
1.GENERAL:-
1.Write a matter. EX:- 75.
2.Select a matter.
3.Go to format menu.
4.Click on cell.
5.Click on general.
6.Click on ok.
2.NUMBER:-
1.Write a matter. EX:- 75.
2.Select a matter.
3.Go to format menu.
4.Click on cell.
5.Click on number.
6.Click on use 1000 separators.
7.Click on ok.
8.Clickon number.
9.Click on decimal places.
10.Click on ok.
3.CURRENCY:-
1.Write a matter. EX:- 75.
2.Select a matter.
3.Go to format menu.
4.Click on cell.
5.Click on currency.
6.Click on symbol.
7.Click on ok.
OR
1.Write a matter. EX:- 75.
2.Select a matter.
3.Go to format menu.
4.Click on cell.
5.Click on currency
6.Click on custom.
7.Click on general.
8.Clear the general.
9.Write a format code 0 “$”
10.Click on ok.
4.ACCOUNTING:-
1.Write a matter. EX:- 75.
2.Select a matter.
3.Go to format menu.
4.Click on cell.Click on accounting.
5.Click on symbol.
6.Select a symbol.
7.Click on ok.
OR
1.Write a matter. EX:- 75.
2.Select a matter.
3.Go to format menu.
4.Click on cell.
5.Click on accounting.
6. Click on custom.
7.Click on general.
8.Clear the general.
9.Write a format code 0 “RS”
10.Click on ok.
5.DATE:-
1.Write a date.
2.Select a date.
3.Go to format menu.
4.Click on cell.
5.Click on date.
6.Select a date style.
7.Select a locale location.
8.Click on ok.
6.TIME:-
1.Write a time.
2.Select a time.
3.Go to format menu.
4.Click on cell.
5.Click on time.
6.Select a time style.
7.Select a locale location.
8.Click on ok.
7.PERCENTAGE:-
1.Write a matter. EX:- 75.
2.Select a matter.
3.Go to format menu.
4.Click on cell.
5.Click on percentage.
6.Click on ok.
OR
1.Write a matter. EX:- 75.
2.Select a matter.
3.Go to format menu.
4.Click on cell.
5.Click on percentage.
6. Click on custom.
7.Click on general.
8.Clear the general.
9.Write a format code 0 “%”
10.Click on ok.
8.FRACTION:-
1.Write a matter. EX:- 5.2
2.Select a matter.
3.Go to format menu.
4.Click on cells.
5.Clickon fraction.
6.Select a type.
7.Click on ok.
9.TEXT:-
1.Write a number.
EX:- 01 it will display 1.
EX:- 02 it will display 2.
2.Select some blank cell.
3.Go to format menu.
4.Click on cells.
5.Click on text.
6.Click on ok.
7.Write a number:-
01 it will display 01.
10.SPECIAL:-
1.Write phone number:- 94385-38386
2.Select a cell.
3.Go to format menu.
4.Click on cell.
5.Click on special.
6.Click on phone number (type)
7.Click on ok.
8.Select phone number cell and drag it.
ALIGNMENT:-
TEXT ALIGNMENT:-
The text layout with in a paragraph with respect to document margins is known as text alignment. There are two types of alignment;-horizontal alignment, vertical alignment.
INDENT:-
The distance between text boundaries and page margins is called indent.
6.ALIGNMENT:-
1.TEXT ALIGNMENT:-
1.Write a matter.
2.Select matter.
3.Go to format menu.
4.Click on cells.
5.Click on alignment.
6.Click on horizontal or vertical.
7.Click on indent.
8.Click on ok.
2.DEGREES:-
1.Select the cell.
2.Click on degrees.
3.Click on ok.
3.TEXT CONTROL:-
1.WRAP TO TEXT:-
1.Write the more contents.
2.Select it.
3.Go to format menu.
4.Click on cells.
5.Click on alignment.
6.Click on wrap text.
7.Click on ok.
2.SHRINK TO FIT:-
1.Select more contents matter.
2.Go to format menu.
3.Click on cells.
4.Click on alignment.
5.Click on shrink to fit.
6.Click on ok.
3.MERGE CELL:-
1.Select 4 or many blank cell.
2.Go to format menu.
3.Click on cell.
4.Click on alignment.
5.Click on merge cell.
6.Click on ok.
4.TEXT DIRECTION:-
1.RIGHT TO LEFT:-
1.Go to format menu.
2.Click on cells.
3.Click on alignment.
4.Click on text direction.
5.Click on right to left.
6.Click on ok.
7.Write a matter and space it and write a matter.(it will
Display the cursor starting point use to press the space).
PROTECTION:-
Locking cells or hiding formulas has no effect unless the work sheet is protected .To protect the worksheet, choose protection from the tools menu and then choose protect sheet. A pass word is optional.
1.Select the matter.
2.Go to format menu.
3.Click on cells.
4.Click on protection.
5.Click on hidden.
6.Click on ok.
7.Go to tools menu.
8.Click on protection.
9.Click on protect sheet.
10.Write the password.(suman)
11.Click on ok.
12.Write the reenter password(suman).
13.Click on ok.
14.Write a matter.(It is doesn’twrite).
15.Go to tools menu.
16.Click on protection.
17.Click on unprotect sheet.
18.Write the unprotect sheet password.(suman).
19.Click on ok.
FONT:-
By using this option the user can change the font, font style, color, and size, into the current document.
1.Select a matter.
2.Go to format menu.
3.Click on cells.
4.Click on font.
5.Click on font ,font style, size,color,underline,effects.
6.Click on ok.
BORDERS:-
By using this option the user can add borders and select the color into the current document.
1.Select a matter.
2.Go to format menu.
3.Click on cells.
4.Click on borders.
5.Select color,line,preset.
6.Click on ok.
4.PATTERNS:-
1.Select a matter.
2.Go to format menu.
3.Click on cells.
4.Click on pattern.
5.Select the color.
6.Click on ok.
2. ROW:-
ROWS HEIGHT:-
By using this option the user can change the rows height into the current document.
1.Select a one cell.
2.Go to format menu.
3.Click on row.
4.Click on height.
5.Change the row height.
6.Click on ok.
AUTOFIT:-
This sub option is used to adjust the row height to the minimum necessary to display the height of the tallest cell in the selection.
1.Go to format menu.
2.Click on row.
3.Click on autofit.
HIDE:-
Hides the selected rows or columns. Hiding rows or columns does not delete them from the worksheet.
1.Select a cell.
2.Go to format menu.
3.Click on row.
4.Click on hide.
UNHIDE:-
Displays rows and columns in the current selection that were previously hidden.
1.Go to format menu.
2.Click on row.
3.Click on unhide.
3. COLUMNS:-
COLUMNS WIDTH:-
By using this option the user can change the columns width into the selected cell.
1.Select a cell.
2.Go to format menu.
3.Click on column.
4.Click on width.
5.Change the column width.
6.Click on ok.
AUTOFIT SELECTION:-
Adjusts to the column width to the minimum necessary to display the contents of the selected cells. If you change the cell contents later, you must fit the selection again.
1.Write a 3 or 4 cell.
2.Select a matter.
3.Go to format menu.
4.Click on column.
5.Click on autofit selection.
HIDE:-
Hides the selected rows or columns. Hiding rows or columns doesn’t delete them from the worksheet.
1.Select a cell.
2.Go to format menu.
3.Click on column.
4.Click on hide.
UNHIDE:-
Displays rows or columns in the current selection that were previously hidden.
1.Go to format menu.
2.Click on column.
3.Click on unhide.
5.STANDARD WIDTH:-
1.Go to format menu.
2.Click on column.
3.Click on standard width.
4.Click on ok.
4. SHEET:-
RENAME:-
By using this option the user can rename the active sheet.
1.Go to format menu.
2.Click on sheet.
3.Click on rename.
4.Write a name.
HIDE:-
Hides the active sheet the sheet remains open and accessible to other sheets, but it is not visible. You can’t hide the only visible sheet is a workbook.
1.Go to format menu.
2.Click on sheet.
3.Click on hide.
UNHIDE:-
Displays sheet in the current selections that were previously hidden.
1.Go to format menu.
2.Click on sheet.
3.Click on unhide.
4.Select a unhide sheet.
5.Click on ok.
BACKGROUND:-
Inserts a tiled graphic image in the worksheet background, based on the bitmap you selected.
1.Go to format menu.
2.Click on sheet.
3.Click on back ground.
4.Select a picture.
5.Click on insert.
6.Go to format menu.
7.Click on sheet.
8.Click on delete back ground.
TAB COLORS:-
This sub option is used to apply a predifferent tab colors.
1.Go to format menu.
2.Click on sheet.
3.Click on tab color.
4.Select a color.
5.Click on ok.
5.AUTOFORMAT:-
By using this option the user can automatically format the current cells.
1.Select a matter.
2.Go to format menu.
3.Click on auto format.
4.Select a auto format menu.
5.Click on ok.
6.CONDITIONAL FORMATTING:-
Applies formats to selected cells that meet specific criteria based on values or formulas you specify.
1.Go to format menu.
2.Click on conditional formatting.
3.Click on condition 1.
4.Click on between. EX:- 40 to 50
5.Click on format:- Change the font style,color etc.
6.Click on ok.
7.Click on add.
8.Click on condition 2.
9.Click on less then. EX:- 35
10.Click on format:- Change the font style,color.
11.Click on ok.
12.Click on add.
13.Click on condition 3.
14.Click on greater then. EX:- 70
15.Click on format :- Change the font style,color.
16.Click on add.
17.Click on ok.
7.STYLES:-
Defines or applies to the selection a combination of formats, called a style.
TOOLS MENU
1. SPELLING AND GRAMMER:-
By using this option the user can check the spelling and grammatical errors. Red line in spelling and green line in grammar.
2. SHARE WORKBOOK:-
A work book set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the work book sees the changes made by other users.
1.Write a matter.
2.Save it.
3.Go to tools menu.
4.Click on share work book.
5.Click on allow changes by more than one user.
6.Click on ok.
7.you can look it ,at the title name shared.
8.Go to tools menu.
9.Click on share work book.
10.Click on allow changes .
11.Click on ok.
3. AUTO CORRECT OPTION:-
Sets the options used to correct text automatically as you type or to store and reuse text and other items you use frequently.
4. MACRO:-
Macro is similar to batch file of ms-dos whether you can record the regular jobs as key sequence by assigning a key value and after creation of the same you can involve and after creation of the same you can involve the entire recorded steps automatically just after pressing the old key sequence includes so many steps like recording a macro and using a macro.
5. TRACK CHANGES:-
Using this option mark of the change mode in a current active worksheet and according to our desire is accepting or rejects to change.
1.Write a matter.
2.Save it.
3.Go to tools menu.
4.Click on track changes.
5.Click on high light changes.
6.Click on track changes while editing.
7.Click on ok.
8.Write a matter.
9.Go to tools menu.
10.Click on track changes.
11.Click on accept or reject changes.
12.Click on ok.
13.Click on accept or reject.
14.Click on close.
15.Go to tools menu.
16.Click on track changes.
17.Click on high light changes.
18.Click on track changes while editing.
19.Click on ok.
6. COMPARE AND MERGE WORKBOOK:-
By using this option the user can compare and merge the workbook.
1.Write the matter.
2.Save it.(suman)
3.Go to tools menu.
4.Click on track changes.
5.Click on highlight changes.
6.Click on track changes while editing.
7.Click on ok.
8.Write a matter.( It will track changes ).
9.Go to file menu.
10.Click on save as.
11.Write a file name sunita.
12.Click on save.
13.Close the sunita file.
14.Go to file menu.
15.Click on open.
16.Select the suman file.
17.Click on open.
18.Go to tools menu.
19.Click on compare and merge work book.
20.Select a sunita file.
21.Click on ok.
22.Go to tools menu.
23.Click on track changes.
24.Click on high light changes.
25.Click on track changes while editing.
26.Click on ok.
7. ADD-INS:-
A supplemental program that adds custom commands or customs features to Microsoft office.
1.Go to tools menu.
2.Click on add-ins.
3.Click the solver add ins.
4.Click on ok.
8. CUSTOMIZE:-
Customizes toolbars buttons menu commands and short cut key is assignment.
9. GOAL SEEKS:-
A method to find a specific value for a cell by adjusting the value of one other cell. When goal seeking, excel varies the value in a cell that you specify until a formula that’s dependent on that cell returns the result you. (Formula to value).
1.Create a table.
2.Go to tools menu.
3.Click on goal seek.
4.Select the total mark cell.EX:- 200
5.Write a to value EX:- 250
6.Select the by changing cell. EX:- ENG:-50
7.Click on ok.
8.Click on ok.
10. SCENARIOUS:-
A named set of input values that you can substitute in a worksheet model. (Value to formula.).
1.Go to tools menu.
2.Click on scenarious.
3.Click on add.
4.Write a scenario name.
5.Select changing cell.EX:-Eng :-40
6.Click on ok.
7.Write the enter value for each of the changing cell.
EX:- 40 change to 70.
8.Click on ok.
9.Click on show.
10.Click on close.
11.Click on summary.
12.Click on ok.
13.Right click scenarious summary to the sheet.
14.Click on delete.
15.Click on delete.
11. PROTECTION:-
Using this option is protecting a single sheet or workbook.
1.PROTECT SHEET:-
1.Go to tools menu.
2.Click on protection.
3.Click on protect sheet.
4.Write the password suman.
5.Click on ok.
6.Write the reenter password suman.
7.Click on ok.
8.And write the matter.
9.Go to tools menu.
10.Click on protection.
11.Click on unprotect sheet.
12.Write the password suman.
13.Click on ok.
14.And write the matter.
2.ALLOW USERS TO EDIT RANGES:-
1.Go to tools menu.
2.Click on protection.
3.Click on allow users to edit ranges.
4.Click on protect sheet.
5.Write the password suman.
6.Click on ok.
7.Write the reenter password suman.
8.Click on ok.
9.And write the matter.
10.Go to tools menu.
11.Click on protection.
12.Click on unprotect sheet.
13.Write the password suman.
14.Click on ok.
15.And write the matter.
10. FORMULA AUDITING:-
A sequence of values, cell references, names, functions or operators in a cell that together produce a new value. A formula always begins with an equal sign.
1.TRACE PRECEDENTS:-
1.Select the sum cell.
2.Go to tools menu.
3.Click on formula auditing.
4.Click on trace precedents.
2.REMOVE ALL ARROWS:-
1.Go to tools menu.
2.Click on formula auditing.
3.Click on remove all arrows.
3.TRACE DEPENDENTS:-
1.Select the sum cell. EX:- 180
2.And select the other number cell. EX:- 50
3.Go to tools menu.
4.Click on formula auditing.
5.Click on trace dependents.
4.EVALUATE FORMULA:-
1.Select the total mark cell.EX:- 200
2.Go to tools menu.
3.Click on formula auditing.
4.Click on evaluate formula.
5.Click on evaluate.
6.Click on close.
5.SHOW WATCH WINDOW:-
1.Go to tools menu.
2.Click on formula auditing.
3.Click on show watch window.
4.Click on add watch.
5.Select the cell.
6.Click on add.
6.FORMULA AUDITING MODE:-
1.Go to tools menu.
2.Click on formula auditing .
3.Click on formula auditing mode.
4.Go to tools menu.
5.Click on formula auditing.
6.Click on formula auditing mode.
7.SHOW FORMULA AUDITING MODE:-
1.Go to tools menu.
2.Click on formula auditing .
3.Click on show formula auditing tools bar.
13.SOLVER:-
1.Go to tools menu.
2.Click on solver.
3.Click on set target cell and select the total mark cell.
EX:- 250
4.Click on value of EX:- 275.
5.Select the changing cell.EX:- Click on eng mark cell.
6.Click on solve .
7.Click on ok.
DATA MENU
1. SORT:-
This option is used to arrange the matters of an either in ascending or descending order. Sort rows in ascending order to descending order and descending order to ascending order. Sort rows in ascending order (a to z or o to 9) or descending order (z to a or 9 to 0).
1.Create a table.
2.Select it.
3.Go to data menu.
4.Click on sort.
5.Select the sort by Name.
6.Click on ascending .
7.Click on ok.
8.Click on sort.
9.Click on no header row.
10.Click on ok.
2. FORM :-
A dialog box that displays one complete record at a time. You can use data forms to add, change, locate and delete.
1.Create a table.
2.Select a table.
3.Go to data menu.
4.Click on form.
5.Click on find preview.
6.Click on find next.
7.Click on new.
8.Fill in the form.
9.Click on criteria.
3. SUB TOTALS:-
A subtotal in a list or data base. It is generally easier to
Create a list with sub totals using the subtotals command. Once the subtotals list is created .you can modify it by editing the subtotals functions.
1.Create a table.
2.Select and copy and paste the table two or three times.
3.Select the total table.
4.Go to data menu.
5.Click on sort.
6.Click on sort by name( name).
7.Click on ascending.
8.Click on ok.
9.Select the all total table.
10.Go to data menu.
11.Click on subtotals.
12.Click on at each change in (name).
13.Click on use function(sum).
14.Click on add subtotals to(name).
15.Click on replace current subtotals .
16.Click on page break between groups.
17.Click on summary below data.
18.Click on ok.
19.Click on 1,2,3.
20.Click on – or +.
21.Go to data menu.
22.Click on sub totals.
23.Click on remove all.
24.Click on ok.
4. VALIDATION:-
Displays messages that prompt users for correct entries and notify users about incorrect entries.
1.Create a table.
2.Select a one value in column wise EX:- history
3.Go to data menu.
4.Click on validation.
5.Click on setting.
6.Click on allow.
7.Select the whole number.
8.Click on minimum EX:- 20
9.Click on maximum EX:- 30.
10.Click on input messages.
11.Click on title (suman).
12.Click on input messages EX:- it should be >=20=20 ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.