Question

Which of the following options allows you to copy formatting attributes and styles from one cell to another cell or group of cells?
a. fill handle
b. format painter
c. paste special
d. format cells

Answer 1

Answer:

b. format painter

Explanation:

Format painter is an option that is available on the home tab and it allows copying the formatting present in one to another single cell or a group of cells.

The formatting options can include font style, the color of the text, the border style.

To use the format painter some simple steps needs to be followed:

1. Click on the Format painter tab on the home tab.

2. Clicking on the format painter will help to copy the format of the selected cell.

3. The copied formatting can be applied to other cells of interest by clicking and dragging over the cells where a similar formatting is required.

4. The ESC buttton can be pressed to stop formatting .