Discussion- Management Science And Journal Entry
Excel is an amazingly powerful software but if not used correctly it can give us negative results. One mistake many users make is not selecting all the available cells when putting the data into a graph. We click, hold, and drag the computer mouse to highlight the needed data but what if we miss a row of cells? If we do not notice this lack of full information it will give us a totally inaccurate graph. The best remedy for this is to take our time, double check what was selected each time before we paste or input into another function. Check and double check is the name of this game
Another mistake we make is not double checking our number signs when creating formulas. Usually the excel software is smart enough to notice an incorrect formula but what if it is just a positive or negative symbol? The software would not notice this because it would not be an incorrect formula but an incorrect user. To safeguard against this is to double check and if possible ask for a second user to check it. The other person might see things that we do not and could fix the issue before it gets bigger.
Hindy, J. (2014, July 14). 10 Common Spreadsheet Mistakes You’re Probably Making. Lifehack. Retrieved February 6, 2022, from https://www.lifehack.org/articles/technology/10-common-spreadsheet-mistakes-youre-probably-making.html