Question 1

Date and time functions are used to format and work with cell contents.

Accepted Answer

A) True 
 B)False

Question 2

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,...

Question 3

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 4

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 5

In the IF function, the third 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

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 :

Date and time functions are used to format and work with cell contents.

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

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?

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

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

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.

Access Lesson 1: Microsoft Access Basics

Access Lesson 2: Creating a Database

Access Lesson 3: Creating Queries

Access Lesson 4: Creating and Modifying Forms

Access Lesson 5: Creating and Modifying Reports

Access Lesson 6: Integrating Access

Excel Lesson 1: Microsoft Excel Basics

Excel Lesson 2: Changing the Appearance of a Worksheet

Excel Lesson 3: Organizing the Worksheet

Excel Lesson 4: Entering Worksheet Formulas

Excel Lesson 6: Enhancing a Worksheet

Excel Lesson 7: Working With Multiple Worksheets and Workbooks

Excel Lesson 8: Working With Charts

Microsoft Office 2010 Basics and the Internet

Outlook Lesson 1: Outlook Basics and E-Mail

Outlook Lesson 2: Calendar

Outlook Lesson 3: Working With Other Outlook Tools

Powerpoint Lesson 1: Microsoft Powerpoint Basics

Powerpoint Lesson 2: Creating Enhancing Powerpoint Presentations

Powerpoint Lesson 3: Working With Visual Elements

Powerpoint Lesson 4: Expanding on Powerpoint Basics

Publisher Lesson 1: Microsoft Publisher Basics

Publisher Lesson 2: Enhancing Publisher Documents

Introduction Lesson 1: Microsoft Windows 7 Basics

Word Lesson 1: Microsoft Word Basics

Word Lesson 2: Basic Editing

Word Lesson 3: Helpful Word Features

Word Lesson 4: Formatting Text

Word Lesson 5: Formatting Paragraphs and Documents

Word Lesson 6: Working With Graphics

Word Lesson 7: Working With Documents

Word Lesson 8: Increasing Efficiency Using Word

Filters

Exam 11: Excel Lesson 5: Using Functions

Date and time functions are used to format and work with cell contents.

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

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?

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

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

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.

Access Lesson 1: Microsoft Access Basics

Access Lesson 2: Creating a Database

Access Lesson 3: Creating Queries

Access Lesson 4: Creating and Modifying Forms

Access Lesson 5: Creating and Modifying Reports

Access Lesson 6: Integrating Access

Excel Lesson 1: Microsoft Excel Basics

Excel Lesson 2: Changing the Appearance of a Worksheet

Excel Lesson 3: Organizing the Worksheet

Excel Lesson 4: Entering Worksheet Formulas

Excel Lesson 6: Enhancing a Worksheet

Excel Lesson 7: Working With Multiple Worksheets and Workbooks

Excel Lesson 8: Working With Charts

Microsoft Office 2010 Basics and the Internet

Outlook Lesson 1: Outlook Basics and E-Mail

Outlook Lesson 2: Calendar

Outlook Lesson 3: Working With Other Outlook Tools

Powerpoint Lesson 1: Microsoft Powerpoint Basics

Powerpoint Lesson 2: Creating Enhancing Powerpoint Presentations

Powerpoint Lesson 3: Working With Visual Elements

Powerpoint Lesson 4: Expanding on Powerpoint Basics

Publisher Lesson 1: Microsoft Publisher Basics

Publisher Lesson 2: Enhancing Publisher Documents

Introduction Lesson 1: Microsoft Windows 7 Basics

Word Lesson 1: Microsoft Word Basics

Word Lesson 2: Basic Editing

Word Lesson 3: Helpful Word Features

Word Lesson 4: Formatting Text

Word Lesson 5: Formatting Paragraphs and Documents

Word Lesson 6: Working With Graphics

Word Lesson 7: Working With Documents

Word Lesson 8: Increasing Efficiency Using Word

Filters