.expain how to calculate NPV in excel sheet by using inbuit formula

By typing...

=NPV(

... in a cell then clicking on the fx button just left of the formula bar to open the Function Arguments window. This will help you understand what data to put in each field.