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]
A tool that enables you to copy formatting from a cell and apply it to another cell or range.
A
autoformat
B
format painter
C
format macro
D
format copy
Explanation: 

Detailed explanation-1: -Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. 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.

Detailed explanation-2: -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. To use the Format Painter tool: 1. Select the text that has the formatting you want to copy.

Detailed explanation-3: -Click in text that has the formatting to replicate, and press CTRL-SHIFT-C. It’ll copy the formatting, but not the text itself. Highlight the target text and press CTRL-SHIFT-V to paste the formatting.

There is 1 question to complete.