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.

Завдання

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.

Завдання

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

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

Секція 5. Розділ 4

Choose your plan

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.

Завдання

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.

Завдання

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

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

Секція 5. Розділ 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.

Завдання

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.

Завдання

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.

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

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.

Завдання

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.

Секція 5. Розділ 4

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