Answer Key [PART-B]
Grade: IX
Subject: Information Technology (402)
Unit 4: Electronic Spreadsheet
Chapter 10 : Creating A Spreadsheet
Answer the Following Questions:
1. A workbook is a collection of one or more worksheets, in a single file. Each workbook has
a single theme and contains, at least, one worksheet. The workbook is designed to hold
together multiple worksheets in order to organise and consolidate data efficiently. Whereas,
A worksheet is composed of a very large number of cells, which are the basic storage unit
for data in a file or workbook. Each sheet contains cells arranged in grid pattern using rows
and columns.
2. There are 1,048,576 row, 1024 columns and 1,073,741,824 cells in a Calc worksheet.
3. A range is a group of contiguous cells, which are selected or denoted collectively. It can be
as small as a single cell or as big as an entire worksheet. You can specify a range by
writing the starting cell address followed by the ending cell address, both separated by a
colon (:). For example, a range starting from C3 and ending in J10 would be written as B2:H8.
4. Right-click on the sheet tab of Sheet2 and choose Insert Sheet option from the menu.
Choose Before Current Sheet from the Insert Sheet dialog box. Click on OK.
5. Right-click on the desired worksheet tab and choose the Move or Copy Sheet option and
choose the new document option from the 'To document' drop-down list and click on OK.
Chapter-11 : Editing Data In A Spreadsheet
Answer the Following Questions
1. The text entered in a cell by using the keyboard is called a label. A label can be a combination
of both numeric and non-numeric data along with spaces. By default, the labels are left-
aligned in a cell and are never used for calculation purposes. Whereas, the numeric data is
called value in Calc and can contain the digits 0-9. By default, the values are right-aligned in
a cell.
1
, 2. A formula is a symbolic expression that can include numbers, cell addresses, arithmetic
operators, and parenthesis. Formulas establish a relationship between two or more cells. It
is used to calculations. It starts with ‘=’ sign. For example, =(4+8*2) will show the result 20.
3. To insert a blank row above row 5:
• Right-click on the row header of row 5, where you want to insert a new row.
• From the Context menu, select the Insert Rows option.
• A new row will be inserted just above the row 5.
4. COUNT() function counts the number of values such as numeric entries, logical values,
formulas, and date entries in a given range of cells. For example, =COUNT(A4:G4) will count
all numeric entries from A4 to G4.
5. Functions are pre-designed formulas to perform simple and complex calculations. They
eliminate the chance to write wrong formulas.
The functions are made up of two parts : Arguments and Structure
Brain Developer:
SECTION 4: THEORY QUESTIONS-(UNSOLVED)
1. Functions are pre-designed formulas to perform simple and complex calculations. They
eliminate the chance to write wrong formulas. The functions are made up of two parts —
Arguments and Structure.
Arguments are input values to functions. These can be numbers, text, logical values (such as
True or False), range of cells, constants, formulas or even other functions.
The Structure of a function defines its basic skeleton, which forms the basis of writing the
general syntax of functions. The structure begins with the function name followed by a list
of arguments separated by commas (semicolon in case of range of cells) within the
parenthesis. A function must begin with the ‘=’ sign.
=FUNCTION NAME (argument1, argument2, argument3)
2. Count() function counts the number of values such as numeric entries, logical values, formulas,
and date entries in a given range of cells.
3. a) Average() b) Max() c) Sum() d) Min()
4. Some important features of spreadsheet are:
• Functions and Formulas: Functions are the built-in formulas which are used for making
calculations such as calculating percentage, interest, average, etc., in Calc. Formulas are
mainly used for performing simple and complex calculations.
• Formatting Features: These features are used for improving the appearance of data.
• Auto-calculation: The data is automatically recalculated in the whole worksheet, if any
change is made in a single cell.
2
Grade: IX
Subject: Information Technology (402)
Unit 4: Electronic Spreadsheet
Chapter 10 : Creating A Spreadsheet
Answer the Following Questions:
1. A workbook is a collection of one or more worksheets, in a single file. Each workbook has
a single theme and contains, at least, one worksheet. The workbook is designed to hold
together multiple worksheets in order to organise and consolidate data efficiently. Whereas,
A worksheet is composed of a very large number of cells, which are the basic storage unit
for data in a file or workbook. Each sheet contains cells arranged in grid pattern using rows
and columns.
2. There are 1,048,576 row, 1024 columns and 1,073,741,824 cells in a Calc worksheet.
3. A range is a group of contiguous cells, which are selected or denoted collectively. It can be
as small as a single cell or as big as an entire worksheet. You can specify a range by
writing the starting cell address followed by the ending cell address, both separated by a
colon (:). For example, a range starting from C3 and ending in J10 would be written as B2:H8.
4. Right-click on the sheet tab of Sheet2 and choose Insert Sheet option from the menu.
Choose Before Current Sheet from the Insert Sheet dialog box. Click on OK.
5. Right-click on the desired worksheet tab and choose the Move or Copy Sheet option and
choose the new document option from the 'To document' drop-down list and click on OK.
Chapter-11 : Editing Data In A Spreadsheet
Answer the Following Questions
1. The text entered in a cell by using the keyboard is called a label. A label can be a combination
of both numeric and non-numeric data along with spaces. By default, the labels are left-
aligned in a cell and are never used for calculation purposes. Whereas, the numeric data is
called value in Calc and can contain the digits 0-9. By default, the values are right-aligned in
a cell.
1
, 2. A formula is a symbolic expression that can include numbers, cell addresses, arithmetic
operators, and parenthesis. Formulas establish a relationship between two or more cells. It
is used to calculations. It starts with ‘=’ sign. For example, =(4+8*2) will show the result 20.
3. To insert a blank row above row 5:
• Right-click on the row header of row 5, where you want to insert a new row.
• From the Context menu, select the Insert Rows option.
• A new row will be inserted just above the row 5.
4. COUNT() function counts the number of values such as numeric entries, logical values,
formulas, and date entries in a given range of cells. For example, =COUNT(A4:G4) will count
all numeric entries from A4 to G4.
5. Functions are pre-designed formulas to perform simple and complex calculations. They
eliminate the chance to write wrong formulas.
The functions are made up of two parts : Arguments and Structure
Brain Developer:
SECTION 4: THEORY QUESTIONS-(UNSOLVED)
1. Functions are pre-designed formulas to perform simple and complex calculations. They
eliminate the chance to write wrong formulas. The functions are made up of two parts —
Arguments and Structure.
Arguments are input values to functions. These can be numbers, text, logical values (such as
True or False), range of cells, constants, formulas or even other functions.
The Structure of a function defines its basic skeleton, which forms the basis of writing the
general syntax of functions. The structure begins with the function name followed by a list
of arguments separated by commas (semicolon in case of range of cells) within the
parenthesis. A function must begin with the ‘=’ sign.
=FUNCTION NAME (argument1, argument2, argument3)
2. Count() function counts the number of values such as numeric entries, logical values, formulas,
and date entries in a given range of cells.
3. a) Average() b) Max() c) Sum() d) Min()
4. Some important features of spreadsheet are:
• Functions and Formulas: Functions are the built-in formulas which are used for making
calculations such as calculating percentage, interest, average, etc., in Calc. Formulas are
mainly used for performing simple and complex calculations.
• Formatting Features: These features are used for improving the appearance of data.
• Auto-calculation: The data is automatically recalculated in the whole worksheet, if any
change is made in a single cell.
2
