Exam 8: Calculating Data With Formulas and Functions

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

After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.

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?

Optional arguments are always placed first in the argument list.

The ____________________ is the middle value from a sample.

The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date.

By default, AutoFill copies only the content not the formatting of the original range to the selected range.

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

Which of the following is not an Excel function category? ____

MATCHING -AutoFill pattern

The following mixed reference in the formula, $A5, has an absolute column reference and a relative row reference. _________________________

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

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's spending varies from month to month. She wants to calculate the total expenses for each month. She wants to see all of the arguments associated with the SUM function so she clicks the ____ then clicks SUM to open the Function Arguments dialog box.

=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.

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

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 opens Excel 2013 and enters her monthly income for one year beginning with January. To create a series of months, she can ____.

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

The Fill Formatting Only option, which is the default, copies both the content and the formatting. ______________

A(n) ____________________ operator is a symbol that indicates the relationship between two values.

Lookup tables can be constructed for exact match or approximate match lookups.