Flashcards
Excel vocab 2
Cards in this deck (19)
- 1default settingsPre-set settings that determine how Excel behaves when performing an action.
- 2GroupCommands on the default ribbon tabs that are related in functionality.
- 3navigation paneA pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.
- 4print optionsSeveral settings that enable you to change how a document prints.
- 5tab(1) An area on the ribbon that contains groups of related commands. (2) An area of the Backstage navigation pane that contains groups of related commands.
- 6templateA file that includes formatting and formulas complete with designs, tools, and specific data types.
- 7absolute cell referenceA reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.
- 8calculation operatorOperators that specify the calculations to be performed.
- 9cell referenceA reference that identifies a cell’s location in the worksheet based on its row number and column letter.
- 10ConstantA number or text value entered directly into a formula.
- 11external referenceA cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
- 12formulaAn equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
- 13mixed cell referenceA cell reference that uses an absolute column or row reference, but not both.
- 14named rangeA group of cells, and occasionally a single cell, with a designated name.
- 15nested parenthesesParentheses inside of parentheses within a formula.
- 16operandAn element that identifies the values to be used in a calculation.
- 17order of operationsThe rules Excel follows to calculate any formula that contains two or more operators.
- 18relative cell referenceA cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
- 19scopeThe location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.
Information
- Description
- 10th grade excel Flashcards on Excel vocab 2 , created by Jaiden Gatling on 07/09/2018.
- Created by
- Jaiden Gatling
- Views
- 0
- Rating
More on Spreadsheet interface and terminology