USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
For which of the following tasks would you use the fill handle?
|
|
to apply shading
|
|
|
to apply a border
|
|
|
to copy a formula from cell A2 to cell A3
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -’Fill Handle’ is a tool that you can use to autocomplete lists in Excel. For example, if you have to enter numbers 1 to 20 in cell A1:A20, instead of manually entering each number, you can simply enter the first two numbers and use the fill handle to do the rest.
Detailed explanation-2: -The FORMULATEXT function returns a text string that shows the formula in a worksheet cell.
Detailed explanation-3: -Select the cell that contains the formula you want to copy. Hover your cursor around the black square in the lower right corner of the cell until your cursor turns into a plus sign. Click and hold the left mouse button while dragging the handle to include all cellswhere you would like the formula copied.
There is 1 question to complete.