Question 1

The Show Formulas view is when cells display the formulas instead of the output.

Accepted Answer

A) True 
 B)False

Question 2

To switch to the Show Formulas view,hold the Ctrl key and press the $ key.

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: third
first
fifth
fourth
second

Accepted Answer

The Answer of equal sign (=) and opening parenthesis and is...

Question 4

Which of the following is TRUE about hard-coded values?

Accepted Answer

A)  In the formula =J5*12 the 12 is a hard-coded value. 
B)  A formula such as =P1*Q2 contains a hard-coded value. 
C)  Hard-coding is recommended when you have a value that may change. 
D)  Hard-coding makes it easier to update data and adapt to change. 
A)  In the formula =J5*12 the 12 is a hard-coded value. 
B)  A formula such as =P1*Q2 contains a hard-coded value. 
C)  Hard-coding is recommended when you have a value that may change. 
D)  Hard-coding makes it easier to update data and adapt to change.

Question 5

There are two methods for creating functions: typing in the function and through the Functions ________ dialog box.

Accepted Answer

The answer of There are two methods for creating functions:...

Question 6

Which of the following is the argument in the following formula:
=SUM(J2:J4)

Accepted Answer

A)  = 
B)  J2:J4 
C)  SUM 
D)  None of the above are arguments. 
A)  = 
B)  J2:J4 
C)  SUM 
D)  None of the above are arguments.

Question 7

Names for named ranges must start with a number.

Accepted Answer

A) True 
 B)False

Question 8

A(n)________ allows users to refer to a particular cell or range of cells within a formula or function.

Accepted Answer

The answer of A(n)________ allows users to refer to a...

Question 9

The PMT function requires users to enter the total number of payments that will be made for the loan,or the ________.

Accepted Answer

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

Question 10

Syntax rules state that functions start with an equal sign.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is NOT a valid cell reference?

Accepted Answer

A)  =T$11 
B)  =G6 
C)  =$B$K 
D)  =$X14 
A)  =T$11 
B)  =G6 
C)  =$B$K 
D)  =$X14

Question 12

Two different pseudocodes can produce the same results.

Accepted Answer

A) True 
 B)False

Question 13

IF,AND,and OR are examples of ________ functions.

Accepted Answer

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

Question 14

Arguments are required for all functions.

Accepted Answer

A) True 
 B)False

Question 15

Pseudocode is a complete formula,such as:
=IF(H1>15,A5*5,A5*7)

Accepted Answer

A) True 
 B)False

Question 16

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

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 17

The formula below contains a named range.
=SUM($J$5:J$7)

Accepted Answer

A) True 
 B)False

Question 18

Functions such as TODAY,which has no arguments,are written as: =TODAY

Accepted Answer

A) True 
 B)False

Question 19

A cell reference allows users to refer to a cell in a formula.

Accepted Answer

A) True 
 B)False

Question 20

The cells associated with a named range can be modified after they have been created.

Accepted Answer

A) True 
 B)False

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

The Show Formulas view is when cells display the formulas instead of the output.

To switch to the Show Formulas view,hold the Ctrl key and press the $ key.

Which of the following is TRUE about hard-coded values?

There are two methods for creating functions: typing in the function and through the Functions ________ dialog box.

Which of the following is the argument in the following formula: =SUM(J2:J4)

Names for named ranges must start with a number.

A(n)________ allows users to refer to a particular cell or range of cells within a formula or function.

The PMT function requires users to enter the total number of payments that will be made for the loan,or the ________.

Syntax rules state that functions start with an equal sign.

Which of the following is NOT a valid cell reference?

Two different pseudocodes can produce the same results.

IF,AND,and OR are examples of ________ functions.

Arguments are required for all functions.

Pseudocode is a complete formula,such as: =IF(H1>15,A5*5,A5*7)

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

The formula below contains a named range. =SUM($J$5:J$7)

Functions such as TODAY,which has no arguments,are written as: =TODAY

A cell reference allows users to refer to a cell in a formula.

The cells associated with a named range can be modified after they have been created.

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

Pseudocode is a complete formula,such as: =IF(H1>15,A55,A57)