What Is Consolidation

question 187

Multiple Choice

What is consolidation?

• A) Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information
• B) Enables the examination of information from different perspectives
• C) Enables users to get details, and details of details, of information
• D) Finds the inputs necessary to achieve a goal such as a desired level of output

---

Definitions:

AVERAGEIF

An Excel function that calculates the average of all numbers in a range that meet specified criteria.

Financial Functions

Specific mathematical formulas used in spreadsheets or financial software to perform calculations related to finance, such as interest rates, payments, and investment returns.

FV

Future Value, a finance function that calculates the future value of an investment based on a constant interest rate and fixed payments over time.

PMT

A financial function that calculates the payment for a loan based on constant payments and a constant interest rate.