How to start excel

Start all programs Microsoft office Microsoft excel

Click on blank sheet
It has got rows and columns rows are numbered as 1,2,3,4
Columns are numbered as a,b,c,d
Intersection of row and column is called as cell press end
and down arrow to go to last row 1048576
Press end and right arrow to go to last column xfd
Name box shows the address of the cell where your cursor
is. And formula bar shows the formula
To increase column width
Format column width and give no and press enter
Default width of column is 8.43 autofit column width extra
width will go.
To increase row height
Format row height and give no.
Autofit extra height of row will go.
Hide row :- it will hide that row where your cursor is.
Unhide row :- hidden row will be back
Hide column :- it will hide column where your cursor is.
Unhide column :- hidden column will be back
Hide sheet :- you should have minimum two sheets. If you
don’t have insert sheet. Format hide sheet. So it will hide
the sheet.
You want hidden sheet back format unhide sheet.
Format move or copy sheet click on create copy so you will
get second copy of the original. If you don’t want second
copy don’t click on create copy so sheet will be moved.
Format rename sheet you give name .
Tab color select color so you will get color to the sheet
name
Format protect sheet give password and press enter again
enter password . so sheet will be protected you won’t able
to edit the sheet. Protect unprotect sheet so you will able to
edit it.
Insert row so row will be inserted where your cursor is.
If you don’t want click on delete row. Same is true for
column and sheet
Sort :- bring your cursor on that column which you want to
sort a to z means ascending order and z to a means
descending order.
Filter :- you will see arrow in front of each column you click
on that arrow deselect select all and click on that no or
name which you want so you will see that record only.
Custom sort you can select column and sort ascending or
descending order
Fill series :- type one number mark the area fill series give
step value of you will get no. automatic.
Merge and center :- type marksheet. Mark the area upto
where your sheet ends that particular row and click on
merge and center. So marksheet will come in the center.
Wrap text :- type some text and click on wrap text so text
will come automatic on the same cell next line.
Increase decimal place :- so it will increase decimal place
Decrease decimal place :- so it will decrease decimal place
Copy formula :- mark the area where formula is there copy
then mark the area where you want to paste click on edit
paste.
Marksheet
Name rollno word excel powerpoint total

Average max min count result

Total =sum(c2:e2)
Average =average(c2:e2)
Max =max(c2:e2)
Min =min(C2:e2)
Count =count(C2:e2)
Result
=if(and(c2>=40,d2>=40,e2>=40),”pass”,”fail”)

NAME PERDAY SALARY NOOF DAYS ABSENT total pf ptax

Total -> =b2*(c2-d2)

Pf -> =e2*10%
Ptax -> =if(e2<=1200,0,if(and(e2>1200,e2<=1500),15,20))
Pagalayout margins custom margin you can select paper
orientation portrait or landscape.
Margin you can set top,bottom,left,right , header and footer
margin.
Header/footer left section click on page number center
section click on insert date right section click on insert time
Sheet if gridline option is clicked you will see gridlines else
not.
You can mark area and click on small arrow beside
pagesetup and preview so you will see mark area columns
only.
Background :- you can select picture so that picture will be
your background.
Data :- in sheet bring your cursor on that column which you
want to sort ascending means a to z . descending means z to
a.
Filter :- you will get arrow in front of each record remove
click on select all and click on which record you want so you
will see that record only.
Text to column :- type one line for eg we are learning excel.
Text to column click on next two times click on text finish So
each word will come in the single cell.
Remove duplicates.
Type following information
Item qty
Computer 10
Computer 10
Printer 5
Printer 5
Stabilizer 10
Stabilizer 10
Select this information data remove duplicate so it will
remove double record.
Subtotal :- when item change you will get qty total
Mark some columns data group so you will get +sign in the
corner so you will see all the records click on –sign so data
will hide
Data ungroup you will remove outline i.e. + and – sign from
the list.
Data validation :- mark the area click on data validation give
maximum and minimum values so you can enter data in
that range only if you go beyond that it won’t accept. To
clear data validation select clear all
Scenario manager :- click on this option give name for the
scenario click on add mark the area and enter the values
click on show close.
Goal seek :- bring your cursor on that cell where formula is
there . click on goal seek to value give some value changing
cell you give the address of that cell which you want to
change. Use of this command is that it will change formula
value instead of formula it will change connect cell value
also.
Data table
Type
a b
Qty 12
Rate 12000
Amt =b1*b2 44 66 66
 55
67
55
Mark the area from b3 .. f7 data table
Row input cell type b1
Column input cell type b2
So you will get automatic values.
Review spelling and grammar if it is wrong click on
change correct ignore once
Thesaurus :- select particular spelling click on thesaurus
you get word having similar meaning which spelling you
want click on change else ignore once
Comment :- you can type information for your
reference if you don’t want click on delete
View pagebreak preview you will get small size
Normal you get original
Zoom :- you can select % from the list.
Freeze panes :- bring your cursor below heading click
on freeze panes so as you scroll down heading will
remain fix
If formula bar is clicked you will see else not
If heading is clicked you will see else not