Exam 12: Excel 2013 : Analyzing Data Using Formulas

-In the accompanying figure,in the formula in the active cell,why is cell D6 divided by 12?

Which Excel feature is used to break a data field into separate columns?

The parts of an IF function are separated by parentheses.

When used in formulas,names become ____ cell references by default.

The ____________________ function calculates the future value of an investment.

The ____ refers to where you will be able to use a named cell or range in worksheets.

-The ____________________ function joins two or more text strings into one.

-In the accompanying figure,how many arguments does the formula in the active cell use in the calculation?

-You can reference,or ____________________ to,data in other sheets and in other workbooks.

Explain how the SUMIF function works.Use an example.

Linking to a workbook means that any changes to the original values are automatically reflected in the consolidation sheet as well.

Names of cells and ranges cannot use ____.

-After you name a cell or range,you can define its ____________________,or the worksheets where you will be able to use it.

When the condition is a question that can be answered with a true or false response,Excel calls this stated condition a(n)____________________ test.

-In the accompanying figure,____ separates the condition from the action to be taken.

The AND function returns a value of TRUE if every logical test in the formula is true.

What Excel features uses worksheet data to predict what should be entered into similar column cells?

-The ____________________ Text to Columns feature breaks data fields in one column into separate columns.

The ____________________ function calculates the periodic payment amount for money borrowed.

-In the accompanying figure,what is the name of the function in the formula of the active cell?