In cooking Apple juice or apple cider can fill the bill.
Yes, but make sure it is dry.
Harvey Bristol Cream sherry is a sweet fortified wine, which means it has a different flavor profile compared to dry white wine. While it can be used in some recipes, it will impart a sweeter taste to the dish, which may not be ideal for all savory recipes. If you choose to substitute it, consider adjusting other ingredients to balance the sweetness. For best results, use a dry sherry or a dry white wine if the recipe specifically calls for dry white wine.
Any other liqueur (e.g. vermouth, white wine, even a wine cooler) or juice (e.g. lemonade), ginger ale, or even water could be used instead (if you're dealing with a recipe). You could also omit the sherry--it all depends on what you think the result will taste best like.
Parsley, basil, or mint can be used as substitutes for cilantro in a recipe.
Yes, any good quality white wine can be used instead of sherry.
Paprika, coriander, or chili powder can be used as substitutes for cumin in a recipe.
Yes, white wine vinegar can be used as a substitute for white wine in a recipe, but it will have a more acidic and tangy flavor compared to white wine.
Scotch
You can use equal parts dry sherry/pale sherry wine; not the cooking wine... the drinking wine. :)
In a pinch you can usually make this substitution in a recipe while only slightly negatively impacting the quality of the dish. It's better than leaving the sherry out altogether. Things labeled "cooking wine" are generally the lowest quality sherry with some salt and possibly other seasonings added. So you may want to adjust the salt called for in the recipe to account for the fact that you're adding salt with the cooking wine. Real dry sherry is generally quite inexpensive and might even be cheaper ounce for ounce than supermarket cooking wine. So why not have some on hand?
Typically, you can use 1/4 cup of applesauce to replace one egg in a recipe.
Cottage cheese or mascarpone cheese can be used as substitutes for ricotta cheese in a recipe.