Excel Prompts

Excel Prompts

1. One-shot prompt: Create a formula that calculates the sum of a range of cells.
2. Few-shot prompt: Write a macro that formats a range of cells based on a specific condition.
3. Self-consistency prompt: What are the key differences between a formula and a function in Excel? Provide at least three examples.
4. In-context learning prompt: Create a chart that displays the sales data for the past year.
5. One-shot prompt: Create a formula that calculates the average of a range of cells.
6. Few-shot prompt: Write a macro that copies data from one sheet to another based on a specific condition.
7. Self-consistency prompt: What are the key principles of data validation in Excel? Provide at least three examples.
8. In-context learning prompt: Create a pivot table that summarizes the sales data by product category.
9. One-shot prompt: Create a formula that calculates the percentage change between two values.
10. Few-shot prompt: Write a macro that sorts a range of cells based on a specific condition.
11. Self-consistency prompt: What are the key differences between a chart and a graph in Excel? Provide at least three examples.
12. In-context learning prompt: Create a conditional formatting rule that highlights cells that contain a specific value.
13. One-shot prompt: Create a formula that calculates the maximum value in a range of cells.
14. Few-shot prompt: Write a macro that filters a range of cells based on a specific condition.
15. Self-consistency prompt: What are the key principles of data analysis in Excel? Provide at least three examples.
16. In-context learning prompt: Create a data validation rule that only allows values between two specific numbers.
17. One-shot prompt: Create a formula that calculates the minimum value in a range of cells.
18. Few-shot prompt: Write a macro that hides rows or columns based on a specific condition.
19. Self-consistency prompt: What are the key differences between a worksheet and a workbook in Excel? Provide at least three examples.
20. In-context learning prompt: Create a formula that calculates the standard deviation of a range of cells.
21. One-shot prompt: Create a formula that calculates the median value in a range of cells.
22. Few-shot prompt: Write a macro that inserts a new row or column based on a specific condition.
23. Self-consistency prompt: What are the key principles of data visualization in Excel? Provide at least three examples.
24. In-context learning prompt: Create a formula that calculates the mode value in a range of cells.
25. One-shot prompt: Create a formula that calculates the count of cells that contain a specific value.
26. Few-shot prompt: Write a macro that highlights cells that contain a specific value.
27. Self-consistency prompt: What are the key differences between a named range and a table in Excel? Provide at least three examples.
28. In-context learning prompt: Create a formula that calculates the percentage of cells that contain a specific value.
29. One-shot prompt: Create a formula that calculates the absolute value of a cell.
30. Few-shot prompt: Write a macro that deletes rows or columns based on a specific condition.
31. Self-consistency prompt: What are the key principles of data cleaning in Excel? Provide at least three examples.
32. In-context learning prompt: Create a formula that calculates the product of a range of cells.
33. One-shot prompt: Create a formula that calculates the square root of a cell.
34. Few-shot prompt: Write a macro that copies data from one workbook to another based on a specific condition.
35. Self-consistency prompt: What are the key differences between a filter and a slicer in Excel? Provide at least three examples.
36. In-context learning prompt: Create a formula that calculates the exponential value of a cell.
37. One-shot prompt: Create a formula that calculates the logarithmic value of a cell.
38. Few-shot prompt: Write a macro that merges cells based on a specific condition.
39. Self-consistency prompt: What are the key principles of data modeling in Excel? Provide at least three examples.
40. In-context learning prompt: Create a formula that calculates the absolute deviation of a range of cells.
41. One-shot prompt: Create a formula that calculates the variance of a range of cells.
42. Few-shot prompt: Write a macro that formats a range of cells based on a specific color scheme.
43. Self-consistency prompt: What are the key differences between a scatter plot and a line chart in Excel? Provide at least three examples.
44. In-context learning prompt: Create a formula that calculates the correlation coefficient between two ranges of cells.
45. One-shot prompt: Create a formula that calculates the coefficient of determination between two ranges of cells.
46. Create a formula that calculates the sum of a range of cells.
47. Write a macro that formats a range of cells based on a specific condition.
48. What are the key differences between a formula and a function in Excel? Provide at least three examples.
49. Create a chart that displays the sales data for the past year.
50. Create a formula that calculates the average of a range of cells.
51. Write a macro that copies data from one sheet to another based on a specific condition.
52. What are the key principles of data validation in Excel? Provide at least three examples.
53. Create a pivot table that summarizes the sales data by product category.
54. Create a formula that calculates the percentage change between two values.
55. Write a macro that sorts a range of cells based on a specific condition.
56. What are the key differences between a chart and a graph in Excel? Provide at least three examples.
57. Create a conditional formatting rule that highlights cells that contain a specific value.
58. Create a formula that calculates the maximum value in a range of cells.
59. Write a macro that filters a range of cells based on a specific condition.
60. What are the key principles of data analysis in Excel? Provide at least three examples.
61. Create a data validation rule that only allows values between two specific numbers.
62. Create a formula that calculates the minimum value in a range of cells.
63. Write a macro that hides rows or columns based on a specific condition.
64. What are the key differences between a worksheet and a workbook in Excel? Provide at least three examples.
65. Create a formula that calculates the standard deviation of a range of cells.
66. Create a formula that calculates the median value in a range of cells.
67. Write a macro that inserts a new row or column based on a specific condition.
68. What are the key principles of data visualization in Excel? Provide at least three examples.
69. Create a formula that calculates the mode value in a range of cells.
70. Create a formula that calculates the count of cells that contain a specific value.
71. Write a macro that highlights cells that contain a specific value.
72. What are the key differences between a named range and a table in Excel? Provide at least three examples.
73. Create a formula that calculates the percentage of cells that contain a specific value.
74. Create a formula that calculates the absolute value of a cell.
75. Write a macro that deletes rows or columns based on a specific condition.
76. What are the key principles of data cleaning in Excel? Provide at least three examples.
77. Create a formula that calculates the product of a range of cells.
78. Create a formula that calculates the square root of a cell.
79. Write a macro that copies data from one workbook to another based on a specific condition.
80. What are the key differences between a filter and a slicer in Excel? Provide at least three examples.
81. Create a formula that calculates the exponential value of a cell.
82. Create a formula that calculates the logarithmic value of a cell.
83. Write a macro that merges cells based on a specific condition.
84. What are the key principles of data modeling in Excel? Provide at least three examples.
85. Create a formula that calculates the absolute deviation of a range of cells.