USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -In Excel or Word, if you double click the Format Painter button, it will stay until you click it again or until you press the Esc key. This allows applying Format Painter to several areas consecutively.
Detailed explanation-2: -The Format Painter button copies the formatting from an item and applies it to a different item or group of items that you select. To use the Format Painter to copy the formatting to multiple selections, follow these steps: Click to select the item that has the formatting that you want to copy.
Detailed explanation-3: -Double-click the Format Painter if you want to copy the formatting to several non-adjacent cells. When you use this method, you can paste the formatting to as many cells as you want, and the Format Painter will stay on. When you’re done, you’ll need to click the Format Painter again to turn it off.
Detailed explanation-4: -The correct answer is option 3. We can use the format painter multiple times before we turn it off by double-clicking the format painter button.
Detailed explanation-5: -Double click on the Format Painter button to lock it. Once it is locked, you can apply the copied formatting to as many separate ranges of cells as you want.