Question

Which of the following option can be used to if copy the cell formatting from one cell to another Format painter Format setting Format showing Format checking

Answer 1

Answer:

by following steps

Select the cell with the formatting you want to copy.

On the Home tab, in the Clipboard group, click the Format Painter button. The pointer will change to a paint brush.

Move to the cell where you want to apply the formatting and click on it.

Answer 2

Answer:

Hlo mate

Bhul gaye pihu ????

Explanation:

OPTION A : Format Painter .

The Format Painter enables us to copy the format from the selected cell or range of cells . The option is available on the Clip Board .

MS Excel 2010 contains 7 default tabs namely :

Home tab .

Insert tab .

Page layout tab .

Formulas tab .

Data tab .

View tab .

Review tab .

The Clip Board option is present in the Home Tab .

There are 4 options in the Clip Board box :

Cut .

Copy .

Paste .

Format painter .

Right click on the format painter in order to copy the format .

The same type of format can be applied to multiple places in the document .