Science : Chapter 23 : Libre Office Calc
TEXTBOOK EXERCISES
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 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
5. What is cell address?
Answer: The cell address is a combination of column letter and row number.