Question 1

A mixed formula contains both relative and absolute references._________________________

Accepted Answer

A) True 
 B)False

Question 2

____________________ is a set of rules which specifies how a function should be written.

Accepted Answer

The answer of ____________________ is a set of rules which...

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A Statistical function

Accepted Answer

A) NOW 
B) PMT function 
C) Principal 
D) Simple interest 
E) fv
F)<
G)F4
H)Absolute references
I)nested
J)mixed
K)Mon,Tues,Wed,Thurs,Fri
L)Median 
A) NOW 
B) PMT function 
C) Principal 
D) Simple interest 
E) fv
F)<
G)F4
H)Absolute references
I)nested
J)mixed
K)Mon,Tues,Wed,Thurs,Fri
L)Median

Question 4

You use an absolute reference when you don't want a cell reference to change._________________________

Accepted Answer

A) True 
 B)False

Question 5

Excel allows you to cycle through the different reference types using the F2 key._________________________

Accepted Answer

A) True 
 B)False

Question 6

-Referring to the figure above,the last entry shown in Column N is 7,200.There is an icon in the cell underneath the 7,200 which is the ____.

Accepted Answer

A)  fill handle 
B)  Auto Fill Options button 
C)  formula finder 
D)  function finder 
A)  fill handle 
B)  Auto Fill Options button 
C)  formula finder 
D)  function finder

Question 7

-Referring to the figure above,the Insert Function button opens the ____ dialog box from which you can select a function.

Accepted Answer

A)  Function Gallery 
B)  Insert Function 
C)  Create Function 
D)  Find Function 
A)  Function Gallery 
B)  Insert Function 
C)  Create Function 
D)  Find Function

Question 8

In the list of AutoFill Options,the Fill Formatting Only option is the default setting.

Accepted Answer

A) True 
 B)False

Question 9

Blue,Accent1,Light 60% is an example of cell ____.

Accepted Answer

A)  size 
B)  formatting 
C)  border color 
D)  height 
A)  size 
B)  formatting 
C)  border color 
D)  height

Question 10

____________________ is an Excel function category that returns information about the format,location,or contents of worksheet cells.

Accepted Answer

The answer of ____________________ is an Excel function category that...

A mixed formula contains both relative and absolute references._________________________

____________________ is a set of rules which specifies how a function should be written.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A Statistical function

You use an absolute reference when you don't want a cell reference to change._________________________

Excel allows you to cycle through the different reference types using the F2 key._________________________

-Referring to the figure above,the last entry shown in Column N is 7,200.There is an icon in the cell underneath the 7,200 which is the ____.

-Referring to the figure above,the Insert Function button opens the ____ dialog box from which you can select a function.

In the list of AutoFill Options,the Fill Formatting Only option is the default setting.

Blue,Accent1,Light 60% is an example of cell ____.

____________________ is an Excel function category that returns information about the format,location,or contents of worksheet cells.

Getting Started With Excel

Formatting a Workbook

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 3: Working With Formulas and Functions

A mixed formula contains both relative and absolute references._________________________

____________________ is a set of rules which specifies how a function should be written.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A Statistical function

You use an absolute reference when you don't want a cell reference to change._________________________

Excel allows you to cycle through the different reference types using the F2 key._________________________

-Referring to the figure above,the last entry shown in Column N is 7,200.There is an icon in the cell underneath the 7,200 which is the ____.

-Referring to the figure above,the Insert Function button opens the ____ dialog box from which you can select a function.

In the list of AutoFill Options,the Fill Formatting Only option is the default setting.

Blue,Accent1,Light 60% is an example of cell ____.

____________________ is an Excel function category that returns information about the format,location,or contents of worksheet cells.

Getting Started With Excel

Formatting a Workbook

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters