Matching Pairs Excel module 3Online version Excel Vocabulary by Shanna Sung 1 Mixed cell reference 2 Goal seek 3 Volatile function 4 Assumptions 5 Absolute cell reference 6 Drag and Drop 7 8 9 Relative cell reference 10 Data series 11 Now function 12 Category names 13 Accessibility 14 Format symbols 15 Logical test 16 17 IF function The first part of an IF function. The range that identifies the major groups for a chart. A temporary storage area in the computer's memory that lets you collect text and objects from a file created by a Microsoft Office app. An Excel message indicating a cell reference error. A features reverses the trial-and-error process A cell value that you can change to determine a new value for formulas. The practice of removing barriers that might prevent individuals with disabilities from interacting with data or an app. Moving an item by selecting it and then dragging the selection to a new location. The set of values represented in a chart. A function that automatically recalculates its values every time Excel does any calculation in the workbook. A symbol that assigns a format to numbers as they are entered. A function that assigns a value to a cell based on a logical test. A way to explore the impact that changing input values has on calculated values and output values.