Chapter 6 More About Excel (Class 6)

Chapter 6
More About Excel

A. Tick the correct answer and fill in the blank. 

1. Copy  means duplicating the data.
2. Cut, copy and paste commands are present in Clipboard group.
3. Auto Fill feature allows to fill a series of data automatically.
4. Formula in Excel starts with Equal to (=) sign.
5. Orientation command is used to rotate the contents of a cell.

B. Name these alignment option.

 


C. Identify the following pictures.

1. Cut
2. Copy
3. Paste
4. Undo

D. Write True or False.
 
1. Cell contents cannot be deleted. False
2. Inserting rows or columns changes the size of the worksheet. False
3. Auto Fill feature allows to fill data automatically. True
4. Cell address cannot be used in a formula. False

E. Answer in short. 

1. What is Auto Fill?
Ans – The Auto Fill feature of Excel is used to quickly fill a predefined series of data such as text or numbers in worksheet.

2. What is the use of Merge & Center command?
Ans – The Merge & Center command is used to combine two or more selected adjacent cells to create a single cell.

3. In which tab will find Wrap Text command?
Ans – In Home tab we will find Wrap Text command.

F. Answer in detail. 

1.  How will you insert columns in a worksheet?
Ans – To insert rows/columns: 

Step 1: Select the row to insert a new row above it or select the column to insert a new column to its left.

Step 2: Click on Home tab. 

Step 3: Click on Insert from the Cells group. 

Step 4: Click the Insert Sheet Rows option to insert a new row or Insert Sheet Columns option to insert a new column.

2. Explain the method for moving the data in a worksheet.
Ans – To move the contents of a cell: 

Step 1: Select the cell or range.

Step 2: Click on Home tab.

Step 3: Click on Cut from the Clipboard group. An animated dashed line appears around the cell. 

Step 4: Click on the new cell where you want the content to be moved. 

Step 5: Click on Paste from the Clipboard group.

3. Explain the working of Undo and Redo commands.
Ans – Undo command is used to reverse the last action done. Redo command reverses the thing we have undone. These buttons are found on the Quick Access toolbar.

4. How will you insert a list of months without entering manually?
Ans – To fill day/months: 

Step 1: Enter the first value of day or month in a cell and press the Enter key. Select the cell. 

Step 2: Drag the fill handle to enclose the desired cells to be filled with the series.

5. Explain the difference between Copy and Cut commands.
Ans – We can copy the contents of a cell to other cells by using Copy and Paste commands. We can move the contents of a cell to some other location by using Cut and Paste commands.