Question 1

In order to display only the current date,use the ________ function.

Accepted Answer

A)  DAY 
B)  DATE 
C)  NOW 
D)  TODAY 
A)  DAY 
B)  DATE 
C)  NOW 
D)  TODAY

Question 2

Which of the following is NOT a type of cell reference?

Accepted Answer

A)  relative 
B)  mixed 
C)  absolute 
D)  formula 
A)  relative 
B)  mixed 
C)  absolute 
D)  formula

Question 3

Which of the terms below would be most closely associated with the following formula:
=SUM(Quantities)

Accepted Answer

A)  mixed reference 
B)  named range 
C)  relative reference 
D)  absolute reference 
A)  mixed reference 
B)  named range 
C)  relative reference 
D)  absolute reference

Question 4

The structure and order of the function,and the arguments needed for Excel to run a function,are known as the ________ of the function.

Accepted Answer

The answer of The structure and order of the function,and...

Question 5

Some functions have optional arguments that can remain blank.

Accepted Answer

A) True 
 B)False

Question 6

SUM,MIN,and MAX are examples of Excel functions.

Accepted Answer

A) True 
 B)False

Question 7

To perform a comparison and make a decision based on that decision,use a ________ function.

Accepted Answer

A)  logical 
B)  math & trig 
C)  statistical 
D)  financial 
A)  logical 
B)  math & trig 
C)  statistical 
D)  financial

Question 8

Hard-coding values,like sales tax in a formula,is generally preferable to using cell references.

Accepted Answer

A) True 
 B)False

Question 9

Which of the terms below would be most closely associated with the following formula:
=$J1+44

Accepted Answer

A)  mixed reference 
B)  absolute reference 
C)  named range 
D)  relative reference 
A)  mixed reference 
B)  absolute reference 
C)  named range 
D)  relative reference

Question 10

Which of the following is a valid name for a range?

Accepted Answer

A)  2011Sales 
B)  S2011 
C)  Sales_2011 
D)  All are valid names for named ranges. 
A)  2011Sales 
B)  S2011 
C)  Sales_2011 
D)  All are valid names for named ranges.

Question 11

The structure and order of a function and its arguments is also known as the function's ________.

Accepted Answer

A)  reference 
B)  syntax 
C)  range 
D)  pseudocode 
A)  reference 
B)  syntax 
C)  range 
D)  pseudocode

Question 12

All arguments MUST be separated by commas.

Accepted Answer

A) True 
 B)False

Question 13

The PMT function's first argument is the periodic interest ________ of the loan.

Accepted Answer

The answer of The PMT function's first argument is the...

Question 14

A named range can be a single cell.

Accepted Answer

A) True 
 B)False

Question 15

A(n)________ is a named calculation where Excel calculates the output based on the input provided.

Accepted Answer

The answer of A(n)________ is a named calculation where Excel...

Question 16

Which of the terms below would be most closely associated with the following formula:
=100*$B$7

Accepted Answer

A)  named range 
B)  absolute reference 
C)  relative reference 
D)  mixed reference 
A)  named range 
B)  absolute reference 
C)  relative reference 
D)  mixed reference

Question 17

A(n)________ allows a cell's row and column to change when copied.

Accepted Answer

A)  relative reference 
B)  named range 
C)  mixed reference 
D)  absolute reference 
A)  relative reference 
B)  named range 
C)  mixed reference 
D)  absolute reference

Question 18

In order to simplify a formula,users can replace cell ranges such as J2:J5 with a(n)________.

Accepted Answer

A)  relative reference 
B)  absolute reference 
C)  named range 
D)  mixed reference 
A)  relative reference 
B)  absolute reference 
C)  named range 
D)  mixed reference

Question 19

Loan payment calculations and net present value calculations are formulas found in the ________ category of functions.

Accepted Answer

A)  logical 
B)  statistical 
C)  financial 
D)  math & trig 
A)  logical 
B)  statistical 
C)  financial 
D)  math & trig

Question 20

Which of the following is the function in the following formula:
=AVERAGE(E2:E5)

Accepted Answer

A)  = 
B)  E2:E5 
C)  AVERAGE 
D)  None of the above are functions. 
A)  = 
B)  E2:E5 
C)  AVERAGE 
D)  None of the above are functions.

Exam 11: Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

In order to display only the current date,use the ________ function.

Which of the following is NOT a type of cell reference?

Which of the terms below would be most closely associated with the following formula: =SUM(Quantities)

The structure and order of the function,and the arguments needed for Excel to run a function,are known as the ________ of the function.

Some functions have optional arguments that can remain blank.

SUM,MIN,and MAX are examples of Excel functions.

To perform a comparison and make a decision based on that decision,use a ________ function.

Hard-coding values,like sales tax in a formula,is generally preferable to using cell references.

Which of the terms below would be most closely associated with the following formula: =$J1+44

Which of the following is a valid name for a range?

The structure and order of a function and its arguments is also known as the function's ________.

All arguments MUST be separated by commas.

The PMT function's first argument is the periodic interest ________ of the loan.

A named range can be a single cell.

A(n)________ is a named calculation where Excel calculates the output based on the input provided.

Which of the terms below would be most closely associated with the following formula: =100*$B$7

A(n)________ allows a cell's row and column to change when copied.

In order to simplify a formula,users can replace cell ranges such as J2:J5 with a(n)________.

Loan payment calculations and net present value calculations are formulas found in the ________ category of functions.

Which of the following is the function in the following formula: =AVERAGE(E2:E5)

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters