Having completed the fourth 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:

Task

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

Click the Show Formulas button in the Formulas tab on the Ribbon. Or press Ctrl + `.
Select C22. Type =IF(G8>=H8, "Target Met", "Target Not Met"). Click and drag to C28.
Select C34. Type =IF(C22="Target Met", "20%", "0%"). Click and drag to C40.
Type =IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%")))) into cell D34. Click and drag to F40.
Type =AND(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Type =OR(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Select G34. Type =IF(OR(C22="Target Met", G22>95), "20%", "0%"). Click and drag to F40.
Select C22. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents.
Select C22. Click on Trace Dependents on the Formulas tab.
Select C22. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate.
Click on Watch Window in the Formulas tab. Select H34 to H40. Click Add Watch.
Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Task

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

Click the Show Formulas button in the Formulas tab on the Ribbon. Or press Ctrl + `.
Select C22. Type =IF(G8>=H8, "Target Met", "Target Not Met"). Click and drag to C28.
Select C34. Type =IF(C22="Target Met", "20%", "0%"). Click and drag to C40.
Type =IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%")))) into cell D34. Click and drag to F40.
Type =AND(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Type =OR(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Select G34. Type =IF(OR(C22="Target Met", G22>95), "20%", "0%"). Click and drag to F40.
Select C22. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents.
Select C22. Click on Trace Dependents on the Formulas tab.
Select C22. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate.
Click on Watch Window in the Formulas tab. Select H34 to H40. Click Add Watch.
Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Mark tasks as Completed

Everything was clear?

Section 4. Chapter 7

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 fourth 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:

Task

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

Click the Show Formulas button in the Formulas tab on the Ribbon. Or press Ctrl + `.
Select C22. Type =IF(G8>=H8, "Target Met", "Target Not Met"). Click and drag to C28.
Select C34. Type =IF(C22="Target Met", "20%", "0%"). Click and drag to C40.
Type =IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%")))) into cell D34. Click and drag to F40.
Type =AND(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Type =OR(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Select G34. Type =IF(OR(C22="Target Met", G22>95), "20%", "0%"). Click and drag to F40.
Select C22. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents.
Select C22. Click on Trace Dependents on the Formulas tab.
Select C22. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate.
Click on Watch Window in the Formulas tab. Select H34 to H40. Click Add Watch.
Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Task

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

Click the Show Formulas button in the Formulas tab on the Ribbon. Or press Ctrl + `.
Select C22. Type =IF(G8>=H8, "Target Met", "Target Not Met"). Click and drag to C28.
Select C34. Type =IF(C22="Target Met", "20%", "0%"). Click and drag to C40.
Type =IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%")))) into cell D34. Click and drag to F40.
Type =AND(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Type =OR(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Select G34. Type =IF(OR(C22="Target Met", G22>95), "20%", "0%"). Click and drag to F40.
Select C22. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents.
Select C22. Click on Trace Dependents on the Formulas tab.
Select C22. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate.
Click on Watch Window in the Formulas tab. Select H34 to H40. Click Add Watch.
Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Mark tasks as Completed

Everything was clear?

Section 4. Chapter 7

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 fourth 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:

Task

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

Click the Show Formulas button in the Formulas tab on the Ribbon. Or press Ctrl + `.
Select C22. Type =IF(G8>=H8, "Target Met", "Target Not Met"). Click and drag to C28.
Select C34. Type =IF(C22="Target Met", "20%", "0%"). Click and drag to C40.
Type =IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%")))) into cell D34. Click and drag to F40.
Type =AND(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Type =OR(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Select G34. Type =IF(OR(C22="Target Met", G22>95), "20%", "0%"). Click and drag to F40.
Select C22. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents.
Select C22. Click on Trace Dependents on the Formulas tab.
Select C22. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate.
Click on Watch Window in the Formulas tab. Select H34 to H40. Click Add Watch.
Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Task

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

Click the Show Formulas button in the Formulas tab on the Ribbon. Or press Ctrl + `.
Select C22. Type =IF(G8>=H8, "Target Met", "Target Not Met"). Click and drag to C28.
Select C34. Type =IF(C22="Target Met", "20%", "0%"). Click and drag to C40.
Type =IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%")))) into cell D34. Click and drag to F40.
Type =AND(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Type =OR(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Select G34. Type =IF(OR(C22="Target Met", G22>95), "20%", "0%"). Click and drag to F40.
Select C22. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents.
Select C22. Click on Trace Dependents on the Formulas tab.
Select C22. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate.
Click on Watch Window in the Formulas tab. Select H34 to H40. Click Add Watch.
Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Everything was clear?

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 fourth 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:

Task

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

Click the Show Formulas button in the Formulas tab on the Ribbon. Or press Ctrl + `.
Select C22. Type =IF(G8>=H8, "Target Met", "Target Not Met"). Click and drag to C28.
Select C34. Type =IF(C22="Target Met", "20%", "0%"). Click and drag to C40.
Type =IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%")))) into cell D34. Click and drag to F40.
Type =AND(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Type =OR(C22="Target Met", G22>95) into cell H22. Click and drag to H28.
Select G34. Type =IF(OR(C22="Target Met", G22>95), "20%", "0%"). Click and drag to F40.
Select C22. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents.
Select C22. Click on Trace Dependents on the Formulas tab.
Select C22. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate.
Click on Watch Window in the Formulas tab. Select H34 to H40. Click Add Watch.
Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Section 4. Chapter 7

Switch to desktop for real-world practiceContinue from where you are using one of the options below