Exam 3: Performing Calculations With Formulas and Functions

Using AutoFill,what would be the extended series of the initial entry Jan? ___ 

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

Case 3-2 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 2016 Analysis tools -Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function,specifying the lookup value and other criteria,the lookup value cannot be found. It displays ______ error value in the cell.

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

A logical function is a function that works with values that are either ____.

Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

Another name for the middle value is the ____ value.

=IF(G22="x",SUM(H22:J22),  " ")with display ______ if G22 is not equal to "x".

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

The Fill Formatting Only option,which is the default,copies both the content and the formatting.______________

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the current cell._________________

If an optional argument is not included,Excel assumes a(n)____ value for it.

The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date.

Case 3-2 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 2016 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 ________.

Case 3-2 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 2016 Analysis tools -Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal.She can use ______.

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

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

The numbers,text,or cell references used by the function to return a value are called ____.

One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results.

An argument can be any type of value including text,numbers,cell references,or even other formulas or functions._______________