Exam 8: Calculating Data With Formulas and Functions

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

The fill handle copies ____.

MATCHING -A comparison operator

MATCHING -Used to cycle through reference types

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.

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 wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet. She can use ______.

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

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

An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1. _________________________

Which of the following is not a date 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 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.

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

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

Absolute references are marked with a ____.

Functions are organized in the Function Library group on the FORMULAS tab.

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

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

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