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