- Industry: Computer
- Number of terms: 318110
- Number of blossaries: 26
- Company Profile:
An American multinational software corporation headquartered in Redmond, Washington that develops, manufactures, licenses, and supports a wide range of products and services related to computing.
Data that is stored in a database, such as Access, dBASE, or SQL Server, that is separate from Query and the program from which you started Query.
Industry:Software
A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. In Excel, you can format the data or use it in calculations as you would any other data.
Industry:Software
A reference to a cell or range on a sheet in another Excel workbook, or a reference to a defined name in another workbook.
Industry:Software
A category of information, such as last name or order amount, that is stored in a table. When Query displays a result set in its Data pane, a field is represented as a column.
Industry:Software
A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).
Industry:Software
A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.
Industry:Software
A tool that helps you create or edit a formula and also provides information about functions and their arguments.
Industry:Software
A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.
Industry:Software
A reference to a range of cells, instead of a single cell, that is calculated like a single cell. If cell C10 contains the formula =B5:B15*5, Excel multiplies the value in cell B10 by 5 because cells B10 and C10 are in the same row.
Industry:Software
The cell in which each input value from a data table is substituted. Any cell on a worksheet can be the input cell. Although the input cell does not need to be part of the data table, the formulas in data tables must refer to the input cell.
Industry:Software
