Question 1

The PMT function calculates the breakpoint of the lowest value for a specific category.

Accepted Answer

A) True 
 B)False  False

Question 2

Formula AutoComplete:

Accepted Answer

A) results in formulas such as =B4+C4. 
B) calculates the total of values contained in two or more cells. 
C) is a small pop-up description that displays the arguments for a function as you enter it. 
D) displays a list of functions and defined names as you enter a function. 
A) results in formulas such as =B4+C4. 
B) calculates the total of values contained in two or more cells. 
C) is a small pop-up description that displays the arguments for a function as you enter it. 
D) displays a list of functions and defined names as you enter a function. D

Question 3

The ________ function calculates the periodic payment for a loan with interest.

Accepted Answer

PMT

Question 4

Excel 2013 contains more than 650 functions.

Accepted Answer

A) True 
 B)False

Question 5

You can choose to use range names in formulas that you create instead of cell references.

Accepted Answer

A) True 
 B)False

Question 6

The formula =C4*D4 uses only relative cell references.

Accepted Answer

A) True 
 B)False

Question 7

The ellipsis in function syntax indicates that:

Accepted Answer

A) you can add as many additional ranges as desired. 
B) the function has an error embedded in it. 
C) the function is part of the Logical function category. 
D) you are required to add additional ranges. 
A) you can add as many additional ranges as desired. 
B) the function has an error embedded in it. 
C) the function is part of the Logical function category. 
D) you are required to add additional ranges.

Question 8

A range name can contain 255 characters and must begin with a(n)________ or an underscore.

Accepted Answer

The answer of A range name can contain 255 characters...

Question 9

A range name can contain up to 450 characters and it must begin with a number.

Accepted Answer

A) True 
 B)False

Question 10

The SUM function:

Accepted Answer

A) identifies the midpoint value in a set of values. 
B) calculates the total of values contained in two or more cells. 
C) calculates the arithmetic mean or average of values in a range. 
D) displays the lowest value in a range. 
A) identifies the midpoint value in a set of values. 
B) calculates the total of values contained in two or more cells. 
C) calculates the arithmetic mean or average of values in a range. 
D) displays the lowest value in a range.

Question 11

One benefit of using range names is that if you copy the formula,you do not have to make the cell reference absolute in the formula.

Accepted Answer

A) True 
 B)False

Question 12

The ________ function totals the values in two or more cells and displays the result in the cell containing the function.

Accepted Answer

The answer of The ________ function totals the values in...

Question 13

The COUNTBLANK function:

Accepted Answer

A) tallies the number of blank cells in a range. 
B) highlights every blank cell in a range. 
C) displays the current date in every blank cell in a range. 
D) tallies the number of cells in a range that are not empty. 
A) tallies the number of blank cells in a range. 
B) highlights every blank cell in a range. 
C) displays the current date in every blank cell in a range. 
D) tallies the number of cells in a range that are not empty.

Question 14

You can use text within a formula.

Accepted Answer

A) True 
 B)False

Question 15

The ________ function finds the midpoint value of a list.

Accepted Answer

The answer of The ________ function finds the midpoint value...

Question 16

You can highlight a range and create a name for the range by clicking on the ________ tab.

Accepted Answer

The answer of You can highlight a range and create...

Question 17

When might you want to use an IF function in a worksheet?

Accepted Answer

If you have a situation that calls for a

Question 18

An argument is an operator such as an equal sign or a plus sign needed to complete a function.

Accepted Answer

A) True 
 B)False

Question 19

What is syntax and why is it important? Provide an example.

Accepted Answer

Syntax is the rules that dictate the str

Question 20

How many arguments are required for the SUM function?

Accepted Answer

A) 1 
B) 2 
C) 3 
D) It depends on the type of SUM function 
A) 1 
B) 2 
C) 3 
D) It depends on the type of SUM function

Exam 19: Excel: Formulas and Functions: Performing Quantitative Analysis

The PMT function calculates the breakpoint of the lowest value for a specific category.

Formula AutoComplete:

The ________ function calculates the periodic payment for a loan with interest.

Excel 2013 contains more than 650 functions.

You can choose to use range names in formulas that you create instead of cell references.

The formula =C4*D4 uses only relative cell references.

The ellipsis in function syntax indicates that:

A range name can contain 255 characters and must begin with a(n)________ or an underscore.

A range name can contain up to 450 characters and it must begin with a number.

The SUM function:

One benefit of using range names is that if you copy the formula,you do not have to make the cell reference absolute in the formula.

The ________ function totals the values in two or more cells and displays the result in the cell containing the function.

The COUNTBLANK function:

You can use text within a formula.

The ________ function finds the midpoint value of a list.

You can highlight a range and create a name for the range by clicking on the ________ tab.

When might you want to use an IF function in a worksheet?

An argument is an operator such as an equal sign or a plus sign needed to complete a function.

What is syntax and why is it important? Provide an example.

How many arguments are required for the SUM function?

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 : 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: Specialized Functions

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