Question 1

Match between columns
                        Premises: statistical
financial
math & trig
logical
date & time

Accepted Answer

The Answer of SUM and IF and NOW and MAX is...

Question 2

If a cell included in a formula needs to remain unchanged when the formula is copied,use a(n)________.

Accepted Answer

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

Question 3

Users can create pseudocode to understand the logic of a problem before actually creating a formula.

Accepted Answer

A) True 
 B)False  True

Question 4

If you type a formula into a cell and instead of results you see a formula,it is because you have likely switched the Show Formulas feature on.

Accepted Answer

A) True 
 B)False

Question 5

A formula which states =B1*$B5 contains two ________ references.

Accepted Answer

The answer of A formula which states =B1*$B5 contains two...

Question 6

Named ranges make formulas easier to read.

Accepted Answer

A) True 
 B)False

Question 7

Which of the terms below would be most closely associated with the following formula:
=J1*H4

Accepted Answer

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

Question 8

If a cell in a formula should remain in the same column when copied,but change the row,use a(n)________.

Accepted Answer

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

Question 9

In this formula: =SUM(Sales),SUM is an example of a(n)________.

Accepted Answer

The answer of In this formula: =SUM(Sales),SUM is an example...

Question 10

Which of the terms below would be most closely associated with the following formula:
=Q$4/3

Accepted Answer

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

Question 11

The PMT function requires users to enter present value for an investment,known as the ________ field within the function.

Accepted Answer

The answer of The PMT function requires users to enter...

Question 12

All cell references MUST include a $ within the reference.

Accepted Answer

A) True 
 B)False

Question 13

A set of cells that have been given a label that can then be used within a formula or function is a(n)________ range.

Accepted Answer

The answer of A set of cells that have been...

Question 14

Cell references improve efficiency and flexibility,and allow easier updates to a spreadsheet.

Accepted Answer

A) True 
 B)False

Question 15

Including actual data in a formula is known as ________ the values.

Accepted Answer

The answer of Including actual data in a formula is...

Question 16

Which of the following formulas contains a hard-coded value?

Accepted Answer

A)  =SUM(J1:J3) 
B)  =$F$4*$F$5 
C)  =AVERAGE(Sales) 
D)  =F1*0.07 
A)  =SUM(J1:J3) 
B)  =$F$4*$F$5 
C)  =AVERAGE(Sales) 
D)  =F1*0.07

Question 17

The formula below contains a hard-coded value.
=B3*8.85

Accepted Answer

A) True 
 B)False

Question 18

A rough draft of a formula or code is also known as ________.

Accepted Answer

The answer of A rough draft of a formula or...

Question 19

The Statistical Function Category is used when working with ________ calculations.

Accepted Answer

The answer of The Statistical Function Category is used when...

Question 20

Match between columns
                        Premises: named range
absolute reference
hard-coding
mixed reference
relative reference

Accepted Answer

The Answer of =$A$1 and =12*7% and =J7 and =SUM(Sales) is...

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

If a cell included in a formula needs to remain unchanged when the formula is copied,use a(n)________.

Users can create pseudocode to understand the logic of a problem before actually creating a formula.

If you type a formula into a cell and instead of results you see a formula,it is because you have likely switched the Show Formulas feature on.

A formula which states =B1*$B5 contains two ________ references.

Named ranges make formulas easier to read.

Which of the terms below would be most closely associated with the following formula: =J1*H4

If a cell in a formula should remain in the same column when copied,but change the row,use a(n)________.

In this formula: =SUM(Sales),SUM is an example of a(n)________.

Which of the terms below would be most closely associated with the following formula: =Q$4/3

The PMT function requires users to enter present value for an investment,known as the ________ field within the function.

All cell references MUST include a $ within the reference.

A set of cells that have been given a label that can then be used within a formula or function is a(n)________ range.

Cell references improve efficiency and flexibility,and allow easier updates to a spreadsheet.

Including actual data in a formula is known as ________ the values.

Which of the following formulas contains a hard-coded value?

The formula below contains a hard-coded value. =B3*8.85

A rough draft of a formula or code is also known as ________.

The Statistical Function Category is used when working with ________ calculations.

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