CS 214 Study Guide - Elementary Arithmetic, Circular Reference, Pivot Table

22 views7 pages

Document Summary

In addition to performing basic arithmetic and mathematical functions: modern spreadsheets provide built-in functions for common financial and statistical operations. Set of steps which are followed in order to solve a mathematical problem or to complete a computer process bar chart. Chart which presents grouped data with rectangular bars with lengths proportional to the values which they represent cell. Unit in a database table or spreadsheet, formed by the intersection of a row and a column cell range. Group or block of cells in a worksheet which have been selected or highlighted cell reference. String identifying a particular cell in a spreadsheet, possibly relative to the cell containing the reference chart. Visual representations of worksheet data circular reference. When the formula in one cell refers directly, or indirectly through a chain of cell references to another cell which refers back to the first cell. Vertical series of cells in a chart, table, or spreadsheet dynamic data exchange.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers

Related Documents

Related Questions