Question 1

Date and time functions can be used to convert serial numbers to a ____.

Accepted Answer

A)  month 
B)  day 
C)  year 
D)  all of the above 
A)  month 
B)  day 
C)  year 
D)  all of the above

Question 2

If you know the function you want to enter, you can click the appropriate category button in the ____ group on the Formulas tab of the Ribbon.

Accepted Answer

A)  Function Library 
B)  Formula 
C)  Data 
D)  Calculations 
A)  Function Library 
B)  Formula 
C)  Data 
D)  Calculations

Question 3

Match between columns
                        Premises: Functions used to describe large quantities of data.
Functions that are used to format and work with cell contents.
Functions used to analyze loans and investments.
Functions, such as the square root functions, that manipulate quantitative data in a worksheet.
Functions that are used to insert dates and times in a worksheet.

Accepted Answer

The Answer of Date and time functions and Financial functions is...

Question 4

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. Cheryl has found the formula she wants to use by using Formula AutoComplete. How can she access a Screen Tip to guide her in entering the necessary arguments?

Accepted Answer

A)  Double-click the name of the function 
B)  Double-click anywhere inside the worksheet 
C)  Double-click anywhere outside the worksheet 
D)  None of the above 
A)  Double-click the name of the function 
B)  Double-click anywhere inside the worksheet 
C)  Double-click anywhere outside the worksheet 
D)  None of the above

Question 5

In the IF function, the second argument determines the value that appears in the cell if the logical test is ____.

Accepted Answer

A)  false 
B)  true 
C)  an error 
D)  none of the above 
A)  false 
B)  true 
C)  an error 
D)  none of the above

Question 6

In the IF function, the first argument sets a condition for comparison, called a relative test.

Accepted Answer

A) True 
 B)False

Question 7

FIGURE EX 5-1   In Figure EX 5-1 above, the Pmt figure is -250. The negative number means ____.

Accepted Answer

A)  the entry is income 
B)  the entry is a payment 
C)  there is an error 
D)  the person is behind on their payments 
A)  the entry is income 
B)  the entry is a payment 
C)  there is an error 
D)  the person is behind on their payments

Question 8

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. What should Cheryl do to access Formula AutoComplete to help her write her formulas?

Accepted Answer

A)  Type the first letters in a cell 
B)  Click Formula AutoComplete on the Ribbon 
C)  Open the AutoComplete Wizard by right-clicking on the active cell 
D)  None of the above 
A)  Type the first letters in a cell 
B)  Click Formula AutoComplete on the Ribbon 
C)  Open the AutoComplete Wizard by right-clicking on the active cell 
D)  None of the above

Question 9

The ____ function repeats the text in the specified cell a specified number of times.

Accepted Answer

A)  MIRROR 
B)  REPT 
C)  AGAIN 
D)  OVER 
A)  MIRROR 
B)  REPT 
C)  AGAIN 
D)  OVER

Question 10

If a function contains more than one argument, semicolons separate the arguments.

Accepted Answer

A) True 
 B)False

Question 11

You can enter a formula with the AVERAGE, COUNT, MAX, or MIN function in a selected cell by clicking the Sum button arrow in the ____ group on the Home tab, clicking the function name, selecting the appropriate range, and then pressing the Enter key.

Accepted Answer

A)  Editing 
B)  Formulas 
C)  Cells 
D)  Worksheet 
A)  Editing 
B)  Formulas 
C)  Cells 
D)  Worksheet

Question 12

The IFERROR function is written as ____.

Accepted Answer

A)  IFERROR(value_if_error,value) 
B)  IFERROR(value,value_if_error) 
C)  IFERROR(value_if_error) 
D)  IFERROR(value) 
A)  IFERROR(value_if_error,value) 
B)  IFERROR(value,value_if_error) 
C)  IFERROR(value_if_error) 
D)  IFERROR(value)

Question 13

You can use the SUM function to total the values stored in up to 255 non-adjacent cells or ranges.

