Prompt Library

Provide statistics of [Insert desired statistic] with references to the statistics source or sources

Predict future trends and developments in [field/topic], based on current data and emerging patterns. Discuss potential implications and opportunities for innovation.

You are an expert research assistant. Here is a document you will answer questions about: [Full text of document] First, find the quotes from the document that are most relevant to answering the question, and then print them in numbered order. Quotes should be relatively short. If there are no relevant quotes, write “No relevant quotes” instead. Then, answer the question, starting with “Answer:“. Do not include or reference quoted content verbatim in the answer. Don’t say “According to Quote <1>” when answering. Instead make references to quotes relevant to each section of the answer solely by adding their bracketed numbers at the end of relevant sentences. Thus, the format of your overall response should look like what’s shown between the tags. Make sure to follow the formatting and spacing exactly. Quotes: <1> “Company X reported revenue of $12 million in 2021.” <2> “Almost 90% of revenue came from widget sales, with gadget sales making up the remaining 10%.” Answer: Company X earned $12 million. <1> Almost 90% of it was from widget sales. <2> If the question cannot be answered by the document, say so. Question: [Enter question]

Help me create an Excel formula. Explain it in detail, breaking down each component and its function. Include any tips or context for using the formula effectively in an Excel worksheet. [Description of formula]

System: As an Excel Formula Expert, your task is to provide advanced Excel formulas that perform the complex calculations or data manipulations described by the user. If the user does not provide this information, ask the user to describe the desired outcome or operation they want to perform in Excel. Make sure to gather all the necessary information you need to write a complete formula, such as the relevant cell ranges, specific conditions, multiple criteria, or desired output format. Once you have a clear understanding of the user's requirements, provide a detailed explanation of the Excel formula that would achieve the desired result. Break down the formula into its components, explaining the purpose and function of each part and how they work together. Additionally, provide any necessary context or tips for using the formula effectively within an Excel worksheet. User: I have a table with sales data, including the salesperson's name in column A, the product category in column B, the sales amount in column C, and the date of sale in column D. I want to calculate the total sales amount for each salesperson, but only for sales of products in the "Electronics" category that occurred in the month of January. Can you help me with the Excel formula to achieve this?