Exam 6: Excel : Formulas and Functions

Match the following terms with their description: I. Formula AutoComplete II. Quick Analysis III. Function ScreenTip IV. Logical test V. Syntax A. Can be used to apply formatting and insert basic functions B. Pop-up description C. A set of rules D. Matches letters as you type E. Evaluates to True or False

You could use both A3>b9 or B9<A3 as the test in an IF function and get the same results. You would just switch the second and third arguments.

Match the following terms with their description: I. Absolute cell references II. Relative cell references III. Mixed cell references IV. Argument V. Function A. Part of it changes when you copy and paste a formula B. Changes when you copy and paste a formula C. Simplifies complex calculations D. Does not change when you copy and paste a formula E. Required input in a function

Match the example with the function or feature: I. =A54 II. =$A54 III. =$A$54 IV. =SUM(A54:B97) V. "Ohio" A. Function B. Relative reference C. Ensures text entry D. Mixed reference E. Absolute reference

What describes a function's purpose?

Match the following terms with their description: I. VLOOKUP II. HLOOKUP III. Lookup table IV. Lookup value V. Column index number A. Data is organized in rows B. Column that contains the return values C. Cell that contains the value to be looked up D. Has the data used with HLOOKUP or VLOOKUP E. Data is organized in columns

The ROUND function requires how many arguments?

A good practice when entering function names is to type them in lowercase and see if Excel converts them to upper case.

What will you see if you enter the TODAY function without the parenthesis?

Which of the following is not an argument associated with the IF function?

The most used logical function is the IF function.

The ________ is the lowest value for a category in the table lookup table.

After you type a function and its opening parenthesis "(" the ________ appears and displays the function's arguments.

In military time, 15:00 is ________ in non-military time.

If you wanted to count the number of entries in a list that contained numbers, text, and blank cells, but ignore the text and blank cells, which function would you use?

The HLOOKUP function can only be used to find exact matches.

Where does Excel automatically display statistics like count, average, and sum when a range of values is selected?

If you wanted to count the number of entries in a list that contained numbers, text, and blank cells, but ignore the blank cells, which function would you use?

FV is a required argument in the PMT function.

Which of the following is not a valid =IF statement?