FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Excel : Formulas and Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

What actually changes the value Excel stores to a user determined number of decimal places?

A) Decrease decimal setting
B) Increase decimal setting
C) ROUND function
D) DECIMAL function

E) B) and C)
F) C) and D)

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

In a lookup table, the number of the column which contains the return values is called the ________.

Correct Answer

verified

Show Answer

Question 53

Essay

Review LaterAdd Note

Match the result with the function using the following numbers, 21, 42, 97, 1, 14, 199 [to two decimal places]: I. 31.50 II. 62.33 III. 1 IV. 6 V. 199 A. MIN B. MEDIAN C. MAX D. COUNT E. AVERAGE

Match the example with the function or feature: I. 1,2,3,4,5 II. Winona Lake, Winchester, Perrysburg, Clear Spring III. Return 52 from the list: 29, 47, 21, 52, 1 IV. Return 30 from the list: 29, 47, 21, 52, 1 V. Return 29 from the list: 29, 47, 21, 52, 1 A. MAX B. Sort descending C. MEDIAN D. Sort ascending E. AVERAGE

________ is a set of analytical tools that appears when you select a range.

What does the AVERAGE function not ignore?

The ________ function finds the largest value in a range.

Using ________ simplifies adding complex mathematical formulas to a cell.

A function's ________ defines the rules by which the function operates.

In the PMT function, the PV argument refers to the ________ of the loan.

Which of the following does not comply with the preferred way of using the SUM function?

What two functions compute the central tendency of values?

If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over and four rows down, what would the resultant cell reference become?

The VLOOKUP function has four required arguments.

What punctuation is used to separate the two cell references in a range?

The ________ feature in Excel displays various options when you type an equal (=)sign and then begin typing a function name.

Which of the following is not a category of functions?

The PMT function uses three required arguments and no optional arguments.

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

Which function would you use if you wanted to count the number of values, but ignore cells that have text or are empty?