DAY 1.

3
Open document named Olympic.xlsx in the Documents Folder

TAB FILE
☐ Task 1 Check the accessiiblity of the workbook and add altternative title for the picture
Check spreadsheet for accessibility. Correct the error in Picture 4 by adding “Olympic” alternative title.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................

☐ Task 2 Check the accessiiblity of the workbook and unmerge cells

Check that the spreadsheet for accessibility problems. Correct the error of merged cells on Sheet1 worksheet by unmerging
cells. You don’t need to fix the other warnings.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................

☐ Task 3 Property Subject

Add the Subject Olympic to the document properties.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................

☐ Task 4 Property Title

Add the word MOS as the document title property of the document.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................

Worksheet, Workbook

☐ Task 1 Add a new worksheet

Add a new worksheet named “New Record” to the workbook.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................
 ☐ Task 2 Add a new worksheet
Add a new worksheet named “New Sheet” to the workbook.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................

☐ Task 3 Copy a worksheet

Copy only the Olympic worksheet into a new workbook. Save it in the Document folder as Olympic1.xlsx. Close the new
workbook before proceeding.
...........................................................................................................................................................................................................................................................................................................
...........................................................................................................................................................................................................................................................................................................

☐ Task 4 Copy a worksheet

Copy only the Sheet1 worksheet into a new workbook. Save it in the Document folder as theYOUNG.xlsx. Close the new
workbook before proceeding.
...........................................................................................................................................................................................................................................................................................................
...........................................................................................................................................................................................................................................................................................................

☐ Task 5 Hide worksheet

Score worksheet is not displayed .
..........................................................................................................................................................................................................................................................................................................
...........................................................................................................................................................................................................................................................................................................

☐ Task 6 Unhide worksheet

Unhide the Section 1 worksheet.
...........................................................................................................................................................................................................................................................................................................
...........................................................................................................................................................................................................................................................................................................

TAB HOME

☐ Task 1 Hide rows

In the Swimming worksheet, hide rows 10 and 12.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................
 ☐ Task 2 Hide rows
In Math worksheet, customize row 10 so that it is still present but invisible.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................

☐ Task 3 Wrap text

Modify the cell formatting of cell D6 of Math worksheet to display the text on two lines.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................

☐ Task 4 Wrap text

Modify the cell formatting of cell A6 of Math worksheet to display the text on two lines.
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................

Open document named FishingSupplies.xlsx in the Documents Folder

☐ Task 1 Insert column

In the Carriers and Coolers worksheet, add a column named Details to the right of the Description column.
...........................................................................................................................................................................................................................................................................................................
...........................................................................................................................................................................................................................................................................................................

☐ Task 2 Insert column

In the Tackle worksheet, add a column named Average to the right of the Price column
......................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................

☐ Task 3 Change height row

On the Carriers and Coolers worksheet, change the height of rows 1 and 2 to “30”.

...........................................................................................................................................................................................................................................................................................................
......................................................................................................................................................................................................................................................
 ☐ Task 4 Change height row
On the Tackle worksheet, change the height of rows 3 and 4 to “35”.

...........................................................................................................................................................................................................................................................................................................
...........................................................................................................................................................................................................................................................................................................