can i just do.
Perform Find -> first dropdown
Perform Find -> second
Perform Find -> third
Yes, you can do it this way, sort of. @steve_ssh is pointing you in the correct direction (as usual). It's important to grasp the Find tools within FileMaker. Take a look at Found Sets Script Steps Here to get a feel for some of the steps you'll need to understand.
Also look at the Duplicate Record/Request script step. When in Find mode it's used to create a new Find "Request", when in Browse mode it's used to duplicate the record (a bit confusing at first, but notice that when in Browse mode your top menu shows "Records" and when in Find mode it changes to "Requests").
The user experience you're describing can get a bit messy (to script) if many values are available in your selection value lists. And it also depends on your data structure. For example, I took your example to mean that Fruits, Vegetables, Cars, Bicycle are "categories" so I lumped them together (at least when creating new records). And I took Home, Office to mean "location". This can work, but it's not very scalable and I'd want to look to other ways to do this. Filtering by "pick list" is fine, but by allowing any combination (and any order) of selection it can get convoluted.
IF the first two are truly separate filters and not shared categories things could get more manageable. For example the wildcard "*" could be used to find "All" in each.
Here's a crude demo file for you to look at. The "filter" script is rather verbose (i.e. messy and nearly 60 lines, yikes) and there are probably other, cleaner ways to get the user experience you're looking for. There are "tricks" one can do with portals and relationships, but to me they're more advanced methods and one should learn the basics of "Find" first.
The purpose of sharing this file is not to suggest it's elegant or my suggestion to follow it, but hoping that it may provide a working illustration of what steps could be used to accomplish this and how they work. If you carefully read through each step in the script (and step through it using the Script Debugger) perhaps it will provide some guidance.
Edit: Oops! Deleted a needed conditional in the script while testing. Added it back and replaced the file.
FilterByDropdowns.fmp12 (320 KB)