FREE COMPUTERS AND STUDY GAMES ABOUT CTS 130

PDF Download

FREE COMPUTERS AND STUDY GAMES ABOUT CTS 130

EM03 EXAM QUESTIONS

Qs and Ans Expert- Explanation

This Exam contains:

-Guarantee passing score -50 Questions and Answers -format set of multiple-choice -Expert- Explanation Question 1: In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number

• may be numbers or ____.

Answer:

cell references Question 2: One of the most common statistical approaches is to ____ the sample data.

Answer:

average

Question 3: When you nest functions, you should have ____.

Answer:

same number of left and right parentheses

Question 4: In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.

Answer:

A ? B

Question 5: In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"?

Answer:

returns "RESTART" Question 6: Another way to copy a formula is to use the Fill button on the ____ group.

Answer:

editing Question 7: The ____ is most often used with data that has only a few possible values.

Answer:

mode Question 8: Part of effective formula writing is knowing when to use relative, absolute, and ____ references.

Answer:

mixed Question 9: A logical function is a function that works with values that are either ____.

Answer:

true or false

Question 10: The FV function stands for ____.

Answer:

future value

Question 11: The Insert Function dialog box has a(n) ____ option.

Answer:

search Question 12: In the formula =INT(AVERAGE(A1:A100)), which would occur first? ____

Answer:

find the average of A1:A100

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

Answer:

default

Question 14: The fill handle copies ____.

Answer:

content and formats Question 15: If you were to see ##### in cell B10, the ____ is too small to view the entire value.

Answer:

column width

Question 16: Excel functions are organized into ____ categories

Answer:

eleven Question 17: Use ____ references when you want different formulas to refer to the same cell.

Answer:

absolute

Question 18: The Insert Function button is in the ____ group.

Answer:

function library Question 19: The ____ function category retrieves data from multidimensional databases involving online analytical processing or OLAP.

Answer:

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

Answer:

content.

Question 21: Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____

Answer:

information Question 22: 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.

Answer:

relative

Question 23: Functions can be ____.

Answer:

incorpo as part of larger formulas or placed inside another function

Question 24: Lookup & Reference is ____.

Answer:

an excel function category

Question 25: Using AutoFill is ____ than copying and pasting.

Answer:

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

Answer:

cube

Question 27: Every function has to follow ____.

Answer:

syntax

Question 28: ____ arguments may provide more control over the returned value.

Answer:

optional