Spreadsheet in the context of Formula


Spreadsheet in the context of Formula

Spreadsheet Study page number 1 of 1

Play TriviaQuestions Online!

or

Skip to study material about Spreadsheet in the context of "Formula"


⭐ Core Definition: Spreadsheet

A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The term spreadsheet may also refer to one such electronic document.

In modern spreadsheet applications, several spreadsheets, often known as "worksheets" or simply "sheets", are gathered together to form a "workbook". A workbook is physically represented by a file containing all the data for the book, the sheets, and the cells with the sheets. Worksheets are normally represented by tabs that flip between pages, each one containing one of the sheets, although Numbers changes this model significantly. Cells in a multi-sheet book add the sheet name to their reference, for instance, "Sheet 1!C10". Some systems extend this syntax to allow cell references to different workbooks.

↓ Menu
HINT:

In this Dossier

Spreadsheet in the context of Choropleth map

A choropleth map (from Ancient Greek χῶρος (khôros) 'area, region' and πλῆθος (plêthos) 'multitude') is a type of statistical thematic map that uses pseudocolor, meaning color corresponding with an aggregate summary of a geographic characteristic within spatial enumeration units, such as population density or per-capita income.

Choropleth maps provide an easy way to visualize how a variable varies across a geographic area or show the level of variability within a region. A heat map or isarithmic map is similar but uses regions drawn according to the pattern of the variable, rather than the a priori geographic areas of choropleth maps. The choropleth is likely the most common type of thematic map because published statistical data (from government or other sources) is generally aggregated into well-known geographic units, such as countries, states, provinces, and counties, and thus they are relatively easy to create using GIS, spreadsheets, or other software tools.

View the full Wikipedia page for Choropleth map
↑ Return to Menu

Spreadsheet in the context of Computer file

A computer file is a collection of data on a computer storage device, primarily identified by its filename. Just as words can be written on paper, so too can data be written to a computer file. Files can be shared with and transferred between computers and mobile devices via removable media, networks, or the Internet.

Different types of computer files are designed for different purposes. A file may be designed to store a written message, a document, a spreadsheet, an image, a video, a program, or any wide variety of other kinds of data. Certain files can store multiple data types at once.

View the full Wikipedia page for Computer file
↑ Return to Menu

Spreadsheet in the context of Electronic document

An electronic document is a document that can be sent through non-physical means, such as telex, email, and the internet. Originally, any computer data were considered as something internal—the final data output was always on paper. However, the development of computer networks has made it so that in most cases it is much more convenient to distribute electronic documents than printed ones. The improvements in electronic visual display technologies made it possible to view documents on a screen instead of printing them (thus saving paper and the space required to store the printed copies). However, using electronic documents for the final presentation instead of paper has created the problem of multiple incompatible file formats. Even plain text computer files are not free from this problem—e.g. under MS-DOS, most programs could not work correctly with UNIX-style text files (see newline), and for non-English speakers, the different code pages always have been a source of trouble.

