Exam 3: Calculating Data With Formulas and Functions

Excel functions are organized into ____ categories.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Function counts the number of nonblank cells in the specified range

Which function counts how many cells in a range contain numbers,where value1,value2,and so forth are text,numbers,or cell references?

An error value indicates that some part of a $\underline { \text { function } }$ is preventing Excel from returning a calculated value.________________

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.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains both relative and absolute references.

To display the current date and time,which is updated each time the workbook is reopened, use the TODAY 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's spending varies from month to month.She wants to calculate the total expenses for each month.She wants to see all of the arguments associated with the SUM function so she clicks the ____ then clicks SUM to open the Function Arguments dialog box.

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

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

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

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 designs a worksheet with the inventory number,description,quantity,unit cost,reorder point and value. To find values in tables of data,and insert them in another location in the worksheet such as cells or in formulas,she will use ________.

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

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 wants to find out what her median monthly spending is.The monthly totals for her spending appear in the range A10:L10.Which of the following is NOT a way to enter the MEDIAN function into her database?

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

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

Which of the following is not a comparison operator? ____

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A function inside another function