Thursday, May 6, 2010

Vocabulary Words: Excel Set #2

Absolute Cell Reference - A cell reference used in a formula in a spreadsheet program that does not change when the formula is copied or moved.
http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Absolute_Cell_References___If_You_Dont_Want_Cell_Reference_To_.PNG

Argument - Supply the data for the function to use in it's calculations.
http://www.msoffice-tutorial-training.com/images/excel-product-function-argument.gif

Chart - Let's you create any chart you want. When you enter data, everything else changes along with it.
http://bytescout.com/images/examples/graphdigitizer_color_recogn_chart_in_excel.png


Embedded Chart - A way to insert data into a chart in an easier way.
http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Resize_Embedded_Chart___Select_Chart_Position_Mouse_Pointer.PNG

Formulas - A mathematical equation used to calculate a value.
http://z.about.com/d/spreadsheets/1/5/3/0/-/-/sbsp2_4.gif

Function Formula - A preset formula in excel.
http://www.timeatlas.com/images/stories/excel-div3.png

Mathematical Functions - A way to calculate functions in excel.
http://www.siliconbeachtraining.co.uk/free-resources/wp-content/uploads/2009/09/Excel-Count-Example.JPG

Mixed Cell Reference - Mixed cell references have one portion as a relative reference and one as an absolute reference.
http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Mixed_Cell_References___For_Example_a1_Is_Absolute_For_Colu.PNG

Operand - Objects that are manipulated.
http://www.wandora.org/wandora/wiki/images/Gellish_excel.gif

Operator - Symbols that represent specific actions.
http://wiki.ggc.usg.edu/mediawiki/images/3/30/ExcelOperator.jpg

Order Of Evaluation - A way to evaluate a formula using exponentiation, multiplication and division, addition and subtraction.
http://img.youtube.com/vi/O3bcbpBxOaY/0.jpg

Relative Cell References - A way to identify the location of a cell or a group of cells.
http://z.about.com/d/spreadsheets/1/G/R/9/-/-/relative_cell_reference.gif

Statistical Functions - Used to analysis the data in a spreadsheet.
http://sciencefair.math.iit.edu/analysis/statistics/excelstats3.jpg

No comments:

Post a Comment