number of cells that contain any value. C) Count the number of cells containing the value exceeding . Accountancy Solution Procedure i) Open a new spread sheet in MS-Excel. ii) Enter the data in cells from A1 to J2 as in the question iii) To get the Number of cells containing numbers only, write the formula in B3 =COUNT(A1:J2) iv) To get Number of cells that contain any value, write the formula in B4 =COUNTA(A1:J2) v) To get the Number of cells which have values exceeding , write the formula in B5 =COUNTIF(A1:J2,”> ”) Answer A) B) C) Illustration (AND function) There are three salesmen.
Two days of sales achievement is given. You are required to find out the salesmen who have achieved a minimum sale of ` on each day. Salesman Day ` Day ` Anand Balu Cibi Solution Procedure . Open new excel sheet.
. Input the table as given in the question. . Enter the data “Achieved” in Cell D1.
. Type the following in Cell D2: =AND(B2>= ,C2>= ) . Copy the formula in D2 into D3 and D4 Output Salesman Day ` Day ` Achieved Anand FALSE Balu TRUE Cibi FALSE Illustration (OR function) Find out from the following data, minimum collection of ` on any one day achieved by the sales counters. Counter Day sales ` Day sales ` Ground floor First floor Second floor Accountancy Solution Procedure .
Open new excel sheet. . Input the table as given in the question. .
Enter the data “Achieved” in Cell D1. . Type the following in Cell D2: =OR(B2>= ,C2>= ) . Copy the formula from D2 into D3 and D4 Output Counter Day sales ` Day sales ` Achieved Ground Floor TRUE First Floor TRUE Second Floor FALSE Illustration (IF function) Following is the list of students