Class 10 IT | Chapter - Spreadsheet | Topic - Inserting Sheet Open Office Calc - Arvindzeclass

How to Insert multiple Sheets in OpenOffice Calc?

Workbook: A Workbook is a collection of sheets. By default a Workbook has three Worksheets.

Worksheet: A Worksheet is a combination of rows and columns in a form of table where data is entered.

These are the steps to insert new sheets in a workbook:
1) Go to Insert tab.
2) Select Sheet option.
or
1) Click in empty space at the end of the line of the sheet tab.

Insert Sheet Dialogue Box

--------------------------------------------------

Topic of this Chapter

-------------------------------------------------

How create cell reference using keyboard and mouse in OpenOffice Calc?

These are the steps to create reference using mouse or keyboard:
Cell Reference on same sheet:
1) Click on a cell.

2) Type equal to (=) sign.

3) Press cell address.
For example : =B1

Cell Reference on different sheet:

With Mouse
1) Go to sheet 2 and select the cell where we want to create reference.

2) Type equal (=) to sign.

3) Go to sheet 1 where we want to set reference.

4) Select the cell and click green accept button.

With Keyboard
1) Go to sheet 2 and select the cell where we want to create reference.

2) Type equal (=) to sign, sheet name, and cell address
For example: =’sheet 1’.B17

--------------------------------------------------

Class 10 IT (402) Question Answer

Part - A

Chapter 1 – Communication Skills

Chapter 2 –Self - Management Skills

Chapter 3– ICT Skills

Chapter 4 - Entrepreneurship

Chapter 5 –Green Skills

Part - B

Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 – Database Management System
Chapter 4 –Web Application

--------------------------------------------------

Create Reference

Cell Reference on other File:

With Mouse
1) Go to sheet 2 and select the cell where we want to create reference.

2) Type equal (=) to sign.

3) Open other file where we want to set reference.

4) Select the sheet and the cell and click green accept button.

--------------------------------------------------

Sample Papers of Class 10

-------------------------------------------------

With Keyboard
1) Go to sheet 2 and select the cell where we want to create reference.

2) Type equal (=) to sign, then File path, sheet name, and cell address