Electronic Spreadsheet 03

  • by

 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

Answer :

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.

Answer :

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

Answer :

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

Answer :

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

Answer :

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

Answer :

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

Answer :

  • 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.

Answer :


0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments