Exam 8: Excel Module Performing Calculations With Formulas and Functions

The IF function is a logical function that returns one value if a condition is true, and returns a different value if that condition is false. 

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

Case 3-1 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 2016. She need to keep track of her expenses and income for the year. -Ellen opens Excel 2016 and enters her monthly income for one year beginning with January. To create a series of months, she can ____.

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

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

An error value indicates that some part of a function is preventing Excel from returning a calculated value.

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

The ____ category of Excel functions returns (true-false) values.

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

Optional arguments are always placed first in the argument list.

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

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.

Absolute references are marked with a ____.

One challenge of nesting functions is to make sure that you include all of the parentheses. 

Case 3-1 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 2016. She need to keep track of her expenses and income for the year. -Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she uses a(n)____ to identify the cell containing the income value.

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

When you nest functions, you should have ____.

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

Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.

Use ____ references when you want different formulas to refer to the same cell.