Exam 12: Excel 2013 : Analyzing Data Using Formulas

Which Excel function totals only the cells in a range that meet given criteria?

Which button do you click in the Function Library group to select SUMIF from the list of functions?

The ____________________ function contains three parts: a condition or logical test,an action to take if the condition is true,and an action to take if the condition is false.

Data can be consolidated from different workbooks in one worksheet.

Symbols,such as less than (<),greater than (>),and equal to (=),are all examples of comparison operators.

The IFERROR function is used to look for spelling errors in Excel.

The comparison operator > means ____________________ than.

The CONCATENATE function breaks a text string into separate strings.

The Name ____________________ dialog box can be used to delete and edit worksheet names.

Which text function capitalizes the first letter in a string of text?

The CONCATENATE function joins two or more ____ into one.

-In the accompanying figure,item number ____________________ indicates the action that Excel should take if the test is true.

The less than (<)and more than (>)symbols are examples of ____________________ operators.

Describe two examples of why you would need to use the PMT function.

-In the accompanying figure,in the formula in the active cell,why is B6 entered as -B6?

What is the calculated result of the formula =PROPER("john smith")?

If there are invalid cell references in a formula,the error value #REF! will display in the cell.

You should use the ____________________ function to reverse the value of an argument.

One way to display formulas is by pressing this key combination.

-In the accompanying figure,item number ____________________ indicates the action that Excel should take if the test is false.