FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following Option buttons gives options for filling cells following a fill operation?
A
Auto Fill Options
B
AutoCorrect Options
C
Insert Options
D
Paste Options
Explanation: 

Detailed explanation-1: -Fill formulas into adjacent cells You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left.

Detailed explanation-2: -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.

Detailed explanation-3: -What is AutoFill? Excel has a feature that helps you automatically enter data. If you are entering a predictable series (e.g. 1, 2, 3…; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence.

There is 1 question to complete.
Previous
Next