Page 90 - Computer - 6

 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
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 default alignment of text data in a cell is ______.
(a) Right (b) Left (c) Centre (d) Justify

4. Which of the following data entry in Excel is a formula?

(a) Average(Cells) (b) Sum(Above) (c) = A2 + B2 + C2 (d) @Max(A3:D3)

5. 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

6. 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

7. By default, the orientation of the cell contents in Excel is ______.
(a) Slanting (b) Horizontal (c) Vertical (d) Straight

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. A user-defined list that can be used with AutoFill feature is called a _____________ list.

4. A _____________ is an equation that lets you perform calculations on data in a worksheet.

5. The _____________ command is available only after you have cancelled an action.

6. ________________ refers to the placement of cell contents within the boundary of a cell.

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

88