Page 67 - Code & Click - 6

Post-Processingost-Processing
P
 Excel provides options to enter, edit, and format data in a worksheet.
 The AutoComplete feature in Excel allows you to quickly enter similar text in different cells
of the same column.
 The AutoFill feature in Excel allows you to quickly fill a range of cells with a series of data

without typing each value one by one.
 New cells, rows, and columns can be added to a worksheet to add more content.
 Excel lets you change the height and width of cells to view content properly.

 Cell formatting options let you change the appearance of cells in a worksheet, such as
background colour and borders.
 The Wrap Text and Merge & Center options let you view long data in a cell easily.

Info Retention

A. Select the correct option for each of the following statements.

1. The key combination used to enter the current time in a cell is ______.
(a) Ctrl + ; (b) Ctrl + Shift + ; (c) Ctrl + Alt + ; (d) Shift + ;

2. The small square at the bottom-right of the active cell is called the ______.
(a) Fill box (b) Fill square (c) Fill handle (d) Copy handle

3. The group on the Home tab that lets you change the orientation of contents of a cell is
______.
(a) Editing (b) Alignment (c) Styles (d) Cells

4. The feature that allows you to combine two or more cells into one large cell is ______.
(a) Merge & Center (b) Wrap Text (c) Orientation (d) AutoFill

B. Fill in the blanks with the correct answer.

1. The _____________ feature allows you to quickly enter similar text in different cells of the
same column.
2. The _____________ feature is used to fill a range of cells with data without the need to type
each data value.

3. _____________ refers to the placement of cell contents within the boundary of a cell.

4. _____________ refers to the direction of cell contents inside a cell.

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. A number format affects the value of a number in a cell. _______

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

65