Having completed the third 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 on F8. Type =E8*C17. Press Enter.
Click on G8. Type =(E8+F8)*D8.
Click on G8 and drag down the fill handle to G14.
Click on F8. Add dollar signs before the C and before 17. Press Enter. Drag fill handle to F14.
Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
Select C31, C32 and C33. Click and drag fill handle to column G.
Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
Select F29. Click the AutoSum button (Σ) button. Press Enter.
Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Select G29. Click Fx. Select SUM function, click OK.
Select from C22 to C28. Click on Number 2.
Select D22 to D28. Click on Number 3.
Select E22 to E28. Click Number 4.
Select F22 to F28. Click ΟΚ.

Завдання

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

Click on F8. Type =E8*C17. Press Enter.
Click on G8. Type =(E8+F8)*D8.
Click on G8 and drag down the fill handle to G14.
Click on F8. Add dollar signs before the C and before 17. Press Enter. Drag fill handle to F14.
Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
Select C31, C32 and C33. Click and drag fill handle to column G.
Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
Select F29. Click the AutoSum button (Σ) button. Press Enter.
Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Select G29. Click Fx. Select SUM function, click OK.
Select from C22 to C28. Click on Number 2.
Select D22 to D28. Click on Number 3.
Select E22 to E28. Click Number 4.
Select F22 to F28. Click ΟΚ.

Mark tasks as Completed

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

Секція 3. Розділ 6

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 third 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 on F8. Type =E8*C17. Press Enter.
Click on G8. Type =(E8+F8)*D8.
Click on G8 and drag down the fill handle to G14.
Click on F8. Add dollar signs before the C and before 17. Press Enter. Drag fill handle to F14.
Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
Select C31, C32 and C33. Click and drag fill handle to column G.
Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
Select F29. Click the AutoSum button (Σ) button. Press Enter.
Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Select G29. Click Fx. Select SUM function, click OK.
Select from C22 to C28. Click on Number 2.
Select D22 to D28. Click on Number 3.
Select E22 to E28. Click Number 4.
Select F22 to F28. Click ΟΚ.

Завдання

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

Click on F8. Type =E8*C17. Press Enter.
Click on G8. Type =(E8+F8)*D8.
Click on G8 and drag down the fill handle to G14.
Click on F8. Add dollar signs before the C and before 17. Press Enter. Drag fill handle to F14.
Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
Select C31, C32 and C33. Click and drag fill handle to column G.
Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
Select F29. Click the AutoSum button (Σ) button. Press Enter.
Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Select G29. Click Fx. Select SUM function, click OK.
Select from C22 to C28. Click on Number 2.
Select D22 to D28. Click on Number 3.
Select E22 to E28. Click Number 4.
Select F22 to F28. Click ΟΚ.

Mark tasks as Completed

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

Секція 3. Розділ 6

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 third 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 on F8. Type =E8*C17. Press Enter.
Click on G8. Type =(E8+F8)*D8.
Click on G8 and drag down the fill handle to G14.
Click on F8. Add dollar signs before the C and before 17. Press Enter. Drag fill handle to F14.
Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
Select C31, C32 and C33. Click and drag fill handle to column G.
Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
Select F29. Click the AutoSum button (Σ) button. Press Enter.
Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Select G29. Click Fx. Select SUM function, click OK.
Select from C22 to C28. Click on Number 2.
Select D22 to D28. Click on Number 3.
Select E22 to E28. Click Number 4.
Select F22 to F28. Click ΟΚ.

Завдання

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

Click on F8. Type =E8*C17. Press Enter.
Click on G8. Type =(E8+F8)*D8.
Click on G8 and drag down the fill handle to G14.
Click on F8. Add dollar signs before the C and before 17. Press Enter. Drag fill handle to F14.
Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
Select C31, C32 and C33. Click and drag fill handle to column G.
Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
Select F29. Click the AutoSum button (Σ) button. Press Enter.
Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Select G29. Click Fx. Select SUM function, click OK.
Select from C22 to C28. Click on Number 2.
Select D22 to D28. Click on Number 3.
Select E22 to E28. Click Number 4.
Select F22 to F28. Click ΟΚ.

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

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 third 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 on F8. Type =E8*C17. Press Enter.
Click on G8. Type =(E8+F8)*D8.
Click on G8 and drag down the fill handle to G14.
Click on F8. Add dollar signs before the C and before 17. Press Enter. Drag fill handle to F14.
Click on F15. Type in =SUM. Double-click SUM function in menu. Select F8 to F14. Press Enter.
Click on G15. Type in =SUM. Double-click SUM function in the menu. Select G8 to G14 individually. Press Enter.
Click on C31. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28. Press Enter.
Click on C32. Type =MAX. Double-click MAX function in menu. Select C22 to C28. Press Enter.
Click on C33. Type =MIN. Double-click MIN function in menu. Select C22 to C28. Press Enter.
Select C31, C32 and C33. Click and drag fill handle to column G.
Select D15. Type =COUNT. Double-click COUNT function in menu. Select D8 to D14. Press Enter.
Select F29. Click the AutoSum button (Σ) button. Press Enter.
Click on C34. Type =AVE. Double-click AVERAGE function in menu. Select C22 to C28 then type =MIN Double click MIN function and select C22 to C28. Press Enter.
Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Select G29. Click Fx. Select SUM function, click OK.
Select from C22 to C28. Click on Number 2.
Select D22 to D28. Click on Number 3.
Select E22 to E28. Click Number 4.
Select F22 to F28. Click ΟΚ.

Секція 3. Розділ 6

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