DAY $6$ JOB $2$

$(20$ marks$)$

In addition to the first program, Culturally Ours is offering programs for students interested in an international intemship or academic credit. A workbook was prepared with raw data related to the Global Insight program. Please edil and format it according to the instructions below.

Open Culturally Ours from the Data files in the LMS

Delete Placement column on Sheet $1$ and all blank rows

Create a centered Header $-$ August and September Departures

Create a footer $-$ P'repared by Adininistrator in the right Footer; format current date in the left and Page numbers in the center footer

Change the Sheet$1$ Tah color to Olive Green, Accent $3$ Darker $25\%$;Shcet $2$ tab to Dark Blue, Text $2,$ Lighter $40\%$

Format column E on Sheet I to display as month day year $($Le$,$ June $20,13)$ and adjust to fit

Format columns B and C on Sheet $2$ as Currency with no decimals

In the same workbook $-$ Format Sheetl with Wide margins

Break Page $1$ below row $30$ and Page $2$ below row $60$

Page setting Landscape, print gridlines in columns $A-$F and Print the titles $($row $4)$ at the top of all pages

Adjust columns A$,$ C & D $-20$ pt $(145$pixels$),$ B $-12$ pt $(89$ pixels$)$ and F $-10$ pt $(75$ pixels$)$

On SheetI add a Background Bluchills from your sample pictures

Save the workbook as Volunteers V$2$ and put in drop box