Software Apps Vocab Exam 2

link

to consolidate data from separate workbooks

source workbook

workbook from which you copy or link data

destination workbook

the workbook that receives data from another workbook when two workbooks are link; also known as the dependent file

path

address that describes the exact location of a file in a file hierarchy showing the folder with the highest hierarchy level on the left and steps through each hierarchy level toward the righ 

indirect referencing

a cell reference in which the reference itself is a calculated value

header row

In an Excel or Word table, the first row; it contains field (column) names

data definition table

documentation that lists the fields to be maintained for each record, a description of information each field will include, and the type of data stored in each field

freeze

to keep rows and/or columns you select visible as you scroll a worksheet

ascending order

the arrangement of text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest

descending order

data sorted from highest to lowest, most recent to earliest, or alphabetically from Z to A

primary sort field

the first sort field specified that determines the order of records in an objected

secondary sort field

In Access and Excel, a second field that determines the order of records in an object that are already sorted by a primary sort field

custom list

a sequence you specify to sort data

subtotals

In Excel, summary functions applied to part of a data range

criteria filters

conditions you specify for a filter

calculated field

In an Excel table, a field whose values are not entered but calculated based on other fields

structural references

a reference that refers to a structural element of an Excel table

advanced filtering

In an Excel table or data range, a way of writing more complicated filter criteria that involves expression that combine fields using the AND and OR logical operator

criteria range

a location separate from the table used to list specific search specifications

partial lookup

a look up that matches a character pattern rather than a specific value

IFS function

a function that tests for multiple conditions without nesting

AND function

a logical function that returns TRUE if both arguments are true

OR function

a logical function that returns TRUE if either part of the arguments are true

NOT function

a logical function that uses a single argument and returns TRUE if the condition is false

conditional count

refers to the COUNTIF function, which calculates the number of cells in a range that match criteria you specify

COUNTIFS function

a function that counts the number of cells within a range that meet multiple criteria

conditional sum

refers to the SUMIF function, which adds the value in a range that match criteria you specify

SUMIFS function

In Excel, a function that adds values in a range that meet multiple criteria

AVERAGEIF

averages the values in a range that match criteria you specify

AVERAGEIFS function

An Excel function that calculates the average of values within a range that meet multiple criteria

AVERAGEIFS function

a function that calculates the average of values of cell that match criteria you specify

drilling down

In Excel, the process in data analysis in which the data view goes from the most general to the most specific

PivotTable cache

an object that stores PivotTable data

Show Report Filter Pages tool

a tool used to create multiple copies of a PivotTable

manual group

a new PivotTable group created by combining items within a field that appears as a new field within the PivotTable

base field

a field used as the basis for comparison

base item

an item used as the basis for comparison

PivotTable cache

an object that stores PivotTable data

PivotTable Wizard

the tool used to PivotTables prior to Excel 2016; can be used now to create a separate PivotTable cache

calculated item

a user-defined formula for calculations between items within a PivotTable field

calculated field

In an Excel table, a field whose values are not entered but calculated based on other fields

standard PivotTable

a PivotTable that summarizes data from an Excel table

named sets

a feature that defines which fields are displayed within each part of the PivotTable based on the Data Model

distinct count

counts the unique values within a field

GETPIVOTDATA function

the function that extracts information from a PivotTable for use in a report

data cube

a multidimensional array of values found in PivotTables

Online Analytic Processing (OLAP) database

a database built to optimize structured data for querying and reporting

database function

a function that performs summary data analysis, such as sum, average, or count, on an Excel table or data range based on criteria specified in a criteria range

linked data types

 data types linked to resources on the Internet