Having completed the seventh section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier.

If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Завдання

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Click the plus icon (+) at the bottom of the workbook to add a new worksheet.
Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
Right-click the worksheet tab and select Delete to remove the worksheet.
Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.
Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
Double-click the Format Painter button to apply formatting to multiple cells or ranges.
Press Esc to deactivate the Format Painter.
Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.
Right-click column H and select Insert.
Right-click G6, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button.
Right-click column H and select Delete.
Right-click G6, select Delete, and choose Entire Row.
Select columns H & I and right-click and choose Hide.
Select a row header and right-click to choose Hide.
Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
Select row 6 and go to the View tab and click Freeze Panes.

Завдання

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Click the plus icon (+) at the bottom of the workbook to add a new worksheet.
Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
Right-click the worksheet tab and select Delete to remove the worksheet.
Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.
Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
Double-click the Format Painter button to apply formatting to multiple cells or ranges.
Press Esc to deactivate the Format Painter.
Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.
Right-click column H and select Insert.
Right-click G6, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button.
Right-click column H and select Delete.
Right-click G6, select Delete, and choose Entire Row.
Select columns H & I and right-click and choose Hide.
Select a row header and right-click to choose Hide.
Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
Select row 6 and go to the View tab and click Freeze Panes.

Mark tasks as Completed

Все було зрозуміло?

Секція 7. Розділ 10

Choose your plan

Challenge

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note
If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the seventh section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier.

If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Завдання

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Click the plus icon (+) at the bottom of the workbook to add a new worksheet.
Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
Right-click the worksheet tab and select Delete to remove the worksheet.
Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.
Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
Double-click the Format Painter button to apply formatting to multiple cells or ranges.
Press Esc to deactivate the Format Painter.
Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.
Right-click column H and select Insert.
Right-click G6, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button.
Right-click column H and select Delete.
Right-click G6, select Delete, and choose Entire Row.
Select columns H & I and right-click and choose Hide.
Select a row header and right-click to choose Hide.
Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
Select row 6 and go to the View tab and click Freeze Panes.

Завдання

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Click the plus icon (+) at the bottom of the workbook to add a new worksheet.
Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
Right-click the worksheet tab and select Delete to remove the worksheet.
Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.
Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
Double-click the Format Painter button to apply formatting to multiple cells or ranges.
Press Esc to deactivate the Format Painter.
Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.
Right-click column H and select Insert.
Right-click G6, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button.
Right-click column H and select Delete.
Right-click G6, select Delete, and choose Entire Row.
Select columns H & I and right-click and choose Hide.
Select a row header and right-click to choose Hide.
Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
Select row 6 and go to the View tab and click Freeze Panes.

Mark tasks as Completed

Все було зрозуміло?

Секція 7. Розділ 10

Choose your plan

Challenge

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note
If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the seventh section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier.

If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Завдання

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Click the plus icon (+) at the bottom of the workbook to add a new worksheet.
Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
Right-click the worksheet tab and select Delete to remove the worksheet.
Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.
Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
Double-click the Format Painter button to apply formatting to multiple cells or ranges.
Press Esc to deactivate the Format Painter.
Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.
Right-click column H and select Insert.
Right-click G6, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button.
Right-click column H and select Delete.
Right-click G6, select Delete, and choose Entire Row.
Select columns H & I and right-click and choose Hide.
Select a row header and right-click to choose Hide.
Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
Select row 6 and go to the View tab and click Freeze Panes.

Завдання

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Click the plus icon (+) at the bottom of the workbook to add a new worksheet.
Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
Right-click the worksheet tab and select Delete to remove the worksheet.
Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.
Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
Double-click the Format Painter button to apply formatting to multiple cells or ranges.
Press Esc to deactivate the Format Painter.
Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.
Right-click column H and select Insert.
Right-click G6, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button.
Right-click column H and select Delete.
Right-click G6, select Delete, and choose Entire Row.
Select columns H & I and right-click and choose Hide.
Select a row header and right-click to choose Hide.
Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
Select row 6 and go to the View tab and click Freeze Panes.

Все було зрозуміло?

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note
If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the seventh section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier.

If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Завдання

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Click the plus icon (+) at the bottom of the workbook to add a new worksheet.
Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
Right-click the worksheet tab and select Delete to remove the worksheet.
Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.
Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
Double-click the Format Painter button to apply formatting to multiple cells or ranges.
Press Esc to deactivate the Format Painter.
Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.
Right-click column H and select Insert.
Right-click G6, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button.
Right-click column H and select Delete.
Right-click G6, select Delete, and choose Entire Row.
Select columns H & I and right-click and choose Hide.
Select a row header and right-click to choose Hide.
Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
Select row 6 and go to the View tab and click Freeze Panes.

Секція 7. Розділ 10

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів