Question 1

Explain what a logical function is and give an example of when you would use one in Excel 2007.

Accepted Answer

A logical function is a function that wo

Question 2

Not all functions have arguments.

Accepted Answer

A) True 
 B)False

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The amount of money loaned

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

Functions can be ____.

Accepted Answer

A)  incorporated as part of larger formulas 
B)  placed inside another function 
C)  either a.or b. 
D)  neither a.nor b. 
A)  incorporated as part of larger formulas 
B)  placed inside another function 
C)  either a.or b. 
D)  neither a.nor b.

Question 5

Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

Accepted Answer

The answer of Some cell references are called ____________________ references...

Question 6

The ____ function category retrieves data from multidimensional databases involving online analytical processing or OLAP.

Accepted Answer

A)  Database 
B)  Cube 
C)  Text 
D)  Financial 
A)  Database 
B)  Cube 
C)  Text 
D)  Financial

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Optional argument in the PMT 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 8

The small black plus sign in the lower-right corner of a selected cell or range is called the ____________________.

Accepted Answer

The answer of The small black plus sign in the...

Question 9

PMT (rate, nper, $ p v,[f v=0] \quad[t y p e=0]) $
-In the figure above,fv and type are ____.

Accepted Answer

A)  financial functions 
B)  required arguments 
C)  comparison operators 
D)  optional arguments 
A)  financial functions 
B)  required arguments 
C)  comparison operators 
D)  optional arguments

Question 10

Another way to copy a formula is to use the Fill button on the ____ group.

Accepted Answer

A)  AutoFill 
B)  Editing 
C)  Cells 
D)  Styles 
A)  AutoFill 
B)  Editing 
C)  Cells 
D)  Styles

Question 11

The fill handle copies ____.

Accepted Answer

A)  content only 
B)  formats only 
C)  content and formats 
D)  formats and cell references 
A)  content only 
B)  formats only 
C)  content and formats 
D)  formats and cell references

Question 12

Functions can also be ____________________ or placed inside another function.

Accepted Answer

The answer of Functions can also be ____________________ or placed...

Question 13

Another approach is to calculate the most common value in the data,otherwise known as the ____________________.

Accepted Answer

The answer of Another approach is to calculate the most...

Question 14

When you enter a formula into a cell,Excel interprets cell references in the formula in relation to the cell's location.

Accepted Answer

A) True 
 B)False

Question 15

Most Recently Used is a ____.

Accepted Answer

A)  group on the Formula tab on the Ribbon 
B)  category in the Insert Function dialog box 
C)  category in the Function Arguments dialog box 
D)  command on the Office Button menu 
A)  group on the Formula tab on the Ribbon 
B)  category in the Insert Function dialog box 
C)  category in the Function Arguments dialog box 
D)  command on the Office Button menu

Question 16

The ____ category of Excel functions retrieves and analyzes data.

Accepted Answer

A)  Text 
B)  Database 
C)  Information 
D)  Logical 
A)  Text 
B)  Database 
C)  Information 
D)  Logical

Question 17

Why is it that the TODAY and NOW date functions do not have any arguments?

Accepted Answer

The TODAY and NOW date functions do not

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A comparison operator

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 19

Case-Based Critical Thinking Questions
Case 3-1
Charles is a recent college graduate.He is paying rent for the first time,as well as utility bills,such as cable,electric,and telephone.He also has some hefty school loan payments.Charles has a good paying job and knows that even though he has lots of expenses,it is critical for him to save money each month,too.He decides to create a budget for himself in Excel 2010.
-Charles has entered all of his monthly expenses.He needs to create a formula that will deduct his monthly expenses from his monthly income.Since his monthly income is the same amount each month,he uses a(n)____ to identify the cell containing the income value.

Accepted Answer

A)  relative reference 
B)  absolute reference 
C)  mixed reference 
D)  fixed reference 
A)  relative reference 
B)  absolute reference 
C)  mixed reference 
D)  fixed reference

Question 20

Another name for the middle value is the ____ value.

Accepted Answer

A)  mode 
B)  center 
C)  median 
D)  relative 
A)  mode 
B)  center 
C)  median 
D)  relative

Explain what a logical function is and give an example of when you would use one in Excel 2007.

Not all functions have arguments.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The amount of money loaned

Functions can be ____.

Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

The ____ function category retrieves data from multidimensional databases involving online analytical processing or OLAP.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Optional argument in the PMT function

The small black plus sign in the lower-right corner of a selected cell or range is called the ____________________.

PMT (rate, nper, $p v,[f v=0] \quad[t y p e=0])$ -In the figure above,fv and type are ____.

Another way to copy a formula is to use the Fill button on the ____ group.

The fill handle copies ____.

Functions can also be ____________________ or placed inside another function.

Another approach is to calculate the most common value in the data,otherwise known as the ____________________.

When you enter a formula into a cell,Excel interprets cell references in the formula in relation to the cell's location.

Most Recently Used is a ____.

The ____ category of Excel functions retrieves and analyzes data.

Why is it that the TODAY and NOW date functions do not have any arguments?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A comparison operator

Another name for the middle value is the ____ value.

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

Explain what a logical function is and give an example of when you would use one in Excel 2007.

Not all functions have arguments.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The amount of money loaned

Functions can be ____.

Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

The ____ function category retrieves data from multidimensional databases involving online analytical processing or OLAP.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Optional argument in the PMT function

The small black plus sign in the lower-right corner of a selected cell or range is called the ____________________.

PMT (rate, nper, pv,[fv=0][type=0]) p v,[f v=0] \quad[t y p e=0]) pv,[fv=0][type=0]) -In the figure above,fv and type are ____.

Another way to copy a formula is to use the Fill button on the ____ group.

The fill handle copies ____.

Functions can also be ____________________ or placed inside another function.

Another approach is to calculate the most common value in the data,otherwise known as the ____________________.

When you enter a formula into a cell,Excel interprets cell references in the formula in relation to the cell's location.

Most Recently Used is a ____.

The ____ category of Excel functions retrieves and analyzes data.

Why is it that the TODAY and NOW date functions do not have any arguments?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A comparison operator

Another name for the middle value is the ____ value.

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

PMT (rate, nper, $p v,[f v=0] \quad[t y p e=0])$ -In the figure above,fv and type are ____.