Exam 3 Study Materials PDF

Preview

Summary

Download Exam 3 Study Materials PDF

Description

Question 1



0 out of 1 points

The PERCENTRANK.INC function excludes 0 and 1. Correct Answer:

Fals e

Question 2



0 out of 1 points

The maximum number of IF statements in one formula is 64. Correct Answer:

Tru e

Question 3



0 out of 1 points

When using the QUARTILE.INC function which quartile would include the highest value in the dataset? Correct Answer:

4 Question 4



1 out of 1 points

All database functions require a user defined: Correct Answer:



criteria range. Question 5 0 out of 1 points

The MATCH function will return a value of 1 if the given lookup_value is the largest number in an array of numbers. Correct Answer:

Tru e

Question 6



0 out of 1 points

Which of the following functions will rank two values evenly if there is a duplicate value present? Correct Answer:



RANK.E Q Question 7 1 out of 1 points

Histograms can be created on a separate worksheet when using the Analysis ToolPak. Correct Answer:



Tru e

Question 8 1 out of 1 points

When using the CORREL function a value of 1 would indicate:

Correct Answer:

a strong relationship. Question 9



1 out of 1 points

Worksheets can be hidden to help manage available screen space when dealing with large files. Correct Answer:



a.

Tru e Question 10 1 out of 1 points

Which of the following would cause the error #DIV/0! to appear? Correct Answer:

b.

Formula attempts to divide a value by zero or an empty cell Question 11



1 out of 1 points

In Excel, hyperlinks appear as: Correct Answer:



a.

blue text with a blue underline. Question 12 1 out of 1 points

When using the QUARTILE.INC function which quartile would include the lowest value in the dataset? Correct Answer:



0 Question 13 1 out of 1 points

Which of the following functions does NOT contain a syntax error? Correct Answer:



d.

=AVERAGE(B1:B 9) Question 14 1 out of 1 points

Which of the following functions is best suited to calculate the covariance of a population? Correct Answer:



COVARIANCE. P Question 15 1 out of 1 points

Which of the following is NOT an option when arranging windows? Correct Answer:



c.

Stack ed Question 16 1 out of 1 points

When using the CORREL function, a value of .00007 would indicate: Correct Answer:



a weak relationship. Question 17 1 out of 1 points

When using Advanced Filtering < > is the equivalent of: Correct Answer:



not equal to. Question 18 0 out of 1 points

If a nested IF statement has 6 possible outcomes it requires ________ logical tests. Correct Answer:

5 Question 19



1 out of 1 points

Which of the following functions will determine the standard deviation of a sample? Correct Answer:



STDEV. S Question 20 0 out of 1 points

When using Advanced Filtering, the criteria range must contain at least: Correct Answer:



two rows. Question 21 0 out of 1 points

Dependent cells contain formulas independent of other cells. Correct Answer:



b.

Fals e Question 22

1 out of 1 points

The RATE function returns the periodic rate for an investment or loan. Correct Answer:

Tru e

Question 23



0 out of 1 points

To group all worksheets: Correct Answer:



c.

right-click a worksheet tab and click Select All Sheets. Question 24 1 out of 1 points

COVARIANCE.S determines how two sets of data from a sample vary simultaneously. Correct Answer:

Tru e

Question 25



1 out of 1 points

Which of the following functions requires all arguments to be true in order to return the value if true? Correct Answer:



AN D Question 26 0 out of 1 points

Which of the following is NOT a way to remove panes from a window that has been split? Correct Answer:



d.

Click Remove Split in the View tab Question 27 1 out of 1 points

What error will cause #NUM! to appear? Correct Answer:



a.

Invalid arguments in a function Question 28 1 out of 1 points

Which of the following is a nested function? Correct Answer:



=IF(AND(B7>5),"Yes"," No") Question 29 0 out of 1 points

3-D formulas automatically update when data is added. Correct Answer:



a.

Tru e Question 30 0 out of 1 points

Which of the following is NOT a formula auditing tool? Correct Answer:



c.

Calculation Options Question 31 1 out of 1 points

The criteria range of a database function must contain at least one column heading and one cell of information. Correct Answer:

Tru e

Question 32



0 out of 1 points

The database argument of any database function requires the selection of the entire table. Correct Answer:

Tru e

Question 33



0 out of 1 points

When active, where does the Analysis ToolPak appear? Correct Answer:



Data tab Question 34 1 out of 1 points

Which function would be best used to determine the rank of each student in a graduating high school class? Correct Answer:



RANK.E Q Question 35 0 out of 1 points

The split bar gives the user the ability to view two different workbooks simultaneously. Correct Answer:



b.

Fals e Question 36

