Exam 3: Calculating Data With Formulas and Functions

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

The $\underline { \text { WORKDAY } }$ function displays the date of the weekday a specific number of weekdays past a starting date.

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

In the formula =INT(AVERAGE(A1:A100)),which would occur first? ____

A mixed reference "locks" one part of the cell reference while the other part can change.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -AutoFill pattern

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A comparison operator

______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used to cycle through reference types

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 uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function,specifying the lookup value and other criteria,the lookup value cannot be found. It displays ______ error value in the cell.

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

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results.

Optional arguments are always placed first in the argument list.

____ arguments may provide more control over the returned value.

The $\underline { \text { Fill Formatting Only } }$ option,which is the default,copies both the content and the formatting.______________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A Statistical function that calculates the middle value of a collection of numbers

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

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