FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which button allows you to copy cell formats from one cell to another?
A
Enter
B
Autofit
C
Format Painter
D
Esc
Explanation: 

Detailed explanation-1: -Select the cell with the formatting you want to copy. Select Home > Format Painter. Drag to select the cell or range you want to apply the formatting to. Release the mouse button and the formatting should now be applied.

Detailed explanation-2: -With format painter, you can copy all of the formatting from one object and apply it to another one-think of it as copying and pasting for formatting. Select the text or graphic that has the formatting that you want to copy. Note: If you want to copy text formatting, select a portion of a paragraph.

Detailed explanation-3: -The Format Painter tool is used to copy and paste character and paragraph formats to existing text. This tool, used in conjunction with styles, can make organizing and reformatting documents easier and more efficient.

Detailed explanation-4: -On the Standard toolbar, double-click the Format Painter button. Then, click to select each item, or region select the items to which you want to apply the formatting. NOTE: Click the Format Painter button again when you are finished, or press ESC to turn off the Format Painter.

There is 1 question to complete.