Project 2

1.       On the “Data” worksheet, configure columns B and C so that they are present but not visible.

2.       Remove color of “Orders” sheet tab.

3.       On the “Data” worksheet, use Find and Replace feature to replace all instances of “German” with “Vietnam” of “Code” column.

4.       On the “tinhoccong” worksheet, format value of “Actual Finish” column to be shown as “Vietnamese” date type “14 Tháng Ba 2012”. Configure the width of this column will be adjusted automatically to fit contents of data.

5.       Navigate to cell range I2:J20 in the “Data” worksheet and clear its format.

6.       Make a copy of the “tinhoccong” worksheet and rename this copied sheet “New Data”.

7.       On the “Orders” worksheet, apply cell style “Heading 1” to cell range A1:I1.