Why Know how do to something when you can just "prompt" it....

I've been a spreadsheet user for years. Yes, they are not always the best but it's a powerful tool where data comes to life. Now the pipeline I keep hearing about "prompting". It boils down to "Hey AI make a spreadsheet of all this random data and add this and that", click the button and that's it. But do you actually KNOW what data you are asking to be pulled apart and smooshed together? What its headers are? The final outcome? Can you READ the data? The loss of knowledge of how to pivot, read, and understand what you're looking at will be devastating. In my now almost 10 years in corporate, loss of knowledge is more damning than I think people realize. How do you understand what you are looking at? How do you know its genuine? How do you make an SOP or know when one should be needed? What are the risks and pitfalls per what the data is telling us? AI takes that knowledge all away, and you're just left hoping the AI is correct. But in my head, how do we know it is? How can we trust…