Excel Chapter 3 Test- BCIS Fall 2015 – Flashcards

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.

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

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook.

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

Optional arguments are always placed first in the argument list.

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

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

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

To display the current date and time, which is updated each time the workbook is reopened, use the TODAY function.

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

The ____ function returns the maximum value in the range.

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

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

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

Case-Based Critical Thinking Questions 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 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?

Referring to the figure above, the last entry shown in Column K is 644.7953813. There is a black "plus sign" on the lower right edge of the cell that is the ____.

Referring to the figure above, the last entry shown in Column K is 644.7953813. There is an icon in the cell underneath the 644.7953813 which is the ____.

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

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

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

The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.

Case-Based Critical Thinking Questions 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 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 ____.

Case-Based Critical Thinking Questions 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 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 ________.

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