Page 333 - TP_IT_V1.0_C9_flipbpookl
P. 333
6. Statement 1: Functions in LibreOffice Calc are predefined formulas that perform calculations using specific values, cell
references, or ranges.
Statement 2: The COUNT function in LibreOffice Calc counts the number of cells that contain numbers within a specified
range.
Ans. 4. a 5. b 6. a
Unsolved
SECTION A (Objective Type Questions)
A. Choose the correct option.
1. Cut, Copy and Paste commands are part of the in a spreadsheet.
a. Status Bar b. Formatting toolbar
c. Standard toolbar d. Formula Bar
2. Which is not a valid cell range?
a. A1:C1 b. A1:B1:D1
c. C1:C10 d. C2:G15
3. In LibreOffice Calc, how many default sheets are there in a spreadsheet?
a. 3 b. 4
c. 1 d. 2
4. The function used to calculate the maximum marks in computers is:
a. MAX(A1:A10) b. MAXIMUM(A1:A10)
c. HIGH(A1:A10) d. HIGHEST(A1:A10)
5. A formula can have
a. A constant value b. A cell address
c. A cell range d. All of these
6. The chart that shows the percentage is .
a. Column chart b. Line chart
c. Scattered chart d. Pie chart
7. Which of the following is not a type of data?
a. Numbers b. Formula
c. Text d. Operator
8. Which of the following formula is correct?
a. =MIN(C5:C10) b. =MINIMUM(C5:C10)
c. =MINI(C5:C10) d. =MIN(C5+C10)
9. Absolute cell referencing occurs when .
a. the formula is dragged and the cell reference adjusts automatically.
b. the formula is dragged but the cell references do not adjust.
c. $ symbol is automatically added with each cell value
d. the spreadsheet is saved with “absolute” as file name
10. You have used a spreadsheet to calculate the average marks of a class in Mathematics. Which input is essential to find the
average marks?
a. Marks of each student in Mathematics class.
b. Marks of each student in Science class.
c. Average marks in Mathematics for each student in the class.
d. Names and roll numbers of each student in the class.
Electronic Spreadsheet 331

