Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Question content area bottom
Part
Task
Description of how to do the task in Excel Windows
Change the order of the worksheets in the workbook
c Drag and drop worksheet to desired location.
Copy and paste the contents of one cell to another cell
b Click on the first cell in a range and drag your cursor to the final cell you are selecting.
Copy the contents of a cell to a range of cell
j In the first cell, hold down Ctrl C then navigate to the desired cell and hold down Ctrl V
Go to the end of the data set in a worksheet
g Hold down the Ctrl and End keys simultaneously.
Move between worksheets
i Click on a worksheet tab.
Refer to a cell as an absolute reference
d Put dollar signs in front of both the column and row reference in the formula.
Rename worksheet
h Right click worksheet tab and select option to give the worksheet a new name.
Select a range of cells
a Drag the fill handle down the column or across the row.
Select all data in a worksheet
e Hold down the Ctrl and A keys simultaneously.
Select one cell
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started