Question 1

The ____________________(text) function converts the first letter of each word in the specified cell to uppercase and the rest to lowercase.

Accepted Answer

PROPER

Question 2

The ____ function replaces existing text in a specified cell with new text.

Accepted Answer

A)  FIND AND REPLACE 
B)  WRITE OVER 
C)  SUBSTITUTE 
D)  REPLACE 
A)  FIND AND REPLACE 
B)  WRITE OVER 
C)  SUBSTITUTE 
D)  REPLACE C

Question 3

The ____________________ is the value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand.

Accepted Answer

argument

Question 4

The rounding operation requires two arguments, which are separated by a comma.

Accepted Answer

A) True 
 B)False

Question 5

The function ____ returns the estimated variance of the numbers in the range.

Accepted Answer

A)  VAR(number1,number2...) 
B)  EVAR(number1,number2...) 
C)  ESTVAR(number1,number2...) 
D)  EV(number1,number2...) 
A)  VAR(number1,number2...) 
B)  EVAR(number1,number2...) 
C)  ESTVAR(number1,number2...) 
D)  EV(number1,number2...)

Question 6

=ROUND(142.3433,-2) returns 142.34 .

Accepted Answer

A) True 
 B)False

Question 7

____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell.

Accepted Answer

A)  Formula Complete 
B)  Formula Now 
C)  Formula Selector 
D)  Formula AutoComplete 
A)  Formula Complete 
B)  Formula Now 
C)  Formula Selector 
D)  Formula AutoComplete

Question 8

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to round some figures in a worksheet. The Round function is considered to be a _____ function.

Accepted Answer

A)  date and time 
B)  financial 
C)  mathematical 
D)  statistical 
A)  date and time 
B)  financial 
C)  mathematical 
D)  statistical

Question 9

Please briefly describe the DATE and NOW functions, including how the formula is written, any arguments involved, and a situation of when you would use that function: DATE and NOW.

Accepted Answer

- The DATE function: How it is written :

Question 10

Because Excel includes so many functions, the best way to select a function is from the Excel Help.

Accepted Answer

A) True 
 B)False

Question 11

The AND function returns the result of ____ if any or all of the arguments are false.

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  ERROR 
D)  none of the above 
A)  TRUE 
B)  FALSE 
C)  ERROR 
D)  none of the above

Question 12

A keyboard shortcut is a shorthand way to write an equation that performs a calculation.

Accepted Answer

A) True 
 B)False

Question 13

The ____ function returns the current date and time based on the computer's date and time settings.

Accepted Answer

A)  NOW( ) 
B)  WHEN( ) 
C)  CURRENT( ) 
D)  DATE( ) 
A)  NOW( ) 
B)  WHEN( ) 
C)  CURRENT( ) 
D)  DATE( )

Question 14

FIGURE EX 5-1   In Figure EX 5-1 above, the annual interest rate is ____.

Accepted Answer

A)  .015% 
B)  0.15% 
C)  1.5% 
D)  15% 
A)  .015% 
B)  0.15% 
C)  1.5% 
D)  15%

Question 15

In a PMT function, the argument indicated by fv refers to ____.

Accepted Answer

A)  future value 
B)  past value 
C)  favorite value 
D)  fixed value 
A)  future value 
B)  past value 
C)  favorite value 
D)  fixed value

Question 16

Logical functions can determine the average, standard deviation, or variance of a range of data.

Accepted Answer

A) True 
 B)False

Question 17

The selection is the body of numbers the statistics will describe.

Accepted Answer

A) True 
 B)False

Question 18

You must use double brackets to enclose the text you want the IF function to return in the second and third arguments.

Accepted Answer

A) True 
 B)False

Question 19

Some mathematical operations, such as addition, subtraction, multiplication, and division, do not require functions.

Accepted Answer

A) True 
 B)False

Question 20

The primary financial functions are future value, present value, and payment .

Accepted Answer

A) True 
 B)False

Exam 27: Using Functions

The ____________________(text) function converts the first letter of each word in the specified cell to uppercase and the rest to lowercase.

The ____ function replaces existing text in a specified cell with new text.

The ____________________ is the value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand.

The rounding operation requires two arguments, which are separated by a comma.

The function ____ returns the estimated variance of the numbers in the range.

=ROUND(142.3433,-2) returns 142.34 .

____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell.

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to round some figures in a worksheet. The Round function is considered to be a _____ function.

Please briefly describe the DATE and NOW functions, including how the formula is written, any arguments involved, and a situation of when you would use that function: DATE and NOW.

Because Excel includes so many functions, the best way to select a function is from the Excel Help.

The AND function returns the result of ____ if any or all of the arguments are false.

A keyboard shortcut is a shorthand way to write an equation that performs a calculation.

The ____ function returns the current date and time based on the computer's date and time settings.

FIGURE EX 5-1 In Figure EX 5-1 above, the annual interest rate is ____.

In a PMT function, the argument indicated by fv refers to ____.

Logical functions can determine the average, standard deviation, or variance of a range of data.

The selection is the body of numbers the statistics will describe.

You must use double brackets to enclose the text you want the IF function to return in the second and third arguments.

Some mathematical operations, such as addition, subtraction, multiplication, and division, do not require functions.

The primary financial functions are future value, present value, and payment .

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters