KnowledgeBoat Logo
OPEN IN APP

Chapter 5 - Unit 2

Spreadsheet - An Introduction: More on Spreadsheet

Class 7 - APC Understanding Computer Studies


State whether the following statements are True/False

Question 1

When you click on 'Insert' button, a row is inserted in a spreadsheet.
False

Question 2

Row height changes automatically when the size of the text increases.
True

Question 3

By default, the row height or column width is measured in points.
True

Question 4

You can delete rows but not the column in a spreadsheet.
False

Question 5

Copy and Paste allow making duplicate copy of the cell/range of cell.
True

Question 6

Once column width is set, it can't be changed in a spreadsheet.
False

Fill in the blanks

Question 1

Editing means modification/rectification in a spreadsheet.

Question 2

When two or more cells are selected, it is called range of cells.

Question 3

When you click on 'Delete Sheet Rows' under 'Delete' option, the selected records gets deleted.

Question 4

'Row Height' option is available under Format button in the Ribbon.

Question 5

When you click on Insert Sheet Columns under 'Insert', a new column is inserted.

Question 6

Delete key can be used to remove the cell content.

Question 7

In a cell, every Mathematical formula/task must begin with an equal to (=) sign.

Name the following

Question 1

Three tasks under editing a worksheet

Answer

1. Insert Rows/Columns
2. Format Row Height
3. Format Column Width

Question 2

The shortcut keys for:

a) Cut: ............

    Paste: ............

b) Copy : ............

    Paste: ............

Answer

a) Cut: Ctrl + X

    Paste: Ctrl + V

b) Copy : Ctrl + C

    Paste: Ctrl + V

Write short answers

Question 1

Cut-Paste

Answer

It is a feature of MS Excel where a part of the worksheet is removed from the original location and pasted at the desired location. The 'cut' part of the worksheet may be present within the same worksheet or another worksheet.

In this option, we can shift the content of the cell/range of cell from one place to the desired place.

Question 2

AutoFill

Answer

MS Excel provides AutoFill feature to fill the series of values automatically in the cells without entering them manually one by one. The user has to enter the first two values in the adjacent cells to get the series of the required numbers.

Question 3

Copy-Paste

Answer

In this feature of MS Excel, we can copy a certain part of worksheet to the desired location. The 'copy' part of the worksheet may be present within the same worksheet or in another worksheet.

We can make a duplicate copy of the cell/range of cells at different locations.

Question 4

Editing

Answer

Editing is important as it can modify/rectify our workbook. MS Excel provides a variety of tasks that can be performed on a workbook to present it in a more organised way.

Editing includes inserting rows/columns, formatting row height, formatting column width, deleting rows/columns, hiding rows and columns, cut/copy and paste etc.

Long Answer Questions

Question 1

Give two differences between Cut-Paste and Copy-Paste.

Answer

Two differences between Cut-Paste and Copy-Paste are as follows:

Cut-PasteCopy-Paste
It is the process of moving a block from one place to another.It is the process of making duplicate copies of the block of a worksheet.
Shortcut keys used are Ctrl + X for cutting and Ctrl + V for pasting.Shortcut keys used are Ctrl + C for copying and Ctrl + V for pasting.

Question 2

Write down all the steps:
(a) To select a row in a worksheet
(b) To insert a column in a worksheet
(c) To delete a row in a worksheet
(d) To set a row height in a worksheet
(e) To hide rows in a workbook

Answer

(a) To select a row in a worksheet

To select a row in a worksheet, follow these steps:

Step 1: Take the cell pointer on the left hand side of the worksheet where the row numbers are mentioned. The cell pointer will change into a black horizontal arrow.

Step 2: Left click on any row number to select that row.

(b) To insert a column in a worksheet

To insert a column in a worksheet, follow these steps:

Step 1: Set the cell pointer at adjacent cell to which you want to insert a new column.

Step 2: Click 'Insert' button that is present in the Ribbon under 'Home' menu.

Step 3: Click 'Insert Sheet Columns'.

A new column will be inserted on the left of the active cell.

(c) To delete a row in a worksheet

To delete a row in a worksheet, follow these steps:

Step 1: Select the row which you want to delete from the worksheet.

Step 2: Click 'Delete' option which is available in Ribbon under 'Home' menu.

Step 3: Select 'Delete Sheet Rows' from the drop-down list.

The selected row will be deleted.

(d) To set a row height in a worksheet

To set a row height in a worksheet, follow these steps:

Step 1: Select the range of rows of which you want to change the height.

Step 2: Click 'Format' available in Ribbon under 'Home' menu. Select 'Row Height'. It shows the default row height.

Step 3: Set the row height as per your requirement and click 'OK'.

The new row height of the worksheet is set.

(e) To hide rows in a workbook

To hide rows in a workbook, follow these steps:

Step 1: Select the rows of the active worksheet that need to be hidden.

Step 2: Click 'Format' available in Ribbon under the 'Home' menu.

Step 3: Under Visibility, select 'Hide and Unhide' from the drop-down list.

Step 4: Click 'Hide Rows'.

The selected rows will be hidden.

PrevNext