Computing II: Terminology Unit 1

Computing II: Terminology Unit 1

EXCEL: Spreadsheet program that allows you to organize data, complete calculations and graph data.

Spreadsheets: electronic equivalent of a piece of paper which has been ruled into rows and columns in which texts, values and formulas can be entered.

Quick Access Toolbar: contains a set of commands that are independent of the Tab currently displayed.

Groups: contain groupings of commands that relate to a specific activity.

Row: is horizontal and is labelled with a number.

Column: is vertical and labelled with letters.

Cell: Intersection of a row and a column.

Cell range: address of a group of cells.

Cell Reference: the column letter and row number that gives the address for that particular cell.

Labels/Text: Headings, labels, Notes and Explanatory text which can be alpha-numeric.

Values: Numbers typed directly into a spreadsheet cell. Can include numbers, currency, dates or times.

Formulas: Equations that calculate a new value from existing values.

Computing II: Terminology Unit 2

Mathematical operator: such as addition or division.

Cell reference: contains the values you want to calculate.

Syntax: formulas that calculate the values in a specific order.

Functions: built-in formulas that allow you to perform more complex calculations.

The equal sign (=): indicating to Excel that the cell contains a function that needs to be calculated.

Relative referencing: method of referencing cells, copy formulas from one cell to another.

Absolute reference: ensure that the cell address is not changed when copied.

Excel Help: window will provide information on the selected function.

AutoSum: button that automatically inserts the SUM function into the selected cell.

Comments: explains complex formulas, list assumptions, and enters reminders.

Computing II: Terminology Unit 3

Copy: feature that allows you to create a duplicate of data contained in a selected cell or cells.

Moving Data: when you need to change the location of data in your spreadsheet.

Category: a window that provides a list of numeric formatting styles that can be applied.

...