Exam 8: Calculating Data With Formulas and Functions

When you nest functions, you should have ____.

The ____________________ function is a logical function that returns one value if the statement is true and returns a different value if the statement is false.

____________________ is an Excel function category that returns information about the format, location, or contents of worksheet cells.

Using AutoFill, what would be the extended series of the initial entry Jan? ___

Which of the following is a Math & Trig function? ____

Which of the following is not a comparison operator? ____

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2013 Analysis tools. -Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.

MATCHING -Function counts the number of nonblank cells in the specified range

The small black plus sign in the lower-right corner of a selected cell or range is called the ____________________.

To display the current date and time, which is updated each time the workbook is reopened, use the TODAY function.

A lookup table organizes numbers or text into categories. _____________

____ arguments may provide more control over the returned value.

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2013 Analysis tools. -Susan designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value. To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________.

MATCHING -A date and time function

The Insert Function dialog box has a(n) ____ option.

Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"?

Why is it that the TODAY and NOW date functions do not have any arguments?

Goal Seek 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 ____.