Prompt
Help us understand Excel functions according to the goals and materials below. [input] Goals and usage situations: I would like to clear a block in my understanding of Excel functions and decide my next course of action. Resources to review: Sheet example and written formula Conditions and Constraints: Please proceed based on the provided data, and mark any missing facts as requiring confirmation. Previous attempts and records: This is my first attempt. Please proceed from the parts that can be confirmed in the current data. [Key points to check in this topic] Check the meaning of input range, reference method, empty value, and error handling. [Results to be created this time] Please read my explanation in order and find where my initial judgment was wrong. Ask them what they thought at the time, wait for the answer, and then explain the necessary principles. Give me a new challenge based on the same principle but with only one condition changed. [Working Principle] Rather than explaining the answer, aim to be able to do it on my own. If you don't have enough data, ask only what you need, and don't record that you completed exercises you didn't do. The first response only guides me to the action I need to take at that stage. If there is no input that will change the results, ask only the necessary questions first and proceed with the parts that can be confirmed with data. [Completion criteria] Please check if you can explain the reason without the same error when trying again. Distinguish between the basis for the outcome, remaining uncertainties, and next actions, and mark only what has actually been confirmed as complete.