Activity Excel Part 1 set up workbook

Exercise 1 : Create workbooks

Open the Create Workbooks workbook in Excel, and then perform the following tasks:

1. Close the Create Workbooks file, and then create a new, blank workbook.

2. Save the new workbook as Exceptions2015.

3. Add the following tags to the files properties: exceptions, regional, and percentage

4. Add a tag to the Category property called performance.

5. Create a custom property called Performance, leave the value of the Type field

as Text, and assign the new property the value Exceptions.

6. Save your work.

Exercice 2 : Modify workbooks

Open the Modify Workbooks workbook in Excel, and then perform the following tasks:

1. Create a new worksheet named 2016.

2. Rename the Sheet1 worksheet to 2015 and change its tab color to green.

3. Delete the Scratch Pad worksheet.

4. Copy the 2015 worksheet to a new workbook, and then save the new workbook under the name Archive2015.

5. In the Modify Workbooks, workbook, hide the 2015 worksheet.

Exercice 3 : Modify worksheets Open the Modify Worksheets workbook in Excel, and then perform the following tasks:

1. On the May 12 worksheet, insert a new column A and a new row 1.

2. After you insert the new row 1, click the Insert Options action button, and then click Clear Formatting.

3. Hide column E.

4. On the May 13 worksheet, delete cell B6, shifting the remaining cells up.

5. Click cell C6, and then insert a cell, shifting the other cells down. Enter the value 4499 in the new cell C6.

6. Select cells E13:F13 and move them to cells B13:C13.

Exercise 4 : Merge and unmerge cells Open the Merge Cells workbook in Excel, and then perform the following tasks:

1. Merge cells B2:D2.

2. Merge and center cells B3:F3.

3. Merge the cell range B5:E8 by using Merge Across.

4. Unmerge cell B2.