Text functions There are several text functions such that are inbuilt in MS Excel. The following are explained. CONCATENATE Joins several text strings into one text string =CONCATENATE(text1, text2…) UPPER Converts all letters into Uppercase letters =UPPER(text) LOWER Converts all letters into Lowercase letters =LOWER(text) c. Logical functions There are several logical functions such that are inbuilt in MS Excel.
The following are explained. AND Returns TRUE if all arguments are TRUE =AND(logical1,logical2…) Accountancy OR Returns TRUE if any one argument is TRUE else returns FALSE =OR(logical1,logical2…) IF Returns one value if condition is true, and another value if false. =IF( , ,value_ ) d. Financial functions There are several financial functions such that are inbuilt in MS Excel.
The following are explained. SLN Returns the depreciation of an asset for a specified period using the Straight Line method. =SLN(cost,salvage,life) PMT Calculates the payment for a loan. =PMT(rate,nper,pv,fv,type) RATE Returns interest rate per period of loan.
=RATE(nper,pmt,pv,fv,type) . . (a) MS-Excel practical Illustration The following are the scores obtained by some students in a competitive examination. Find out the average, the highest and the lowest score using appropriate function in spreadsheet.
A B C D E F G H NAME Anbu Balu Gobu Ramu Somu Raju Anu SCORES Solution Procedure (i) Open a new spreadsheet in MS-Excel (ii) Enter all given values as given in the question. (iii) To find the Average mark in cell B5 give the formula =AVERAGE(B2:H2) (iv) To calculate the highest score, in cell B3 give the formula =MAX(B2:H2) (v) To find the lowest rank in cell B4 give the formula =MIN(B2:H2) Answer: The average score is , the highest score is and the lowest score is . Illustration The following table is given to you. Find solution for the following questions.
A B C D E F G H I J TAX GST CASH BRS STOCK DEBT A) How many cells contain numbers only? B) Count the