Exam 3: Calculating Data With Formulas and Functions

Functions can also be ____________________ or placed inside another function.

What is the relationship between the Function Arguments dialog box and the Insert Function dialog box?

An $\underline { \text { argument } }$ can be any type of value including text,numbers,cell references,or even other formulas or functions._______________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A date and time function

MATCHING Identify the letter of the choice that best matches the phrase or definition. -References that are fixed

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

FUNCTION(argument1,argument2,...)is ____.

In "SUM(number1 [,number2,number3,...])",number 1,number 2,and number 3 may be numbers or ____.

A(n)____________________ function is a function that works with statements that are either true or false.

When you copy a formula that contains an absolute reference to a new location,the reference ____.

The statement "A1 >= B1" tests whether the value in cell A1 is $\underline { \text { lesser } }$ than or equal to the value in cell B1._________________________

-Referring to the figure above, which number refers difference between the scheduled and attended workouts.

The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.

____________________ is a set of rules which specifies how a function should be written.

Another name for the middle value is the ____ value.

-Referring to the figure above,which number represents the COUNT function?

Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2013. She need to keep track of her expenses and income for the year. -Ellen is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year.What function key will make D2 an absolute reference?

A logical function is a function that works with values that are either ____.

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

Functions are organized in the Function Library group on the FORMULAS tab.