Exam 3: Calculating Data With Formulas and Functions

=ROUND(AVERAGE(A1:A100),2)is an example of a(n)____ function.

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

A constant is a value in a formula that doesn't change.

After you describe a function in the Search for a function box in the Insert Function dialog box,click ____.

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

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

The ____________________ is the middle value from a sample.

A $\underline { \text { trial-and-error method } }$ lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the $\underline { \text { current } }$ cell._________________

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

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

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

An error value begins with a pound sign (#)followed by an error name that indicates the type of error.

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.

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 needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .

Which of the following is not a date function? ____

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

The ____ function returns the maximum value in the range.

Which of the following is not an Excel function category? ____

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