Exam 3: Performing Calculations With Formulas and Functions

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 is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year.What function key will make D2 an absolute reference? 

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

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

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.

If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell.

FUNCTION(argument1,argument2,...)is ____.

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

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

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

The ____________________ is the middle value from a sample.

The fill handle copies ____.

In "SUM(number1 [,number2,number3,...])",number 1,number 2,and number 3 may be numbers or ____.

Which category of Excel functions returns information about the format,location,or contents of worksheet cells? ____ 

Which of the following is not a date function? ____ 

In the formula =IF(A1=B1,C1,C2),the result will be C2 if ____.

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.

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

The Insert Function button is in the ____ group.

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