FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The most efficient way to format several cells with a specific font, number format, alignment, font color would be to:
A
Use Format Painter
B
Format each element using the Toolbar
C
Select all and use the Formatting dialog box
D
Apply a table style
Explanation: 

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

There is 1 question to complete.