73 total views,  1 views today

## Activity : 03

1. The following are some basic functions used in spreadsheet software. Write the relevant function according to their usage.‍
 SUM COUNT RANK COUNTA MIN IF MAX AVERAGE
 A Find the average of values ​​in a cell range B Find the sum of values ​​in a cell range C Find the grade of values ​​in a list of numbers. D Find the number of cells that contain values ​​within the cell range E Find the number of cells containing numbers, text, logical values, error values ​​or formulas. F Check the condition of given criteria and give one value if true or another value if false. G Find the largest value in a cell range H Find the smallest value in a cell range

A.

B.

C.

D.

E.

F.

G.

H.

2. Write the result of given functions according to the following worksheet. Function Result 1 =SUM(A1:D1) 2 =SUM(A2:D2) 3 =AVERAGE(A1:D1) 4 =AVERAGE(A2:D2)

3. Answer the questions using following worksheet.

## • Write down the formula that should be entered in cell F3 to calculate the total of Nimatha.

• Write steps to get others total after calculating Nimantha’s marks.

• Write down the formula that should be entered in cell G3 to calculate the average of Nimatha.

• Write down the formula that should be entered in cell C9 to find maximum marks for Paper I.

• Write down the formula that should be entered in cell D10 to find maximum marks for Paper II.

• Write down the function to be included in cell E11 to find the number of students who sat for paper III.

• Write down the function to be included in cell E12 to find the total number of students in the class who were scheduled to sat for paper III. 