Project 1

1.       Color “Sam” sheet tab to Green, Accent 6.

2.       Unhide “Cong Academy” worksheet so that it will be displayed between “Data” worksheet and “Sam” worksheet.

3.       On the “Data” worksheet, use an automatic formatting method to format the cells in the “ĐIỂM TOÁN” column that contain values greater than 9 by applying Light Red Fill. Use a technique that automatically updates the formatting if the values change.

4.       On the “Data" worksheet, delete “KHU VỰC” column without changing cell ranges above and below it.

5.       On the “Data” worksheet, configure cell range A15:D19 so that data entries that are wider than column width will be wrapped to multiple lines.

6.       Configure column width of all cells in the table on the “Sam” worksheet will be fit its contents.

7.       Copy only value from cell range M1:M10 in the “Sam” worksheet to C3:C12 in the “Data” worksheet.