Even more problems are connected with complex file formats of various word processors, spreadsheets, and graphics software. To alleviate the problem, many software companies distribute free file viewers for their proprietary file formats (one example is Adobe's Acrobat Reader). The other solution is the development of standardized non-proprietary file formats (such as HTML and OpenDocument), and electronic documents for specialized uses have specialized formats—the specialized electronic articles in physics use TeX or PostScript.

View the full Wikipedia page for Electronic document
↑ Return to Menu

Spreadsheet in the context of Biocuration

Biocuration is the field of life sciences dedicated to organizing biomedical data, information and knowledge into structured formats, such as spreadsheets, tables and knowledge graphs. The biocuration of biomedical knowledge is made possible by the cooperative work of biocurators, software developers and bioinformaticians and is at the base of the work of biological databases.

View the full Wikipedia page for Biocuration
↑ Return to Menu

Spreadsheet in the context of Interactive computing

In computer science, interactive computing refers to software which accepts input from the user as it runs.

Interactive software includes commonly used programs, such as word processors or spreadsheet applications. By comparison, non-interactive programs operate without user intervention; examples of these include compilers and batch processing applications that are pre-programmed to run independently.

View the full Wikipedia page for Interactive computing
↑ Return to Menu

Spreadsheet in the context of Rule of 72

In finance, the rule of 72, the rule of 70 and the rule of 69.3 are methods for estimating an investment's doubling time. The rule number (e.g., 72) is divided by the interest percentage per period (usually years) to obtain the approximate number of periods required for doubling. Although scientific calculators and spreadsheet programs have functions to find the accurate doubling time, the rules are useful for mental calculations and when only a basic calculator is available.

These rules apply to exponential growth and are therefore used for compound interest as opposed to simple interest calculations. They can also be used for decay to obtain a halving time. The choice of number is mostly a matter of preference: 69 is more accurate for continuous compounding, while 72 works well in common interest situations and is more easily divisible.

View the full Wikipedia page for Rule of 72
↑ Return to Menu

Spreadsheet in the context of Product bundling

In marketing, product bundling is offering several products or services for sale as one combined product or service package. It is a common feature in many imperfectly competitive product and service markets. Industries engaged in the practice include telecommunications services, financial services, health care, information, and consumer electronics. A software bundle might include a word processor, spreadsheet, and presentation program into a single office suite. The cable television industry often bundles many TV and movie channels into a single tier or package. The fast food industry combines separate food items into a "combo meal" or "value meal". Unbundling refers to the process of breaking up packages of products and services which were previously offered as a group or bundle.

A bundle of products may be called a package deal; in recorded music or video games, a compilation or box set; or in publishing, an anthology.

View the full Wikipedia page for Product bundling
↑ Return to Menu

Spreadsheet in the context of OpenDocument

The Open Document Format for Office Applications (ODF), also known as OpenDocument, standardized as ISO 26300, is an open file format for word processing documents, spreadsheets, presentations and graphics and using ZIP-compressed XML files. It was developed with the aim of providing an open, XML-based file format specification for office applications.

The standard is developed and maintained by a technical committee in the Organization for the Advancement of Structured Information Standards (OASIS) consortium. It was based on the Sun Microsystems specification for OpenOffice.org XML, the default format for OpenOffice.org and LibreOffice. It was originally developed for StarOffice "to provide an open standard for office documents."

View the full Wikipedia page for OpenDocument
↑ Return to Menu

Spreadsheet in the context of Inventory management software

Inventory management software is software used for tracking inventory levels, orders, sales and deliveries. It can also be used in the manufacturing industry to create a work order, bill of materials and other production-related documents. Companies use inventory management software to avoid product overstock and outages. It is a tool for organizing inventory data that before was generally stored in hard-copy form or in spreadsheets.

View the full Wikipedia page for Inventory management software
↑ Return to Menu

Spreadsheet in the context of Page zooming

In computing, page zooming is the ability to zoom in and out a document or image at page level. It is usually found in applications related to document layout and publishing, e.g. word processing and spreadsheet programs, and is also found in web browsers. It can be used to improve accessibility for people with visual impairment and people using mobile devices which have a relatively small screen.

View the full Wikipedia page for Page zooming
↑ Return to Menu

Spreadsheet in the context of Productivity software

Productivity software (also called personal productivity software or office productivity software) is application software used for producing information (such as documents, presentations, worksheets, databases, charts, graphs, digital paintings, electronic music and digital video). Its names arose from it increasing productivity, especially of individual office workers, from typists to knowledge workers, although its scope is now wider than that. Office suites, which brought word processing, spreadsheet, and relational database programs to the desktop in the 1980s, are the core example of productivity software. They revolutionized the office with the magnitude of the productivity increase they brought as compared with the pre-1980s office environments of typewriters, paper filing, and handwritten lists and ledgers. In the United States, as of 2015, some 78% of "middle-skill" occupations (those that call for more than a high school diploma but less than a bachelor's degree) required the use of productivity software.

View the full Wikipedia page for Productivity software
↑ Return to Menu

Spreadsheet in the context of Scientific calculator

A scientific calculator is an electronic calculator, either desktop or handheld, designed to perform calculations using basic (addition, subtraction, multiplication, division) and advanced (trigonometric, hyperbolic, etc.) mathematical operations and functions. They have completely replaced slide rules as well as books of mathematical tables and are used in both educational and professional settings.

In some areas of study and professions scientific calculators have been replaced by graphing calculators and financial calculators which have the capabilities of a scientific calculator along with the capability to graph input data and functions, as well as by numerical computing, computer algebra, statistical, and spreadsheet software packages running on personal computers. Both desktop and mobile software calculators can also emulate many functions of a physical scientific calculator. Standalone scientific calculators remain popular in secondary and tertiary education because computers and smartphones are often prohibited during exams to reduce the likelihood of cheating.

View the full Wikipedia page for Scientific calculator
↑ Return to Menu

Spreadsheet in the context of Apple II

Apple II ("apple two", stylized as Apple ][) is a series of microcomputers manufactured by Apple Computer, Inc. from 1977 to 1993. The original Apple II model, which gave the series its name, was designed by Steve Wozniak and was first sold on June 10, 1977. Its success led to it being followed by the Apple II Plus, Apple IIe, Apple IIc, and Apple IIc Plus, with the 1983 IIe being the most popular. The name is trademarked with square brackets as Apple ][, then, beginning with the IIe, as Apple //.

The Apple II was a major advancement over its predecessor, the Apple I, in terms of ease of use, features, and expandability. It became one of several recognizable and successful computers throughout the 1980s, although this was mainly limited to the US. It was aggressively marketed through volume discounts and manufacturing arrangements to educational institutions, which made it the first computer in widespread use in American secondary schools, displacing the early leader Commodore PET. The effort to develop educational and business software for the Apple II, including the 1979 release of the popular VisiCalc spreadsheet, made the computer especially popular with business users and families.

View the full Wikipedia page for Apple II
↑ Return to Menu

Spreadsheet in the context of Web scraping

Web scraping, web harvesting, or web data extraction is data scraping used for extracting data from websites. Web scraping software may directly access the World Wide Web using the Hypertext Transfer Protocol or a web browser. While web scraping can be done manually by a software user, the term typically refers to automated processes implemented using a bot or web crawler. It is a form of copying in which specific data is gathered and copied from the web, typically into a central local database or spreadsheet, for later retrieval or analysis.

Scraping a web page involves fetching it and then extracting data from it. Fetching is the downloading of a page (which a browser does when a user views a page). Therefore, web crawling is a main component of web scraping, to fetch pages for later processing. Having fetched, extraction can take place. The content of a page may be parsed, searched and reformatted, and its data copied into a spreadsheet or loaded into a database. Web scrapers typically take something out of a page, to make use of it for another purpose somewhere else. An example would be finding and copying names and telephone numbers, companies and their URLs, or e-mail addresses to a list (contact scraping).

View the full Wikipedia page for Web scraping
↑ Return to Menu