Answered step by step
Verified Expert Solution
Link Copied!

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 1
Task
Description of how to do the task in Excel (Windows)
1.
Change the order of the worksheets in the workbook
c. Drag and drop worksheet to desired location.
2.
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.
3.
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.
4.
Go to the end of the data set in a worksheet
g. Hold down the Ctrl and End keys simultaneously.
5.
Move between worksheets
i. Click on a worksheet tab.
6.
Refer to a cell as an absolute reference
d. Put dollar signs in front of both the column and row reference in the formula.
7.
Rename worksheet
h. Right click worksheet tab and select option to give the worksheet a new name.
8.
Select a range of cells
a. Drag the fill handle down the column or across the row.
9.
Select all data in a worksheet
e. Hold down the Ctrl and A keys simultaneously.
10.
Select one cell

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Automating Access Databases With Macros

Authors: Fish Davis

1st Edition

1797816349, 978-1797816340

More Books

Students also viewed these Databases questions