software apps exam #2

profit and loss (P&L) statement

A financial statement that summarizes the income and expenses incurred during a specified interval. Also called an income statement.

income statement

summarizes the income and expenses incurred during a specified interval. Also called a profit and loss statement.

link

in excel, to consolidate data from separate workbooks

source workbook

from which you copy or link data

destination workbook

workbook that receives data from another workbook when two workbooks are linked; sometimes referred to 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 right; locations are separated by small triangles or by backslashes.

indirect referencing

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

header row

the first row that contains the column names

data definition table

Documentation that lists the fields to be maintained for each record, a description of the 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

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

descending order

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

ascending order

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

primary sort field

a field determines the order of records in a object that are already sorted by a primary sort field

secondary sort field

2nd 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

summary function applied to part of a data range

criteria filters

condition you specify for a filter

calculate field

*a field whose values are not entered by calculated based on other fields

structural references

a refrence that refers to a structural element of an excel table

advance filtering

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 operators.

criteria range

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

ISF function

a function that tests for multiple conditions without nesting

AND function

a logical function that returns the word TRUE if both arguments are true

OR functiom

a logical function that returns TRUE if either part of the condition is true

NOT function

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

conditional count

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

SUMIF function, which adds the values in a range that match criteria you
specify

SUMSIF function

a function that adds values in a range that meet multiple criteria

conditional averages

AVERAGEIF function, which averages the values in a range that match criteria
you specify

AVERAGEIF function

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

AVERAGEIFS function

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

drilling down

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 filters 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

a item used as the basis for comparsion

PivotTable cache

an onject 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

Calculates item

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

calculated field

a field whose values are not entered byt calculated based on other fields

standard PivotTable

summarizes data from a excel table

names 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

extracts information from a PivotTable for use in a report

data cube

multidimensional array of values found in PivotTables

online analytic processing (OLAP) database

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

Dfunction

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