software apps final exam

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

arithmetic operator

A mathematical symbol representing the operations of addition, subtraction, multiplication, division, or exponentiation.

date data

A value in a recognized date format.

serif font

Fonts that have short decorative lines at the upper and lower ends of their characters.

sans serif font

Fonts that do not include short decorative lines at the upper and lower ends of their characters.

absolute cell reference

A$1, $A1, $A$1

COUNT function

The Excel function that tallies how many cells in a specified range contain numbers or dates.

HLOOKUP function

Searches for a value in the top row of a table or array and returns a value in the same column from a row you specify; used when comparison values are in the top row.

goal seek

A feature that automates the trial-and-error process by allowing you to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal.

IF function

A logical function that tests a condition and then returns one value if the condition is true and another if false.

IFERROR

A function used to catch error values and replace them with a user-defined text string or value.

INT function

The function that always rounds a value down to the next lowest integer.

key performance indicator

A measurement used by business to measure achievement of a specific goal.

MODE.MULT function

The function that returns the single value that is repeated most often in the range.

MROUND function

The function that rounds a value to the nearest multiple of a given number.

NETWORKDAYS function

The function that calculates the number of working days between two dates

ROUNDDOWN function

The function that rounds a value to the next lowest digit.

ROUNDUP function

The function that rounds a value to the next highest digit.

VLOOKUP function

A function that returns values from a vertical lookup table.

WORKDAY function

A function that displays the date of a weekday that is a specified number of weekdays past a starting date.

Cost-volume-profit (CPV) analysis

A branch of financial analysis that studies the relationship between expenses, sales volume, and profitability.

Variable expense

Expenses that change in proportion to the volume of production.

cost of good sold

The expenses directly related to the cost of production; also known as cost of sales.

fixed expense

In financial analysis, an expense that must be paid regardless of sales volume.

mixed expense

Expenses which are part variable and part fixed.

break-even analysis

Another term for Cost-Volume-Profit (CVP) analysis.

cost-volume-profit (CPV) chart

A branch of financial analysis that studies the relationship between expenses, sales volume, and profitability.

data table

A range of cells that shows the resulting values when one or more input values are varied in a formula; in a chart, a grid containing the chart data.

array formula

An Excel formula that performs multiple calculations within a single step.