USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The ability to quickly add a formula, set of number, months or day of the week down a column or across a row.
|
Autofill
|
|
Copy and Paste
|
|
Drag and Drop
|
|
Typing
|
Explanation:
Detailed explanation-1: -Keyboard shortcut: You can also press Ctrl+D to fill the formula down a cell in a column, or Ctrl+R to fill the formula to the right in a row.
Detailed explanation-2: -You can use the EDATE function to quickly add or subtract months from a date. The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument. For example, =EDATE("9/15/19", -5) returns 4/15/19.
There is 1 question to complete.