Accepted Answer

A) True 
 B)False

Question 14

An example of the function that returns the number of cells in a range of cells that contain data is ____.

Accepted Answer

A)  =NUMBER(B4) 
B)  =COUNT(B4) 
C)  =NUMBER(B4:B15) 
D)  =COUNT(B4:B15) 
A)  =NUMBER(B4) 
B)  =COUNT(B4) 
C)  =NUMBER(B4:B15) 
D)  =COUNT(B4:B15)

Question 15

When you type =s , all functions that begin with the letter s appear in the list box, such as SEARCH, SECON, and SERISSUM.

Accepted Answer

A) True 
 B)False

Question 16

An example of a square root function written correctly is ____.

Accepted Answer

A)  SQRT(C4) 
B)  =SQROOT(C4) 
C)  =SQRT(C4) 
D)  SQROOT(C4) 
A)  SQRT(C4) 
B)  =SQROOT(C4) 
C)  =SQRT(C4) 
D)  SQROOT(C4)

Question 17

The monthly interest rate is determined by dividing the annual interest rate by 12 ____________________.

Accepted Answer

The answer of The monthly interest rate is determined by...

Question 18

The present value of a loan based on equal payments is written as ____.

Accepted Answer

A)  PV(rate,nper,pmt,fv,type) 
B)  PVAL(rate,nper,pmt,fv,type) 
C)  PV(rate,nper,pmt,term) 
D)  PVAL(rate,nper,pmt,term) 
A)  PV(rate,nper,pmt,fv,type) 
B)  PVAL(rate,nper,pmt,fv,type) 
C)  PV(rate,nper,pmt,term) 
D)  PVAL(rate,nper,pmt,term)

Question 19

You can use the Insert Function dialog box to find a specific function. In the ____ box, type a brief description of what you want to do. Then, click Go.

Accepted Answer

A)  Directory 
B)  Find what 
C)  Search for a function 
D)  Go to 
A)  Directory 
B)  Find what 
C)  Search for a function 
D)  Go to

Question 20

As an example of a financial function, =____________________(.1,5,-500) displays the current value of five payments of $500 at a 10% interest rate.

Accepted Answer

The answer of As an example of a financial function,...

Exam 27: Using Functions

Date and time functions can be used to convert serial numbers to a ____.

If you know the function you want to enter, you can click the appropriate category button in the ____ group on the Formulas tab of the Ribbon.

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. Cheryl has found the formula she wants to use by using Formula AutoComplete. How can she access a Screen Tip to guide her in entering the necessary arguments?

In the IF function, the second argument determines the value that appears in the cell if the logical test is ____.

In the IF function, the first argument sets a condition for comparison, called a relative test.

FIGURE EX 5-1 In Figure EX 5-1 above, the Pmt figure is -250. The negative number means ____.

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. What should Cheryl do to access Formula AutoComplete to help her write her formulas?

The ____ function repeats the text in the specified cell a specified number of times.

If a function contains more than one argument, semicolons separate the arguments.

You can enter a formula with the AVERAGE, COUNT, MAX, or MIN function in a selected cell by clicking the Sum button arrow in the ____ group on the Home tab, clicking the function name, selecting the appropriate range, and then pressing the Enter key.

The IFERROR function is written as ____.

You can use the SUM function to total the values stored in up to 255 non-adjacent cells or ranges.

An example of the function that returns the number of cells in a range of cells that contain data is ____.

When you type =s , all functions that begin with the letter s appear in the list box, such as SEARCH, SECON, and SERISSUM.

An example of a square root function written correctly is ____.

The monthly interest rate is determined by dividing the annual interest rate by 12 ____________________.

The present value of a loan based on equal payments is written as ____.

You can use the Insert Function dialog box to find a specific function. In the ____ box, type a brief description of what you want to do. Then, click Go.

As an example of a financial function, =____________________(.1,5,-500) displays the current value of five payments of $500 at a 10% interest rate.

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