Create and apply conditional formatting rules to highlight key data automatically;
Use the Find and Replace tools to swiftly locate and modify data;
Implement advanced search options to narrow down your search results accurately;
Integrate rules with search functions to optimize data analysis.

Tarefa

Select cells J6 to J25. Click on Data Validation. Choose Date, Between, 01/01/2023 and 31/12/2023. Click OK.
Click on Find. Type Household, choose the cell's fill color, and click Find All. Highlight all and change the fill color. Click Find All again. Click on Clear Find Format and Find All again.
Switch to the Replace tab and enter Books in Find What and Paper goods in Replace with. Click Replace All.
Click on Go To, enter D14. Click on Special and select Data Validation.

Tarefa

Select cells J6 to J25. Click on Data Validation. Choose Date, Between, 01/01/2023 and 31/12/2023. Click OK.
Click on Find. Type Household, choose the cell's fill color, and click Find All. Highlight all and change the fill color. Click Find All again. Click on Clear Find Format and Find All again.
Switch to the Replace tab and enter Books in Find What and Paper goods in Replace with. Click Replace All.
Click on Go To, enter D14. Click on Special and select Data Validation.

Mark tasks as Completed

Tudo estava claro?

Seção 5. Capítulo 4

Escolha seu plano

Rules and Search

In this chapter we'll master the use of rules and functions to efficiently manage and locate data in your spreadsheets.

You'll learn how to speed up your data management, making your spreadsheet smart enough to do the heavy lifting for you.

Create and apply conditional formatting rules to highlight key data automatically;
Use the Find and Replace tools to swiftly locate and modify data;
Implement advanced search options to narrow down your search results accurately;
Integrate rules with search functions to optimize data analysis.

Tarefa

Select cells J6 to J25. Click on Data Validation. Choose Date, Between, 01/01/2023 and 31/12/2023. Click OK.
Click on Find. Type Household, choose the cell's fill color, and click Find All. Highlight all and change the fill color. Click Find All again. Click on Clear Find Format and Find All again.
Switch to the Replace tab and enter Books in Find What and Paper goods in Replace with. Click Replace All.
Click on Go To, enter D14. Click on Special and select Data Validation.

Tarefa

Select cells J6 to J25. Click on Data Validation. Choose Date, Between, 01/01/2023 and 31/12/2023. Click OK.
Click on Find. Type Household, choose the cell's fill color, and click Find All. Highlight all and change the fill color. Click Find All again. Click on Clear Find Format and Find All again.
Switch to the Replace tab and enter Books in Find What and Paper goods in Replace with. Click Replace All.
Click on Go To, enter D14. Click on Special and select Data Validation.

Mark tasks as Completed

Tudo estava claro?

Seção 5. Capítulo 4

In this chapter we'll master the use of rules and functions to efficiently manage and locate data in your spreadsheets.

You'll learn how to speed up your data management, making your spreadsheet smart enough to do the heavy lifting for you.

Create and apply conditional formatting rules to highlight key data automatically;
Use the Find and Replace tools to swiftly locate and modify data;
Implement advanced search options to narrow down your search results accurately;
Integrate rules with search functions to optimize data analysis.

Tarefa

Select cells J6 to J25. Click on Data Validation. Choose Date, Between, 01/01/2023 and 31/12/2023. Click OK.
Click on Find. Type Household, choose the cell's fill color, and click Find All. Highlight all and change the fill color. Click Find All again. Click on Clear Find Format and Find All again.
Switch to the Replace tab and enter Books in Find What and Paper goods in Replace with. Click Replace All.
Click on Go To, enter D14. Click on Special and select Data Validation.

Tarefa

Select cells J6 to J25. Click on Data Validation. Choose Date, Between, 01/01/2023 and 31/12/2023. Click OK.
Click on Find. Type Household, choose the cell's fill color, and click Find All. Highlight all and change the fill color. Click Find All again. Click on Clear Find Format and Find All again.
Switch to the Replace tab and enter Books in Find What and Paper goods in Replace with. Click Replace All.
Click on Go To, enter D14. Click on Special and select Data Validation.

Tudo estava claro?

In this chapter we'll master the use of rules and functions to efficiently manage and locate data in your spreadsheets.

You'll learn how to speed up your data management, making your spreadsheet smart enough to do the heavy lifting for you.

Create and apply conditional formatting rules to highlight key data automatically;
Use the Find and Replace tools to swiftly locate and modify data;
Implement advanced search options to narrow down your search results accurately;
Integrate rules with search functions to optimize data analysis.

Tarefa

Select cells J6 to J25. Click on Data Validation. Choose Date, Between, 01/01/2023 and 31/12/2023. Click OK.
Click on Find. Type Household, choose the cell's fill color, and click Find All. Highlight all and change the fill color. Click Find All again. Click on Clear Find Format and Find All again.
Switch to the Replace tab and enter Books in Find What and Paper goods in Replace with. Click Replace All.
Click on Go To, enter D14. Click on Special and select Data Validation.

Seção 5. Capítulo 4

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo