Samacheer Kalvi 8th Science Book Back Answers Chapter 23

Samacheer Kalvi 8th Science Book Back Question and Answers:

Samacheer Kalvi 8th Standard Science Book Back 1 Mark and 2 Mark Question & Answers PDF uploaded and available below. Class 8 New Syllabus 2022 to 2023 Book Back Questions & Answers/solutions available for both English and Tamil Medium. Class 8 std Science Book Chapter 23 – Libre Office Calc Science Answers/Solutions Guide are uploaded on this page. 8th standard Science Book is consists of 23 Units. All 23 chapters of Science Book Back One, and Two Mark Solutions are given below.

Check Unit wise and  Samacheer kalvi 8th standard Science Book Back Question and Answers Guide/Solutions PDF format for Free Download. Check and download all subjects English, Tamil, Maths, Science, and Social Science Book Back Questions and Answers available in PDF. Check 8th Science – Physics, Chemistry, and Biology below. See below for the Samacheer Kalvi 8th Science Book Back Answers Guide Chapter 23 PDF:




8th Science Book Back Chapter 23 Solutions Guide PDF:

Samacheer Kalvi 8th Science Subject 1 Mark and 2 Mark Solutions Guide 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.

8th Science Chapter – 23

Libre Office Calc – Book Back Answers

 

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.

  1. Select the data which you want to Sort
  2. 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 the 8th Science Book Back Solutions Guide:

Click here for Samacheer Kalvi’s 8th Science Book Back Questions with Solutions – Samacheer kalvi 8th Science Book Back Answers