Duplication | MCQs

Explanation

To duplicate values in a cell range in Excel 2016, follow these steps:

• Select the range of cells that you want to duplicate.
• Go to the Home tab in the ribbon.
• Click on the "Fill" handle (the small square at the bottom-right corner of the selection) and drag it down to the range where you want to duplicate the values.
• Alternatively, you can right-click on the selection and choose "Copy" (or press Ctrl+C), then select the range where you want to duplicate the values and right-click and choose "Paste" (or press Ctrl+V).