Question 1 

(TCO 9) What is the first argument of the IF function?

logical_test

Value_if_false

Value_if_true

Lookup_value

 

 

Question 2 

(TCO 9) If there are three possible outcomes, how many logical tests are required?

Four

Three

Two

One

 

 

Question 3 

(TCO 9) Which function will return the intersection of a specific row and column?

VLOOKUP

HLOOKUP

INDEX

MATCH

 

 

Question 4 

(TCO 9) Which of the following functions will return the principal payment of a loan?

CUMPRINC

PMT

IPMT

PPMT

 

 

Question 5 

(TCO 9) Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years?

FV

PV

NPV

PMT

 

 

Question 6 

(TCO 9) Which database function will return the smallest value from a dataset based on preset criteria?

DCOUNT

DSUM

DMIN

DMAX

 

 

Question 7 

(TCO 9) When using advanced filtering, < > is the equivalent of _____.

equal to

not equal to

greater than

an error

 

 

Question 8 

What is the maximum number of IF statements in a formula?

100

64

54

32

 

 

Question 9 

(TCO 9) Which of the following functions is best suited to count numbers based on multiple conditions?

SUMIF

SUMIFS

COUNTIF

COUNTIFS

 

 

 

 

Question 10 

(TCO 9) Which of the following functions will rank two values evenly if there is a duplicate value present?

RANK.EQ

RANK

RANK.AVG

PERCENTILE

 

 

Question 11 

(TCO 9) Which function is best suited to determine how the data set is spread around the mean?

COVARIANCE

CORREL

STDEV.P

VARA

 

 

Question 12 

(TCO 9) The Analysis ToolPak can be activated in _____.

Review tab

Developer tab

Excel Options

Formula tab

 

 

Question 13 

(TCO 9) When using the CORREL function, a value of .9187527 would indicate _____.

no relationship

an inverse relationship

a strong relationship

a weak relationship

 

 

Question 14 

(TCO 9) The Analysis ToolPak is an add-in program that provides statistical analysis tools. Which of the following can be performed by the Analysis ToolPak for analyzing a dataset?

SUM, SUMIF, Correlation

NOV, RANK

Correlation, F-Tests, T-Tests, Z-Tests and ANOVA

All tests are automatic with the ToolPak.

 

 

Question 15 

(TCO 9) The QUARTILE.INC function returns values for quartiles in the range _____.

0 to 3

0 to 4

1 to 4

1 to 3

SmartExpert

(118)

Status NEW Posted 26 Nov 2017 06:11 PM My Price 8.00

BIS----------- 15-----------5 W-----------eek----------- 5 -----------Qui-----------z-----------

Attachments

file 1511722280-BIS 155 Week 5 Quiz.docx preview (296 words )

B-----------IS -----------155----------- We-----------ek -----------5 Q-----------uiz----------- Q-----------ues-----------tio-----------n 1----------- -----------(TC-----------O 9-----------) W-----------hat----------- is----------- th-----------e f-----------irs-----------t a-----------rgu-----------men-----------t o-----------f t-----------he -----------IF -----------fun-----------cti-----------on?----------- l-----------ogi-----------cal-----------_te-----------stV-----------alu-----------e_i-----------f_f-----------als-----------eVa-----------lue-----------_if-----------_tr-----------ueL-----------ook-----------up_-----------val-----------ueQ-----------ues-----------tio-----------n 2----------- -----------(TC-----------O 9-----------) I-----------f t-----------her-----------e a-----------re -----------thr-----------ee -----------pos-----------sib-----------le -----------out-----------com-----------es,----------- ho-----------w m-----------any----------- lo-----------gic-----------al -----------tes-----------ts -----------are----------- re-----------qui-----------red-----------? -----------Fou-----------r -----------Thr-----------ee ----------- Tw-----------o -----------One----------- Q-----------ues-----------tio-----------n 3----------- -----------(TC-----------O 9-----------) W-----------hic-----------h f-----------unc-----------tio-----------n w-----------ill----------- re-----------tur-----------n t-----------he -----------int-----------ers-----------ect-----------ion----------- of----------- a -----------spe-----------cif-----------ic -----------row----------- an-----------d c-----------olu-----------mn?----------- V-----------LOO-----------KUP----------- H-----------LOO-----------KUP----------- I-----------NDE-----------X -----------MAT-----------CH ----------- Qu-----------est-----------ion----------- 4 ----------- (-----------TCO----------- 9)----------- Wh-----------ich----------- of----------- th-----------e f-----------oll-----------owi-----------ng

Not Rated(0)

• Buy Answer