Class 7 More on Spreadsheet

Quick Check

Fill in the blanks.

1. In Excel, to select a row, click on its row header.
2. To select non-adjacent rows/columns, select the row/column and then hold down the Ctrl key.
3. In Excel, to enter a special number like '055' as text, place an apostrophe before the number.
4. The Undo command cancels the last action you performed.
5. To insert a row in Excel, click on any cell where a new row has to be inserted and choose the 'Insert Sheet Rows' option.

Choose True or False for the following statements.

1. To change the height of a row in Excel, you can select the row and use the 'Row Height' option in the Format Cells dialog box. True
2. In Excel, the default column width is 8.43. True
3. The 'AutoFill' feature in Excel automatically calculates and fills in values based on a selected data series. True
4. The 'Custom Lists' feature in Excel allows you to create user-defined lists to save time when entering data. True

Time to Perform

A Fill in the blanks.

1. To select a cell, simply click on the cell.
2. To select adjacent rows/columns, select the first row/column and then hold down the Shift key, while selecting the last row/column.
3. We can modify the content of cells either by replacing the content of cells or by using the edit mode.
4. Edit mode is indicated on the left side of the Status bar.
5. Undo command cancels the last action that you performed in your worksheet.

B State whether the following statements are true or false.

1. To enter special number, we use apostrophe after the number. False
2. 065 will be displayed as 065 in Excel. False
3. Redo command cancels the Undo command. True
4. To select the entire worksheet, click on the corner blank header before Column B and Row 1. False
5. Date and Time elements are separated by '/' or '-'. True

C Name the following.

1. Default row height. 15
2. Default column width. 8.43
3. Group and tab of Paste button. Clipboard group, Home tab
4. Group of Fill command. Editing group
5. Shortcut key for Cut button. Ctrl + X

D Write the steps to perform the following tasks.

1. Select a range of cells/rows/columns.
   Place the mouse pointer on the first cell/row/column and drag the mouse in the desired direction before releasing the mouse button.
2. Enter date and time.
   Select the desired cell. Enter date.
   Home tab→Cells group→Format dropdown button→Format Cells option.
   Click on the Date and Time options in the Category list of Number tab.
   Select the desired format.
3. Replace content of cells.
   Select the desired cell.
   Enter new value.
4. Use Edit mode.
   Double-click on the desired cell.
   Make necessary changes.
5. Delete cells, rows and columns.
   Home tab→Cells group→Delete dropdown arrow.
   Select Delete Cells/Delete Sheet Rows/Delete Sheet Columns option.

E Answer the following questions.

1. How is deleting a cell different from deleting its content?
   When we delete the content of a cell, the cell remains. Only its content is erased. But when we delete a cell, the cell along with its content is removed.
2. Write the steps to insert new cells, columns and rows.
   Home tab→Cells group→Insert Cells/Insert Sheet Rows/Insert Sheet Columns
3. How can we adjust the row height and the column width?
   Home tab→Cells group→Format button dropdown→Row Height/Column Width
   Enter the desired value.
4. Discuss the AutoFill feature of Excel 2016. Also write the steps to use it.
   The AutoFill feature fills cell data or series of data into a selected range of cells in a worksheet. Following are the steps to use it:
   Fill data in two cells and select them.
   Home tab→Editing group→Fill button→Series option
5. What are custom lists?
   Custom lists help in creating user-defined lists and saves time.

Extra Questions.

1. Shortcut key to select the entire worksheet. Ctrl + A
2. Shortcut key to Copy: Ctrl + C
3. Shortcut key to Paste: Ctrl + V
4. The Undo button is present in the Quick Access Toolbar.
5. Copying the content of cells means duplicating the content of cells.
6. Moving the content of cells means removing content of cells from one location and placing them to another location.