Match between columns Premises: OR NOT Nested function AND IF

The Answer of A function to test if no arguments is...

Match between columns Premises: > =

The Answer of Less than and Not equal to and is...

Match between columns Premises: NOT OR IF INDEX AND

The Answer of A function that tests if one argument is...

Exam 24: Excel: Specialized Functions

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

Free

(True/False)

5.0/5

(33)

Question 1

Correct Answer:

Verified

True

________ calculates the standard deviation of a sample population.

Free

(Short Answer)

4.8/5

(32)

Question 2

Correct Answer:

Verified

DSTDEV

Which of the following functions returns a value or the reference to a value within a range based on X and Y coordinates?

Free

(Multiple Choice)

4.7/5

(32)

Question 3

Correct Answer:

Verified

B

The CUMPRINC function requires both starting and ending evaluation dates.

(True/False)

5.0/5

(34)

Question 4

Match the following terms with the corresponding description.

OR

A function to test if no arguments are met

NOT

A function to test if at least one or more conditions are met

Nested function

A function that is embedded within an argument of another function

Correct Answer:

Verified

OR

NOT

Nested function

AND

IF

(Matching)

4.9/5

(36)

Question 5

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

(Multiple Choice)

4.7/5

(42)

Question 6

Match the following terms with the corresponding description.

>

Less than

<

Not equal to

>=

Greater than

Correct Answer:

Verified

>

<

>=

<=

< >

(Matching)

4.8/5

(38)

Question 7

The ________ function returns the position of a value in a list.

(Short Answer)

4.9/5

(32)

Question 8

Which database function should be used to count records with empty cells?

(Multiple Choice)

4.8/5

(39)

Question 9

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

(Multiple Choice)

4.9/5

(35)

Question 10

If no values exist in the logical argument,the AND function returns the #VALUE! error.

(True/False)

4.8/5

(41)

Question 11

A(n)________ is a schedule that calculates the interest,principal repayment,and remaining balance of a loan.

(Short Answer)

4.7/5

(32)

Question 12

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

(True/False)

4.8/5

(29)

Question 13

The first argument of the INDEX function is:

(Multiple Choice)

4.9/5

(34)

Question 14

If payments are made at the end of the month the type argument should be set to ________ when using the IPMT function

(Short Answer)

4.7/5

(37)

Question 15

Which of the following functions will return the principal payment of a loan?

(Multiple Choice)

4.8/5

(31)

Question 16

Match the following functions with the corresponding description.

NOT

A function that tests if one argument is met

OR

Returns a value or the reference to a value within a range based on X and Y coordinates

IF

A function to test if no arguments are met

Correct Answer:

Verified

NOT

OR

IF

INDEX

AND

(Matching)

4.9/5

(42)

Question 17

Advanced filtering will not copy results to a new location.

(True/False)

4.8/5

(33)

Question 18

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

(Multiple Choice)

4.9/5

(29)

Question 19

Which of the following functions has the ability to copy all results to a new location?

(Multiple Choice)

4.8/5

(30)

Question 20

Exam 24: Excel: Specialized Functions

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

________ calculates the standard deviation of a sample population.

Which of the following functions returns a value or the reference to a value within a range based on X and Y coordinates?

The CUMPRINC function requires both starting and ending evaluation dates.

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

The ________ function returns the position of a value in a list.

Which database function should be used to count records with empty cells?

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

If no values exist in the logical argument,the AND function returns the #VALUE! error.

A(n)________ is a schedule that calculates the interest,principal repayment,and remaining balance of a loan.

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

The first argument of the INDEX function is:

If payments are made at the end of the month the type argument should be set to ________ when using the IPMT function

Which of the following functions will return the principal payment of a loan?

Advanced filtering will not copy results to a new location.

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

Which of the following functions has the ability to copy all results to a new location?

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters