D100: Introduction to Spreadsheets Glossary Terms
Terms in this set (31)
Absolute Cell Reference A cell reference that remains constant when a formula is pasted
contains a $.
Algorithm The part of a calculation that is applied to the measure. Ex: ave
Bar Charts Charts that depict values with boxes that span the horizontal a
The length of the boxes represents the individual values. Large
depicted using longer boxes.
Cells Small boxes that store individual pieces of data or calculations
Column Charts Charts that depict values with boxes that span the vertical axis
length of the boxes represents the individual values. Larger val
depicted using longer boxes.
Data A class of menu items used to aid in importing and working wit
of data.
, D100: Introduction to Spreadsheets Glossary Terms
Dynamic A formula that references and responds to change in values in
Expression The calculation prescribes by the formula in a spreadsheet.
File A class of menu items used to manipulate workbooks.
Formulas The calculations performed in a spreadsheet.
Formulas Tab A class of menu items used to perform calculations using Exce
functions.
Graphs A two-dimensional representation of numerical data using a lin
Home A class of menu items used to format the appearance of data in
Insert An area that includes features fro specializing elements into wo
as charts, pictures, and shapes.
Terms in this set (31)
Absolute Cell Reference A cell reference that remains constant when a formula is pasted
contains a $.
Algorithm The part of a calculation that is applied to the measure. Ex: ave
Bar Charts Charts that depict values with boxes that span the horizontal a
The length of the boxes represents the individual values. Large
depicted using longer boxes.
Cells Small boxes that store individual pieces of data or calculations
Column Charts Charts that depict values with boxes that span the vertical axis
length of the boxes represents the individual values. Larger val
depicted using longer boxes.
Data A class of menu items used to aid in importing and working wit
of data.
, D100: Introduction to Spreadsheets Glossary Terms
Dynamic A formula that references and responds to change in values in
Expression The calculation prescribes by the formula in a spreadsheet.
File A class of menu items used to manipulate workbooks.
Formulas The calculations performed in a spreadsheet.
Formulas Tab A class of menu items used to perform calculations using Exce
functions.
Graphs A two-dimensional representation of numerical data using a lin
Home A class of menu items used to format the appearance of data in
Insert An area that includes features fro specializing elements into wo
as charts, pictures, and shapes.
