ms excal me A1 se A10 ki kishikso ko jodne ke liye mano ka sutar kiya h
Answers
Answered by
0
Answer:
=sum (A1+A10)
then hit the enter button
Answered by
6
Answer:
first let us see all the functions in ms excel:
- sum: adds all the numbers in the cell range. it has to be done by =sum(a1,a2)
- if: checks whether a condition is met,and returns one value if true or if false. it can be inserted by =IF(logical_test,value_if_true,value_if_false).
- average: it returns the average of the numbers. it can be inserted by =AVERAGE (a1,a2).
- hyperlink: creates a shortcut or jump that opens documents stored on your hard drive, internet server , etc. it can be inserted by =HYPERLINK(link_location,friendly_name).
- count: counts the number of cells in a range. it can be inserted by =count (a1,a2).
- MAX: returns the largest value in the cells inserted. it can be inserted by =max(a1,a2).
- sin: it returns the sine of a number. it can be inserted by =sin(number).
- sumif: adds the cells by given condition or criteria. it can be inserted by =sumif (range,criteria,sum_range).
- pmt: it calculates the payment for a loan. it can be inserted by =pmt( rate,nper,pv,fv,type)
- stdev: it estimates the standard deviaion of a number. it can be inserted by =stdev (a1,a2).
so here we have to add,
we can use =sum (a1,a2,a3,a4,a5,a6,a7,a8,a9,a10) or else we can use =sum (a1;a10)
Attachments:
Similar questions