Cbse class 6 computer Ch-2 Introduction to OpenOffice Calc

Cbse class 6 computer Ch-2 Introduction to OpenOffice Calc

Components

Menu Bar

Function Toolbar

Formatting Toolbar

Formula Toolbar

The cell address of the active cell is displayed in the Name Box.

Formatting Toolbar

Wrap Text

Select the cell or cell range to be formatted

Right click on the cell and select Format cells. The Format cells dialog box opens

Click on the Alignment tab and click on Wrap Text automatically checkbox

 

Format cells

Number

Currency

Date

Time

Scientific

Fraction

Percentage

Text

Functions

Sum() function is used to add numeric values

Average() function is used to calculate the average of the values

Min() function is used to find the lowest value within the selected cell range

Max() function is used to find the highest value within the selected cell range

 

=> Select the correct option

1. Which option is used for combining two or more cells into a single cell in Calc?

 i. Wrap text

ii. Merge & Center

iii. Orientation

iv. Alignment

 

 2. The ___________ displays the content of the active cell.

i. Menu bar

ii. Formatting toolbar

iii. Formula toolbar

 iv. Function toolbar

 

3. Observe the given worksheet showing marks obtained by students and answer the question. What will be the result of ‘=MAX(C2:C13)’?

i. 92

ii. 187

iii. 98

iv. 99

 

4. Neha has prepared a Calc worksheet as shown. What will be the output of the formula “=COUNTA(A3:A6)” for following table.

 i. 500

ii. 200

 iii. 4

iv. 6

 

5. Identify the keyboard shortcut used to create a new workbook.

i. Ctrl + N

ii. Ctrl + S

iii. Ctrl + O

iv. Ctrl + C

 

6. What is the address of the active cell in the following worksheet?

i. AD5

ii. Ad3

iii. AA5

iv. AD6

 

7. Observe the following spreadsheet. Which formula is used to calculate the total marks?

i. =SUM(B2:B7)

ii. =MIN(B2:B7)

iii. =MAX(B2:B7)

iv. =COUNT(B2:B7)

 

8. This feature helps to display the content of a cell in multiple lines in the same cell.

 i. Merge

 ii. Horizontal Alignment

iii. Split

iv. Wrap text

 

9. What is the cell value of the active cell in the given spreadsheet?

i. 175

ii. Sheryl

iii. D5

iv. Total Marks

 

10. Observe the given worksheet showing marks obtained by students. What will be the output of the following formula? =Count(E2:E12)

i. 11

ii. 187

iii. 99

iv. Shilpa