Home | Book Back Question and Answers | Samacheer Kalvi 8th Science Books Libre Office Calc

# Samacheer Kalvi 8th Science Books Libre Office Calc

## Science : Chapter 23 : Libre Office Calc

TEXTBOOK EXERCISES

1. All functions begins with an ______ sign

a) =

b) –

c) >

d) }

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

a) Average

b) Sum

c) Min

d) Max

3. The _____ character is used in text formula.

a) Ampersand

b) Comma

c) Exclamation

4. Which of the following is a relational operator?

a) +

b) >

c) –

d) NOT

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

a) Average

b) Sum

c) Min

d) Max

1. Explain count function with an example.

Answer: Use the count function to get the number of entries in a number field that is in a range or array of numbers.

Example:

= COUNT(A2:A6)

Result = 5

2. What is the purpose of charts?

Answer: The main functions of a chart are to display data and invite further exploration of a topic. The purpose of chart is to visualize the data for easy understanding.

3. What is the use of Sorting?

Answer: Sorting is the process of arranging data in ascending or descending order. The most commons uses of sorted sequences are: making lookup or search efficient, making merging of sequences efficient.

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

Answer:  Use of Max(): Calculates the maximum value from a given set of values

Use of Min(): Calculates the minimum value from a given set of values