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]
The fill handle only allows you to copy formulas to several different cells.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The fill handle only allows you to copy formulas to several different cells. Any changes made to an Excel document can be tracked in a separate worksheet. The Subtotals command adds numbers in a designated column. Sparklines are tiny charts that fit into one cell.

Detailed explanation-2: -You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.

Detailed explanation-3: -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-4: -In Microsoft Excel, a fill handle is a feature to extend (and fill) several numbers, dates, or even text to other cells. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom-right corner, as shown in the image.

There is 1 question to complete.