**Samacheer Kalvi 8th Science Unit 23 Book Back Answers:**

**Samacheer Kalvi 8th Standard New Science** Book Back 1 Mark and 2 Mark Question & Answers PDF uploaded and available below. Class 8 New Syllabus 2021 to 2022 Book Back Question & Answer available for both English and Tamil Mediums. **Class 8th Science Book Unit 23 – Libre Office Calc ****Answers/Solutions** are provided on this page. **8th Std Science Book **consists of 23 units, All Science Book Back One, and Two Mark Solutions are given below.

Check Unit wise and Samacheer Kalvi **8th Science Book Back Solutions Answers** PDF format for Free Download. English, Tamil, Maths, Science, and Social Science Book Back Question and Answer is available in PDF. Class 8th Standard Science Book Back Answers PDF. Check Science book back Answers below. See below for the 8th New Science Syllabus Book Back guide/Answers free PDF download:

**Samacheer Kalvi 8th Science Book Back Solutions PDF:**

8th Science Subject 1 Mark and 2 Mark Solutions PDF available below. Click the Download option to download the book back 1 Mark & 2 Mark questions and answers. Take the printout and use it for exam purposes. Samacheer Kalvi 8th Science Unit 23 Answers are given below.

**Science Book Back Answers**

**Unit 23 –** **Libre Office Calc**

**I. Choose the best answer.**

1. All functions begins with an ______ sign

a) = b) – c) > d) }

**Answer:** **a) = **

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

a) Average b) Sum c) Min d) Max

**Answer: b) Sum**

3. The _____ character is used in text formula.

a) Ampersand b) Comma c) Exclamation d) Hyperlink

**Answer: a) Ampersand**

4. Which of the following is a relational operator?

a) + b) > c) – d) NOT

**Answer: b) > **

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

a) Average b) Sum c) Min d) Max

**Answer: c) Min **

**II. Answer in detail.**

**1. Explain the count function with an example.**

**Answers: **

The COUNT Function is an Excel Statistical function. This function helps count the number of cells that contain a number, as well as the number of arguments that contain numbers. It will also count numbers in any given array.

Formula = COUNT(value1, value2….)

**2. What is the purpose of charts?**

**Answers:**

One of the most popular features of Libre Office Calc software is to generate charts based on numeric data. The purpose of the chart is to visualize the data for easy understanding. To draw a chart, follow the procedure given below:

• Select the data which you want to chart.

• Click on Insert → Chart or click on the Insert Chart icon.

**3. What is the use of Sorting?**

**Answers:**

Arranging a given set of data according to a particular order (ascending or descending) is called sorting.

- Select the data which you want to Sort
- Click on Data → Sort

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

**Answers:**

Function |
Description |
Example |
Result |

MAX() |
Calculates the maximum value from a given set of values | = MAX(A2:A6) | 87 |

MAX() |
Calculates the minimum value from a given set of values | = MIN(A2:A6) | 47 |

**5. What is cell address?**

**Answers:**

A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell address contains ‘one or more letters followed by a number. The letter or letters identify the column and the number represents the row.

**Other Important links for 8th Science Book Back Answers:**

Click here for Samacheer Kalvi 8th Science Book Back Solutions – **8th Science Book Back Answers **