Posts
VIII- SCIENCE- LIBRE OFFICE CALC- SOLUTIONS FOR TEXT BOOK EXERCISES
LIBRE OFFICE CALC
TEXTBOOK EXERCISES
I. Choose the best answer
1. All functions begins with an ______ sign
a) = b) - c) > d) }
Ans: a) =
2. ______ function is used to calculate the total of a given set of values.
a) Average b) Sum c) Min d) Max
Ans: b) Sum
3. The _____ character is used in text formula.
a) Ampersand b) Comma c) Exclamation d) Hyperlink
Ans: a) Ampersand
4. Which of the following is a relational operator?
a) + b) > c) - d) NOT
Ans: d) NOT
5. The ________ function returns the smallest value in a set of values.
a) Average b) Sum c) Min d) Max
Ans: c) Min
II. Answer in detail.
1. Explain count function with an example.
COUNT()- function Counts the number of values (cell containing numbers).
Formula to by typed in the cell is = COUNT(A2:A6)
The above example will give a result of 5, as the number of marks entered here are five.
2. What is the purpose of charts?
One of the most popular features of Libre Office Calc software is to generate charts based on numeric data.
The purpose of charts is to visualize the data for easy understanding.
3. What is the use of Sorting?
The function used to arrange a given set of data according to a particular order (ascending or descending) is called sorting.
4. What is the use of MAX () and MIN () functions?
MAX() - function, calculates the maximum value from a given set of values.
MIN () - function, calculates the minimum value from a given set of values.
5. What is cell address?
The cell address is a combination of column letter and row number.
The first active cell’s address will be A1.
The name box displays the address of the active cell.
