Flashcards
Chapter 8 words
Cards in this deck (20)
- 1RangeTwo or more cells on a sheet
- 2Read-OnlyA setting that allows a file to be read or
copied but not changed or saved - 3RecordA collection of information about a
particular person, place, event, or thing - 4Refresh (External Data Range)To update data from an external data source
- 5Refresh (Pivot Table)To update the contents of a PivotTable or PivotChart to reflect changes to the underlying source data
- 6Regression AnalysisA form of statistical analysis used for forecasting
- 7Relative ReferenceIn a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to
- 8Remote ReferenceA reference to data stored in a document from another program
- 9Report FilterA field that's used to filter a subset of data in a PivotTable or PivotChart into one page for further layout and analysis
- 10Report TemplateAn Excel template that includes one or more queries or PivotTables that are based on external data
- 11Result SetThe set of records returned when you run a query
- 12Row HeadingThe numbered gray area to the left of each row
- 13Row LabelA field that's assigned a row orientation in a PivotTable
- 14R-Squared ValueA number from 0 to 1 that reveals how closely the estimated values for the trendline correspond to your actual data
- 15ScenarioA named set of input values that you can substitute in a worksheet model
- 16Scroll LockWith scroll lock turned on, the arrow keys scroll the active sheet rather than make a different cell active
- 17SectionAny combination of a worksheet, view, and scenario that you choose when you create a report
- 18SelectTo highlight a cell or range of cells on a worksheet
- 19Select All ButtonThe gray rectangle in the upper-left corner of a data sheet where the row and column headings meet
- 20Series AxisA chart axis that represents the depth dimension in a true 3-D chart
Information
- Description
- Banks Flashcards on Chapter 8 words, created by Journi Levite on 23/10/2019.
- Created by
- Journi Levite
- Views
- 0
- Rating