Computer Terminology

Created by puppychow89 

Upgrade to
remove ads

20 terms

F2

The function key used to edit the contents in a cell.

Worksheet

In Excel, a page composed of columns and rows that create cells at their intersection, you type data and formulas into cells

Formula Bar

This bar shows the formula, or text in a cell.

Calculator operator

symbols that indicate what type of calculation to perform on the cells, ranges, or values.

Reference operator

Mathematical calculations which enable you to use ranges in calculations.

Formula

A set of instructions used to perform one or more numeric calculations, such as adding, multiplying, or averaging, on values or cells.

Complex formula

Is one that uses more than one arithmetic operator.

Function ( related to creating a formula)

A special, predefined formula that provides a short cut for a commonly used calculation, for example, SUM(for calculating a total) or COUNT(for counting items in a list).

Absolute reference

a reference that does not change when you copy the formula (requires a $ sign in front of both the column letter and the row number of the cell address).

Workbook

A collection of related worksheets contained within a single Excel file

Electronic Spreadsheet

computer program that performs calculations and presents numeric data.

Cell Address

the location of a cell, expressed by cell coordinates

Cell

The intersection of a column and row in a worksheet, datasheet, or table.

Name Box

most are of the formula bar that shows the cell reference or name of the active cell.

Label

Descriptive text or other information that identifies spreadsheet rows, columns, or chart data, but are not included in calculations.

Formula Prefix

used to start a formula, such as an equal sign

*

The symbol that is used for multiplying.

/

The symbol that is used for division.

+

The symbol that is used for adding.

-

The symbol that is used for subtraction.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

NEW! Voice Recording

Click the mic to start.

Create Set