Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 3 : Modify worksheets ( Mark 5 ) Open the ModifyWorksheets ( attached in the Moodle ) workbook in Excel, and then perform the
Question : Modify worksheets Mark
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
b After you insert the new row click the Tab Home, then go to the Group Editing, and then click Clear Format.
c Hide column
d On the NewLocal worksheet, delete cell B shifting the remaining cells up
e Click cell C and then insert a cell, shifting the other cells down. Enter the value in the new cell
f Select cells E:FColon sign used in excel to to include all cells between the two endpoint cell references. So here it means cells from EI to F and move them to cells B:C
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