Following is a list of tasks that can be performed using Excel in a Windows environment. Match each task with the correct description from the column on the right. Task Description of how to do the task in Excel (Windows) 1. 2. 3. 4. Change the order of the worksheets in the workbook Copy and paste the contents of one cell to another cell Copy the contents of a cell to a range of cell Go to the end of the data set in a worksheet Move between worksheets Refer to a cell as an absolute reference Rename worksheet Select a range of cells 5. 6. 7. 8. 9. Select all data in a worksheet 10. Select one cell a. Drag the fill handle down the column or across the row. b. Click on the first cell in a range and drag your cursor to the final cell you are selecting. c. Drag and drop worksheet to desired location. d. Put dollar signs in front of both the column and row reference in the formula. e. Hold down the Ctrl and A keys simultaneously. f. Click on a cell. g. Hold down the Ctrl and End keys simultaneously. h. Right click worksheet tab and select option to give the worksheet a new name. i. Click on a worksheet tab. j. In the first cell, hold down Ctrl + C, then navigate to the desired cell and hold down Ctrl + V