1 out of 1 points

A PMT of zero can be used in the FV function. Correct Answer:

Tru e

Question 37



0 out of 1 points

To complete a FREQUENCY function using an array the keystroke Ctrl+Enter must be used. Correct Answer:

Fals e

Question 38



1 out of 1 points

What happens if you rename the source file of a worksheet that is used in an external reference? Correct Answer:



c.

The linked data will appear in red text. Question 39 0 out of 1 points

The NPER function would be best used to determine the periodic interest rate of an investment. Correct Answer:

Fals e

Question 40



1 out of 1 points

What is the first argument of the IF function? Correct Answer:



logical_t est Question 41 1 out of 1 points

When the DAVERAGE function returns #DIV/0: Correct Answer:



there are no records that fit the criteria. Question 42 0 out of 1 points

Which of the following would cause the error #VALUE! to appear? Correct Answer:



c.

Incorrect data used in an argument Question 43 1 out of 1 points

What is the proper format of an external reference to a workbook or

worksheet thats name does not contains spaces; source and destination files are in the same folder. Correct Answer:



b.

[WorkbookName]Workshee t!Cell Question 44 0 out of 1 points

What does the order argument of the RANK.EQ function define? Correct Answer:



The order in which numbers are ranked Question 45 1 out of 1 points

Which of the following has the ability to restrict data view to only information that fits predetermined criteria? Correct Answer:



Advanced Filter Question 46 0 out of 1 points

Which function will calculate the periodic interest rate of a loan with a $500 payment on a $20000 loan paid back over 5 years? Correct Answer:

RATE Question 47



0 out of 1 points

Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population? Correct Answer:



ANOVA Question 48 1 out of 1 points

Which of the following is NOT a statistical function? Correct Answer:



DSU M Question 49 1 out of 1 points

Unvisited hyperlinks appear blue with a blue underline. Correct Answer:

a.

Tru e

Question 50



1 out of 1 points

By default the Analysis ToolPak is active. Correct Answer:

Fals e

Question 1



1 out of 1 points

Which of the following functions will return the interest payment of a loan? Correct Answer:

IPMT Question 2



1 out of 1 points

Which of the following is NOT included in an ANOVA summary report? Correct Answer:



T F Question 3 0 out of 1 points

Which of the following logical functions will return a value if false if one of the arguments is false? Correct Answer:

AN D Question 4



1 out of 1 points

When created using the Analysis ToolPak, histograms cannot be deleted. Correct Answer:

Fals e

Question 5



1 out of 1 points

In order for the NOT function to return a true value, all arguments must be false. Correct Answer:

Tru e

Question 6



0 out of 1 points

Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years? Correct Answer:



FV Question 7 1 out of 1 points

What is the second argument of the IF function?

Correct Answer:

Value_if_tr ue Question 8



1 out of 1 points

Which database function will return the largest value from a dataset based on preset criteria? Correct Answer:



DMAX Question 9 0 out of 1 points

If the formula =B2*B3 is located in cell C3, which cell is NOT a precedent? Correct Answer:



a.

C3 Question 10 1 out of 1 points

Which of the following functions is best suited to count numbers based on multiple conditions? Correct Answer:



COUNTIF S Question 11 1 out of 1 points

Which of the following is NOT a way to remove panes from a window that has been split? Correct Answer:



d.

Click Remove Split in the View tab Question 12 1 out of 1 points

Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population? Correct Answer:



ANOVA Question 13 1 out of 1 points

When using an array of data with the FREQUENCY function, the following keystroke is required. Correct Answer:



Ctrl+Shift+E nter Question 14 1 out of 1 points

VARPA calculates the variance of a population including logical values and text. Correct Answer:

Tru e

Question 15



0 out of 1 points

When is the input message displayed in a cell that contains a validation rule? Correct Answer:



b.

When the cell is clicked Question 16 0 out of 1 points

What is the proper format of an external reference to a workbook or worksheet thats name contains spaces; source and destination files are in the same folder? Correct Answer:



d.

'[WorkbookName]Workshee t'!Cell Question 17 0 out of 1 points

Conditional formatting can be applied to a set of grouped worksheets. Correct Answer:



b.

Fals e Question 18 0 out of 1 points

Which function will calculate the current value on an investment that will earn 5% interest on yearly payments of $100 over 10 years? Correct Answer:

P V Question 19



1 out of 1 points

The NPER function would be best used to determine the periodic interest rate of an investment. Correct Answer:

Fals e

Question 20



1 out of 1 points

=INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1) is an example of a nested function. Correct Answer:



Tru e

Question 21

1 out of 1 points

Which of the following will determine the variance of a population? Correct Answer:



