HOJAS ELECTRÓNICAS Elementos básicos de la hoja electrónica, el manejo de la información, entornos de Trabajo, operaciones básicas, fórmulas, funciones matemáticas, tablas dinámicas, filtros, funciones condicionales, lógicas, búsquedas, programación de macros, las gráficas y generación de reportes
Loading...
Date
2018-08-28
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Universidad Nacional de Educación Enrique Guzmán y Valle
Abstract
El objetivo de este trabajo de investigación es dar a conocer la modernidad y avances tecnológicos, las hojas contables han ido perdiendo terreno y han dado pie al crecimiento y uso exponencial de la hoja de cálculo, la cual mantiene las características y funciones de la tradicional. Tiene filas, columnas que se interrelacionan e intercomunican entre sí, causando la producción de más celdas que poseen información valiosa permitiendo que se guarde en ella. Estos datos pueden ser tanto textos como números que al ser introducidos permiten calcular valores a partir de fórmulas.
Por otro lado, las hojas son útiles para el almacenamiento de datos numéricos, para luego emplearlas en la realización de cálculos con los datos; estos pueden ser reorganizados, analizados, contrastados y presentados con facilidad gracias a los softwares.
Nos centramos en la determinación del modo de trabajar con las hojas de cálculo; en principio con la barra de herramientas, donde se puede insertar datos e información en la celda, eliminar las que ya no son útiles e incluso descomponer fórmulas.
Alrededor de los años 80 varias empresas introdujeron las hojas electrónicas, al punto que los trabajadores disponían de paquetes que en menos de un año eran reemplazados por versiones más actuales e innovadoras, hecho que en la actualidad todavía ocurre.
Durante el transcurso de los años la situación de esta herramienta moderna ha ido cambiando y evolucionando paulatinamente; a nivel de las compañías productoras vemos que Microsoft se inserta al mercado con Excel, y Lotus Development compró Software Arts.
The objective of this research work is to publicize modernity and technological advances, accounting sheets have been losing ground and have given rise to the exponential growth and use of the spreadsheet, which maintains the characteristics and functions of the traditional one. It has rows and columns that interrelate and communicate with each other, causing the production of more cells that have valuable information allowing it to be stored in it. These data can be both texts and numbers that, when entered, allow values to be calculated from formulas. On the other hand, sheets are useful for storing numerical data, and then using them to perform calculations with the data; These can be reorganized, analyzed, contrasted and presented easily thanks to the software. We focus on determining how to work with spreadsheets; in principle with the toolbar, where you can insert data and information into the cell, delete those that are no longer useful and even decompose formulas. Around the 1980s, several companies introduced electronic forms, to the point that workers had packages that in less than a year were replaced by more current and innovative versions, a fact that still occurs today. Over the years the situation of this modern tool has gradually changed and evolved; At the level of production companies we see that Microsoft enters the market with Excel, and Lotus Development bought Software Arts.
The objective of this research work is to publicize modernity and technological advances, accounting sheets have been losing ground and have given rise to the exponential growth and use of the spreadsheet, which maintains the characteristics and functions of the traditional one. It has rows and columns that interrelate and communicate with each other, causing the production of more cells that have valuable information allowing it to be stored in it. These data can be both texts and numbers that, when entered, allow values to be calculated from formulas. On the other hand, sheets are useful for storing numerical data, and then using them to perform calculations with the data; These can be reorganized, analyzed, contrasted and presented easily thanks to the software. We focus on determining how to work with spreadsheets; in principle with the toolbar, where you can insert data and information into the cell, delete those that are no longer useful and even decompose formulas. Around the 1980s, several companies introduced electronic forms, to the point that workers had packages that in less than a year were replaced by more current and innovative versions, a fact that still occurs today. Over the years the situation of this modern tool has gradually changed and evolved; At the level of production companies we see that Microsoft enters the market with Excel, and Lotus Development bought Software Arts.
Description
Keywords
Rendimiento académico
Citation
Inga Rivera, M. A. (2018). HOJAS ELECTRÓNICAS Elementos básicos de la hoja electrónica, el manejo de la información, entornos de Trabajo, operaciones básicas, fórmulas, funciones matemáticas, tablas dinámicas, filtros, funciones condicionales, lógicas, búsquedas, programación de macros, las gráficas y generación de reportes