Computer Excel Vocabularies
Terms
undefined, object
copy deck
- Workbook
- An Excel file with one or more worksheets.
- Worksheet
- The work area for entering and calculating data made up of columns and rows separated by gridlines (light gray lines). Also called a spreadsheet.
- Cell
- A cell is the intersection of a column and a row on a worksheet. You enter data into cells to create a worksheet.
- Active Cell
- The active cell contains the cell pointer. There is a dark outline around the active cell.
- Task pane
- A vertical window that provides quick access to common command such as opening and creating workbooks, searching for workbooks, getting help, and so on.
- Formula bar
- As you enter data into a cell, it simultaneously appears in the Formula bar, which is located above the worksheet frame.
- Cell reference
- The location of a cell in a worksheet as identified by its column letter and row number. This is also known as the cell’s address.
- Scroll
- A way to view locations on the worksheet without changing the active cell.
- Sheet tabs
- Tabs that appear at the bottom of the workbook window, which display the name of each worksheet.
- Tab scrolling buttons
- Buttons that appear just to the left of the sheet tabs, which allow you to scroll hidden tabs into view.
- Blank workbook
- The excel default workbook contains three worksheets or sheets.
- Template
- A workbook with certain labels, formulas, and formatting preset, saving you time in creating commonly used worksheets, such as sales invoices or balance sheets.
- Label
- Text in the first row or column of a worksheet that identifies the type of data contained there.
- Default
- The standard settings Excel uses in its software, such as column width or number of worksheets in a workbook.
- AutoComplete
- A feature used to complete an entry based on previous entries made in the column containing the active cell.
- Pick from list
- A shortcut used to insert repeated information.
- AutoCorrect
- A feature used to automate the correction of common typing errors.
- Spelling Checker
- A tool used to assist you in finding and correcting typographical or spelling errors.
- Value
- A number entered in the worksheet.
- Numeric label
- A number entered in the worksheet as a label, not as a value---such as year 2005 used as a column label.
- Label prefix
- An apostrophe (‘) used to indicate that a number is really a label an dnot a value.
- Series
- A list of sequential numbers, dates, times, or text.
- Standard
- column width The default number of characters that display in a column based on the default font.
- Formula
- An instruction Excel uses to calculate a number
- Mathematical operators
- Symbols used in mathematical operations: + for addition, -for subtraction, * for multiplication, / for division, and ^ for exponentiation.
- Order of mathematical operations
- The order in which Excel performs the calculations specified in a formula.
- Number format
- A format that controls how numerical data is displayed, including the use of commas, dollar signs (or other symbols), and the number of decimal places.
- Percent format
- A style that displays decimal numbers as a percentage.
- Comma Format
- A style that displays numbers with a thousands separator (,).
- Active sheet tab
- The selected worksheet; the tab name of an active sheet is bold.
- Function
- A preprogrammed Excel formula for a complex calculation.
- Function name
- The name given to one of Excel’s predefined formulas.
- Argument
- A variable used in a function. An argument can be a #, text, formula, or a cell reference. A comma separates each argument in a function.
- Nest
- to use a function as an argument within another function
- AutoCalculate
- A feature that temporarily performs the following calculations on a range of cells w/o making you write a formula: Average, Count, Count nums, Max,, Min or Sum
- Natural Language formula
- A formula that refers to column or row heading labels instead of a cell reference or range
- Comment
- A text note attached to a worksheet cell.
- Condition
- A statement in an IF function that if true yields one result and if false yields another result.
- Nesting
- using a function as an argument within another function
- Criteria
- Similar to a condition. In the case of a SUMIF or COUNIF function, the criteria tells Excel which cells to count or sum. You list the criteria, such as >2000, and Excel counts or sums only the cells w/ values greater than 2000.