Page 91 - Computer - 6

C. Write ‘T’ for True and ‘F’ for False statement.

1. The AutoFill feature can only fill a range of cells with same data. _______
2. The AutoComplete feature gives suggestions only for text data. _______
3. You can copy data from one cell to another by using the drag and drop method. _______

4. When you delete rows from a worksheet, the total number of rows gets reduced. _______
5. A number format affects the value of a number in a cell. _______

6. The Accounting Number Format adds a currency symbol to a number. _______
7. Once you have merged cells into a single cell, you cannot split them back. _______

D. Answer the following questions.
1. Write the steps to apply a background colour to a cell.

2. Write the steps to display text in a cell in multiple lines within a cell.
3. What is alignment? Write the steps to align the contents of a cell at top-right position in the cell.

4. What is number formatting? Name the various format options available in the Number Format
list.
5. How does the AutoComplete feature in Excel 2019 work?
6. Write the steps to move contents of a cell from one location to another in a worksheet.
7. Write the steps to create a custom list in Excel 2019.

Mind Stretching
1. Vidya has created an Excel worksheet about the states of India, their capitals and population. She
wants to add a column for the major language spoken in the states before the Population column.
Help her insert a new column. Computational Skills

2. Manish has created an Excel worksheet about a list of expenses he incurred on his birthday party.
He wants to add the Rupee symbol to the numeric values along with the two decimal places. Help
him do so. Computational Skills

3. Vishakha has created an Excel worksheet as shown in the image. Name the various formatting
features she has used to prepare it. Logical Thinking

89