Question 1

Functions can also be ____________________ or placed inside another function.

Accepted Answer

The answer of Functions can also be ____________________ or placed...

Question 2

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

Accepted Answer

The answer of What is the relationship between the Function...

Question 3

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

Accepted Answer

The answer of A(n)____________________ function is a function that works...

Question 4

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

Accepted Answer

The answer of ____________________ automates the trial-and-error process by allowing...

Question 5

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

Accepted Answer

The answer of Some cell references are called ____________________ references...

Question 6

A(n)____________________ reference contains both relative and absolute references.

Accepted Answer

The answer of A(n)____________________ reference contains both relative and absolute...

Question 7

An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.

Accepted Answer

The answer of An ___________________ occurs when the lookup value...

Question 8

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 make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet.She can use ______.

Accepted Answer

What-If Analysis is the best choice as it allows Susan to explore the impact that changing input values has on the calculated values in the worksheet. It includes tools like Goal Seek, Scenario Manager, and Data Tables. Lookup Analysis, IF conditions, and nested OR conditions are not relevant to exploring the impact of input value changes.

Question 9

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

Accepted Answer

The answer of ____________________ is a set of rules which...

Question 10

Explain what a logical function is and give an example of when you would use one in Excel 2013.

Accepted Answer

The answer of Explain what a logical function is and...

Question 11

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

Accepted Answer

The answer of ____________________ is an Excel function category that...

Question 12

Not all functions have arguments,and some functions have ____________________ arguments,which are not required for the function to return a value,but can be included to provide more control over the returned value.

Accepted Answer

The answer of Not all functions have arguments,and some functions...

Question 13

The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Accepted Answer

The answer of The ____________________ organizes all of the functions...

Question 14

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

Accepted Answer

The answer of Why is it that the TODAY and...

Question 15

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

Accepted Answer

Goal Seek is a feature in Microsoft Excel that allows the user to find the input value needed to achieve a specific goal or output value. This would be useful for Susan in automating the trial-and-error process of finding the input value needed to reach a specific inventory cost goal. Data Validation would not be applicable in this situation as it is used for controlling the type of data entered into a cell. Goal Set and If Conditional are not features in Microsoft Excel.

Question 16

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.

Accepted Answer

The answer of The ____________________ function is a logical function...

Question 17

TODAY is an example of a(n)____________________ function.

Accepted Answer

The answer of TODAY is an example of a(n)____________________ function....

Question 18

The ____________________ is the middle value from a sample.

Accepted Answer

The answer of The ____________________ is the middle value from...

Question 19

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

Accepted Answer

The answer of The small black plus sign in the...

Question 20

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

Accepted Answer

The answer of A(n)____________________ operator is a symbol that indicates...

Quiz 3: Calculating Data With Formulas and Functions