worksheet


Also found in: Dictionary, Thesaurus, Financial, Acronyms, Wikipedia.
Related to worksheet: workbook

worksheet

a sheet of paper containing exercises to be completed by a pupil or student
Collins Discovery Encyclopedia, 1st edition © HarperCollins Publishers 2005

worksheet

This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

spreadsheet

Software that simulates a paper spreadsheet (worksheet), in which columns of numbers are summed for budgets and plans. It appears on screen as a matrix of rows and columns, the intersections of which are called "cells." The cells are filled with (1) labels, (2) numeric values or (3) formulas.

Labels are descriptive text such as "Rent" and "Gross Sales." Values are the actual numeric data, and formulas command the spreadsheet to do the calculations; for example, SUM CELLS A5 TO A10.


Labels, Values and Formulas
In this Microsoft Excel example, the labels are in cells A1, A2 and A3, and numeric values are in B1 and B2. The formula in B3 is "subtract B2 from B1." In Excel, typing the equals sign starts the formula creation.







The Formulas
Formulas are the spreadsheet's magic, and they are easy to create. You click a cell and then press the key (+, -, etc.) of the arithmetic operation that affects it. For example, the creation of a formula might be "the contents of this cell PLUS the contents of this cell DIVIDED BY the contents of this cell."

The Ripple Effect
After numbers are added or changed, the formulas recalculate the data automatically or with the press of a key. Since the contents of any cell can be calculated with or copied to any other cell, a total of one column can be used as a detail item in another column. For example, the total from a column of expense items can be carried over to a summary column showing all expenses. If the contents of a cell in the detail column changes, its column total changes, which is then copied to the summary column, and the summary total changes.

What If?
The ripple effect lets you create a plan, plug in different assumptions and immediately see the impact on the bottom line. This "what if?" capability makes the spreadsheet indispensable for budgets, plans and other equation-based tasks.

It Started with VisiCalc
One of the major forces behind the personal computer revolution in the 1980s, the spreadsheet originated with VisiCalc in 1978 for the Apple II, followed by SuperCalc, Multiplan, Lotus 1-2-3 and others. See VisiCalc, OLAP, analytical database engine and XL abc's.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
Type across multiple worksheets simultaneously: You can enter text or data across multiple worksheets at the same time by first holding down the Ctrl key, selecting the tabs of the worksheets where you want to type, and then entering the desired text or data.
He further said that as per the worksheet, London flats were bought in 2006 for settlement of $8 million.
* You can have a single worksheet consolidated from several workbooks.
Most of the comments about the worksheet posted on the website it was downloaded from were positive, though one person called it "rubbish" and said, "Why in the world would I want to teach my students about cheating and lovers and boy toys?" 
Users can make use of these new APIs to point the chart's data source to the source or destination worksheets. This release allows to get/set the IFilePathProvider for exporting worksheets to separate HTML files.
To illustrate changes in student responses before and after completing the worksheet we calculated gains.
The NAIC puts the model worksheet in its Guidance Manual for Rating Aspects of the Long-Term Care Insurance Model Regulation.
the worksheet A spokesman which asks Palestinian are the legal framework of our " The worksheet was based on a booklet which calls the Israel-Palestine conflict "an example of separatist terrorism".It provoked a storm of protest one critic, Aliyah Shafiq, 19, for SHOCKING Our story
Table 1 provides a breakdown by NLS certification and job role of how many participants prepared each worksheet.
Apps created with the Intel(R) XDK Storyboard Worksheet Project can be packaged and distributed both for iOS* and Android* mobile platforms.
Johnson's research makes sense, and we believe it is entirely applicable to a discussion of worksheets. Some children receive a positive remark on their worksheet, thus telling them that they are "good" at the topic and need not think further about the underlying learning.