Question 1

The lookup value:

Accepted Answer

A) is the argument in a function that identifies which lookup table column from which to return a value. 
B) looks in a horizontal table where the first row contains the values. 
C) is a reference to a cell containing a value to look up. 
D) is a range containing a lookup table. 
A) is the argument in a function that identifies which lookup table column from which to return a value. 
B) looks in a horizontal table where the first row contains the values. 
C) is a reference to a cell containing a value to look up. 
D) is a range containing a lookup table.

Question 2

The =DATE(year,month,day)function returns a(n)________ for a date.

Accepted Answer

The answer of The =DATE(year,month,day)function returns a(n)________ for a date....

Question 3

If you change a range name,you must change all formulas that use that range name as well.

Accepted Answer

A) True 
 B)False

Question 4

Excel displays a red arrow in the top left corner of a cell if it detects a possible error.

Accepted Answer

A) True 
 B)False

Question 5

A circular reference occurs when a formula directly or indirectly refers to the cell containing the formula.

Accepted Answer

A) True 
 B)False

Question 6

For a straightforward,basic mathematical expression,it is best to use:

Accepted Answer

A) the arithmetic mean or average of values. 
B) a formula like =C16*C17. 
C) a function such as =SUM(B4:C4). 
D) a nested formula inside of a function. 
A) the arithmetic mean or average of values. 
B) a formula like =C16*C17. 
C) a function such as =SUM(B4:C4). 
D) a nested formula inside of a function.

Question 7

Describe how the following function works: =DAY(TODAY())

Accepted Answer

This is a nested function--a d

Question 8

What does a function ScreenTip do?

Accepted Answer

A) Automatically inserts functions such as SUM (B4:C4) 
B) Calculates the total of values contained in two or more cells 
C) Automatically inserts formulas such as =B4+C4 
D) Displays a small pop-up description of the arguments for a function as you enter it 
A) Automatically inserts functions such as SUM (B4:C4) 
B) Calculates the total of values contained in two or more cells 
C) Automatically inserts formulas such as =B4+C4 
D) Displays a small pop-up description of the arguments for a function as you enter it

Question 9

The ________ test is an IF function that tests for a true or false of a condition.

Accepted Answer

The answer of The ________ test is an IF function...

Question 10

When #NAME? displays in a cell,you may have:

Accepted Answer

A) used a range name that doesn't exist. 
B) used a worksheet name in the formula that does not exist. 
C) mistyped a workbook name in a function. 
D) mistyped the name of a function. 
A) used a range name that doesn't exist. 
B) used a worksheet name in the formula that does not exist. 
C) mistyped a workbook name in a function. 
D) mistyped the name of a function.

Question 11

A range name cannot include special characters or ________.

Accepted Answer

The answer of A range name cannot include special characters...

Question 12

The rate in a PMT function is:

Accepted Answer

A) the periodic interest rate,such as a monthly interest rate. 
B) the total number of payment rate periods. 
C) a word or a string of characters that represent one or more cells. 
D) the rate of present value of a loan. 
A) the periodic interest rate,such as a monthly interest rate. 
B) the total number of payment rate periods. 
C) a word or a string of characters that represent one or more cells. 
D) the rate of present value of a loan.

Question 13

________ is a set of analytical tools to use to apply formatting,create charts,and insert basic functions.

Accepted Answer

The answer of ________ is a set of analytical tools...

Question 14

Match between columns
                        Premises: =EDATE(start,_date,months)
=DAY(serial_number)
=DATE(year,month)
=TODAY()
=NOW()

Accepted Answer

The Answer of displays today's date and current military time is...

Question 15

The AVERAGE function can be used to calculate the student class average or a quiz or exam.

Accepted Answer

A) True 
 B)False

Question 16

When you decrease the decimal places that display in a cell,Excel rounds the value stored in that cell and uses the rounded value in calculations.

Accepted Answer

A) True 
 B)False

Question 17

Argument names that display in ________ are required;others are optional.

Accepted Answer

A) italic 
B) all caps 
C) red 
D) bold 
A) italic 
B) all caps 
C) red 
D) bold

Question 18

If a formula contains a reference to the cell containing a formula,a(n)________ reference exists.

Accepted Answer

The answer of If a formula contains a reference to...

Question 19

If you see #NAME? in a cell,what does it refer to and how might it be avoided?

Accepted Answer

A cell with #NAME? means that you might

Question 20

A table array for a lookup function is the range that contains the lookup table.

Accepted Answer

A) True 
 B)False

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

The lookup value:

The =DATE(year,month,day)function returns a(n)________ for a date.

If you change a range name,you must change all formulas that use that range name as well.

Excel displays a red arrow in the top left corner of a cell if it detects a possible error.

A circular reference occurs when a formula directly or indirectly refers to the cell containing the formula.

For a straightforward,basic mathematical expression,it is best to use:

Describe how the following function works: =DAY(TODAY())

What does a function ScreenTip do?

The ________ test is an IF function that tests for a true or false of a condition.

When #NAME? displays in a cell,you may have:

A range name cannot include special characters or ________.

The rate in a PMT function is:

________ is a set of analytical tools to use to apply formatting,create charts,and insert basic functions.

The AVERAGE function can be used to calculate the student class average or a quiz or exam.

When you decrease the decimal places that display in a cell,Excel rounds the value stored in that cell and uses the rounded value in calculations.

Argument names that display in ________ are required;others are optional.

If a formula contains a reference to the cell containing a formula,a(n)________ reference exists.

If you see #NAME? in a cell,what does it refer to and how might it be avoided?

A table array for a lookup function is the range that contains the lookup table.

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