KnowledgeBoat Logo
OPEN IN APP

Chapter 5 - Unit 2

Spreadsheet - An Introduction: More on Spreadsheet

Class 7 - APC Understanding Computer Studies


Choose the correct option

Question 1

A group of multiple cells that are selected to perform different operations is known as ............... .

  1. group
  2. cell group
  3. range
  4. range of cells

Answer

range of cells

Reason — When we select more than one cell in a worksheet, the selected cells are known as the range of cells.

Question 2

Which of the following rows are selected to unhide row number 5?

  1. Rows 3 and 4
  2. Rows 6 and 7
  3. Rows 4 and 6
  4. Select entire row and click unhide.

Answer

Rows 4 and 6

Reason — To unhide a row, the rows above and below the hidden rows are selected.

Question 3

Which of the following features generates a particular series of numbers without entering them manually in a spreadsheet?

  1. FillAuto
  2. AutoSeries
  3. AutoFill
  4. Fill

Answer

AutoFill

Reason — The AutoFill feature allows us to enter a series of numbers without entering them manually in a spreadsheet.

Question 4

Which of the following options allows you to move a set of data marked under range from one sheet to other?

  1. Copy
  2. Copy-paste
  3. Paste
  4. Paste-copy

Answer

Copy-paste

Reason — Copy and Paste allows us to duplicate data within the same worksheet or in another worksheet.

Question 5

Which of the following options will you select under Home tab to change Row Height in a worksheet?

  1. Insert
  2. Format
  3. File
  4. View

Answer

Format

Reason — Row Height option is given under the Format menu on the Home Tab.

State True or 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 option 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

Case-Study Based Questions

Question 1

Rajat has purchased some stationery items from ABC shop. He created the worksheet containing Product Name, Unit Price and Quantity. He calculated the Amount of different items using formulae in Excel. The worksheet created by him is as shown alongside:

Rajat has purchased some stationery items from ABC shop. Spreadsheet Introduction, Understanding Computer Studies Solutions ICSE Class 7.

Based on the above case, answer the following questions:

(a) What formula would he have used in the cell D2 to find the amount of pens?

(b) Fill in the blank to hide the particulars of the Product Name in the following statement:
Select row number 4 and click: Home → Format → ...............

(c) Fill in the blank to delete the amount from column D in the following statement:
Select column name D and click: Home → Delete → ...............

(d) What is the value of default row height in a worksheet?

Answer

(a) =B2*C2

(b) Home → Format → Hide & Unhide → Hide Rows

(c) Home → Delete → Delete Sheet Columns

(d) By default, Excel adjusts the row height as per the largest font size in a row.

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