Question: Question 3 : Modify worksheets ( Mark 5 ) Open the ModifyWorksheets ( attached in the Moodle ) workbook in Excel, and then perform the

Question 3: Modify worksheets (Mark 5)
Open the ModifyWorksheets (attached in the Moodle) workbook in Excel, and then perform the following tasks:
a. On the Local worksheet, insert a new column A and a new row 1.
b. After you insert the new row 2, click the Tab Home, then go to the Group Editing, and then click Clear Format.
c. Hide column E.
d. On the NewLocal worksheet, delete cell B6, shifting the remaining cells up.
e. Click cell C6, and then insert a cell, shifting the other cells down. Enter the value 5599 in the new cell C6.
f. Select cells E13:F13(Colon sign ( used in excel to to include all cells between the two endpoint cell references. So, here it means cells from EI3 to F13) and move them to cells B13:C13.
 Question 3: Modify worksheets (Mark 5) Open the ModifyWorksheets (attached in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!