USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The word Jan was entered in cell A1, Apr was entered in cell B1, and you then used AutoFill to automatically fill cells C1 and D1. What would cell D1 contain?
|
|
Oct
|
|
|
May
|
|
|
Jun
|
|
|
Jul
|
Explanation:
Detailed explanation-1: -If your workbook is already open, then you can go to File > Save As to save the workbook with a different name. This will create a copy of the existing workbook.
Detailed explanation-2: -Which sequence will add 5 to each number in cells A1, A2, and A3? Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+Alt+V, select Add, and then select OK.
Detailed explanation-3: -Enter a formula in cell E2 to calculate the absolute value of C2-D2. You typed in cell E2, clicked cell E2, clicked the E2 Cell Input, typed =ABS in cell E2, clicked the =ABS(C2-D2 view, double-clicked ABS in the Formula AutoComplete list, typed =ABS(C2-D2 in cell E2, and pressed Enter.
There is 1 question to complete.