FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
A
Copy Cells
B
Fill Formatting Only
C
Fill Without Formatting
D
none of the above
Explanation: 

Detailed explanation-1: -The Fill series option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area. The Fill Formatting Only option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

Detailed explanation-2: -AutoFill Formatting Move your cursor to the corner until you see the Fill Handle. This time hold your right mouse button and drag through the cells where you want to apply the formatting. Release the button and you’ll see a shortcut menu appear. Choose Fill Formatting Only.

Detailed explanation-3: -Put the mouse pointer over the bottom right-hand corner of the cell until it’s a black plus sign. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.

There is 1 question to complete.