Representación Automática de Funciones en Excel y su Aplicación Docente

Abstract

Excel incorporates a huge number of predefined math functions that are typically displayed by means of xy tables, but very seldom the functions in text format are evaluated and directly graphically represented, without x-y tables, by using dynamic Excel named ranges. If this functionality is combined with other Excel tools and with the VBA programming, this task can be automatized and improved with the representation of more than one function in the same graph or the presentation of the numerical derivative of the function or even the importation from other Office apps, as Word or PowerPoint. We think this technique is a very useful teaching resource that can be used by both teachers and students.