Computer Terminology
About this set
Created by:
puppychow89 on December 1, 2008
Subjects:
Log in to favorite or report as inappropriate.
Order by
20 terms
Terms | Definitions |
|---|---|
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. |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.