VAR.P Question 22 1 out of 1 points

=IF(E5C6,"Yes"," No") Question 40 1 out of 1 points

Which of the following actions will open another window of the current workbook? Correct Answer:



b.

Click the View tab, and then click New Window in the Window group Question 41 1 out of 1 points

Which of the following is NOT a function for measuring central tendency? Correct Answer:



SUMIF S Question 42 1 out of 1 points

A hyperlink cannot be used to access an e-mail address. Correct Answer:



b.

Fals e Question 43 0 out of 1 points

The FREQUENCY function can count words.

Correct Answer:

Fals e

Question 44



0 out of 1 points

Which of the following functions does NOT base its calculations on data samples? Correct Answer:

VARPA Question 45



0 out of 1 points

Which function is best suited to determine a student's test score percentile based on all class scores? Correct Answer:



PERCENTRANK.EX C Question 46 1 out of 1 points

COVARIANCE.S determines how two sets of data from a sample vary simultaneously. Correct Answer:

Tru e

Question 47



0 out of 1 points

When worksheets are grouped all structural changes will be copied across worksheets. Correct Answer:



a.

Tru e Question 48 1 out of 1 points

When using the QUARTILE.INC function which quartile would include the highest value in the dataset? Correct Answer:



4 Question 49 1 out of 1 points

The first argument of the INDEX function is: Correct Answer:



arra y. Question 50 1 out of 1 points

A 3-D reference is a pointer to a cell in another worksheet.

Correct Answer:

a.

Tru e Question 1



0 out of 1 points

When using Advanced Filtering empty cells in the criteria range will return which of the following? Correct Answer:



All records Question 2 1 out of 1 points

When using Advanced Filtering, the criteria range must contain at least: Correct Answer:

two rows. Question 3



1 out of 1 points

What does the order argument of the RANK.EQ function define? Correct Answer:



The order in which numbers are ranked Question 4 1 out of 1 points

Which of the following functions will determine the standard deviation of a sample? Correct Answer:



STDEV. S Question 5 1 out of 1 points

In the formula =B2*B3 is located in cell C3, which cell is the dependent cell? Correct Answer:



c.

C3 Question 6 0 out of 1 points

CUMIPMT calculates the cumulative interest throughout a loan. Correct Answer:



Tru e

Question 7 1 out of 1 points

Conditional formatting can be applied to a set of grouped worksheets.

Correct Answer:

b.

Fals e Question 8



1 out of 1 points

Which of the following is true when synchronize scrolling is enabled? Correct Answer:



a.

Side by side worksheets will scroll at the same rate. Question 9 1 out of 1 points

What is the proper format of an external reference to a workbook or worksheet thats name does not contains spaces; source and destination files are in the same folder. Correct Answer:

b.

[WorkbookName]Workshee t!Cell Question 10



1 out of 1 points

VARPA calculates the variance of a population including logical values and text. Correct Answer:

Tru e

Question 11



1 out of 1 points

In Excel, hyperlinks appear as: Correct Answer:



a.

blue text with a blue underline. Question 12 1 out of 1 points

Which function is best suited to calculate quartiles including quartiles 0 and 4? Correct Answer:



QUARTILE.IN C Question 13 1 out of 1 points

VAR.P is included in the Analysis ToolPak. Correct Answer:



Fals e

Question 14 1 out of 1 points

All database functions require a user defined: Correct Answer:



criteria range. Question 15 1 out of 1 points

To ungroup worksheets: Correct Answer:



a.

click a worksheet tab for a sheet that is not grouped. Question 16 1 out of 1 points

When using the QUARTILE.INC function which quartile would include the lowest value in the dataset? Correct Answer:



0 Question 17 1 out of 1 points

To group adjacent worksheets: Correct Answer:

b.

click the first worksheet tab, press and hold Shift, and then click the last worksheet tab. Question 18



1 out of 1 points

Which of the following functions will use average values to determine the rank of a number within a list if duplicate values are present? Correct Answer:



RANK.AVG Question 19 1 out of 1 points

If there are four possible outcomes, how many logical tests are required? Correct Answer:



3 Question 20 1 out of 1 points

Which of the following functions requires all arguments to be true in order to return the value if true? Correct Answer:



AN D Question 21 1 out of 1 points

Which of the following actions will open another window of the current workbook? Correct Answer:



b.

Click the View tab, and then click New Window in the Window group Question 22 1 out of 1 points

Which of the following functions is best suited to calculate the variance of a population including logical values and text? Correct Answer:



VARPA Question 23 1 out of 1 points

STDEV.P should be used to calculate standard deviation when all data for a population is present. Correct...