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.

Alignment Tab: to alter the position of your data within a cell.

Wrap text: to wrap long text to ensure it fits within a cell’s width.

Shrink: to fit to size the text to fit within a set cell size.

Center Across Selection: feature found on the Alignment Tab in the Formal Cells dialog box.

Ctrl + ~: this will toggle between normal view and show formulas view.

Format Painter: copy the formatting options from one group of cells to another.

Print screen: allow you to select a number of options in printing your document.

Header/Footer Tab: enables you to add headers and footers to your worksheets.

Computing II: Terminology Unit 4

Create a copy: checkbox that allows you to create a copy of the existing sheet.

Delete: allows you to delete an existing sheet.

Rename: allows you to rename your worksheets.

SHIFT key + click: allows you to select a range of worksheets.

Remove duplicates: allows you to permanently delete data.

IF Function: introduces decision making into Excel spreadsheets; It is used to test a value based on a condition, and determines whether it is true or false.

...