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

(I) Choose the best answer :

(1) All functions begins with an ___ sign

(a) =

(b) –

(c) >

(d) }

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

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

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

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

Correct Option → (c)

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

(1) Explain count function with an example.

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?

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

(3) What is the use of Sorting?

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?

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.