Exam 3: Working With Formulas and Functions

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

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

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.

AutoFill,which copies content and formats from a cell or range into an adjacent cell or range._________________________

-Referring to the figure above,in order to open the Function Arguments dialog box select a function from the ____.

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

Case-Based Critical Thinking Questions Case 3-1 Charles is a recent college graduate.He is paying rent for the first time,as well as utility bills,such as cable,electric,and telephone.He also has some hefty school loan payments.Charles has a good paying job and knows that even though he has lots of expenses,it is critical for him to save money each month,too.He decides to create a budget for himself in Excel 2010. -Charles opens Excel 2010 and enters his monthly income for one year beginning with January.To create a series of months,he types: ____.

The Format Painter button is on the Clipboard group.

Part of effective formula writing is knowing when to use relative,absolute,and ____ references.

Assuming Pamela is faithful to her monthly payments and her interest rate does not change,she should be able to calculate the ____ of the loan.

The mode is most often used with data that has only a few possible values,such as the number of bedrooms in a house._________________________

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

PMT (rate, nper, $p v,[f v=0] \quad[t y p e=0])$ -In the figure above,pv stands for the ____.

In ___________________ interest,the interest is equal to a percentage of principal for each period that the money has been lent.

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

Lookup & Reference is ____.

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

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

PMT (rate, nper, $p v,[f v=0] \quad[t y p e=0])$ -The function being shown in the figure above is the ____ function.

As you drag the fill handle,you will see ____.