73 total views, 1 views today

## Activity : 03

- 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 :