**Samacheer Kalvi Class 8 Science Unit 23 Libre Office Calc Solutions**

**Samacheer Kalvi Class 8 Science Unit 23 Libre Office Calc Solutions**

Welcome to NCTB Solutions. Here with this post we are going to help 8th class students by providing Solutions for Samacheer Kalvi Class 8 Science Unit 23 Libre Office Calc. Here students can easily find all the solved solution for Libre Office Calc Exercise questions. Also here our Expert Science Teacher’s solved all the questions with easily understandable language with proper guidance so that all the students can understand easily. Here on this post students will get Unit 23 Libre Office Calc exercise solutions. Here all the solutions are based on Tamil Nadu State Board latest syllabus.

**Unit 23 Libre Office Calc Exercise Questions Solutions :**

**Unit 23 Libre Office Calc Exercise Questions Solutions :**

**(I) Choose the best answer : **

**(1) All functions begins with an** ___** sign**

**(a) =**

**(b) –**

**(c) >**

**(d) }**

**Answer : **

Correct Option → (a)

All functions begins with an = sign

**(2)** ___** function is used to calculate the total of a given set of values.**

**(a) Average**

**(b) Sum**

**(c) Min**

**(d) Max**

**Answer : **

Correct Option → (b)

Sum function is used to calculate the total of a given set of values.

**(3) The** ____** character is used in text formula.**

**(a) Ampersand**

**(b) Comma**

**(c) Exclamation**

**(d) Hyperlink**

**Answer : **

Correct Option → (a)

The Ampersand character is used in text formula.

**(4) Which of the following is a relational operator?**

**(a) +**

**(b) >**

**(c) –**

**(d) NOT**

**Answer : **

Correct Option → (b)

> is a relational operator.

**(5) The **__ **function returns the smallest value in a set of values**

**(a) Average**

**(b) Sum**

**(c) Min**

**(d) Max**

**Answer : **

Correct Option → (c)

The Min function returns the smallest value in a set of values.

**(II) Answer in detail**

**(1) Explain count function with an example.**

**Answer : **

COUNT () → it is used to count the number of values cell containing numbers are count by this function. For example : = COUNT (A2:A6)

**(2) What is the purpose of charts?**

**Answer : **

The purpose of the charts is t o visualize the data for easy understanding.

**(3) What is the use of Sorting?**

**Answer : **

Arranging a given set of data according to a particular order ascending or descending is called sorting. It used for arranging a data in a particular order.

**(4) What is the use of MAX () and MIN () functions?**

**Answer : **

The MAX () function is used to calculates the maximum value from a given set of value

The MIN () functions are used to calculate the minimum value from a given set of values.

**(5) What is cell address?**

**Answer : **

The insertion of a row and a column is known as cell. Each cell is introduced by its cell address the cell address is a combination of column letter and row number.

**Previous Chapter Solution : **