Create a new blank workbook.

a$.$ Save the new workbook as ExclusivesFall$2024.$

b$.$ Add the following tags to the file$$s properties: Sydney, Glace Bay, and North

Sydney.

c$.$ Add a tag to the Category property called Demand.

d$.$ Create a custom property called NewProduct, leave the value of the Type field as

Text, and assign the new property the value Cities.

e$.$ Save your work.

Question $2$: Modify workbooks $($Mark $5)$

Open the ModifyWorkbooks $($attached in the Moodle$)$ workbook in Excel, and then perform the

following tasks:

a$.$ Create a new worksheet name Fall$2024.$

b$.$ Rename the Sheet$1$ worksheet to Fall$2023$ and change its tab color to Yellow.

c$.$ Delete the City$2023$ worksheet.

d$.$ Copy the Fall$2023$ worksheet to the workbook ExclusivesFall$2024$ created in

Question $1.$

e$.$ In the ModifyWorkbooks workbook, hide the Fall$2023$ worksheet.

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 New Location worksheet, insert new columns A and B; and new rows $1$ and

$2.$

b$.$ After inserting two new columns and rows, select Column I, then click the Tab Home,

then go to the Group Editing, and then click Clear Format.

c$.$ Hide column H$.$

d$.$ On the New Location$2$ worksheet, delete cell B$7,$ shifting the remaining cells up$.$

e$.$ Click cell C$6,$ and then insert a cell, shifting the other cells down. Enter the value

$1200$ in the new cell C$6.$

f$.$ Select cells E$13$:F$13($Colon sign $($:$)$ used in excel to to include all cells between the

two endpoint cell references. So$,$ here it means cells from E$13$ to F$13)$ and move

them to cells B$15$:C$15.$

Question $4$: Merge and unmerge cells $($Mark $3)$

Open the MergeCells $($attached in the Moodle$)$ workbook in Excel, and then perform the

following tasks:

a$.$ Merge cells C$3$:D$3.$ Is it a right choice to merge C$3$:D$3$ instead of C$3$:E$3$ here?

b$.$ Merge and center cells C$3$:F$3.$

c$.$ Merge the cell range C$6$:F$9$ by using Merge Across.

d$.$ Unmerge cell C$11.$

Question $5$: Customize the Excel $2019$ app window $($Mark $5)$

Open the CustomizeRibbonTabs $($attached in the Moodle$)$ workbook in Excel, and then

perform the following tasks:

a$.$ Add the Spelling button to the Quick Access Toolbar.

b$.$ Move the Review ribbon tab so it is positioned between the Insert and Page Layout

tabs$.$

c$.$ Create a new ribbon tab named Capstone Class.

d$.$ Rename the New Group $($Custom$)$ group to Formatting.

e$.$ From the buttons on the Home tab, add the Styles group to the Capstone Class ribbon

tab you created earlier

f$.$ Save your ribbon changes and click the Capstone Class tab on the ribbon.