Electronic Spreadsheets: Inconsistencies, Errors and Discrepancies

Abstract

The authors, over more than 10 years dedicated to research and scientific production, which have been shared through books and scientific articles focused on information and communication technologies in relation to education and the contemporary context of technological dependence in which society is inserted today, demonstrate not only logical and conceptual weaknesses in the application of spreadsheets, but also discuss new perspectives on the use of complex systems that simulate intelligence. Thus, the present article is developed around the importance of effectively knowing the fundamental mathematical calculations, before indiscriminately accepting the mathematical projections presented by the main tools available in the market. Inconsistencies, weaknesses, and errors, both logical and mathematical in spreadsheets, will be presented, as well as their possible impacts on the market and society.