Question 1

=ROUND(AVERAGE(A1:A100),2)is an example of a(n)____ function.

Accepted Answer

A) complex 
B) logical 
C) absolute 
D) nested

Question 2

Ellen is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year.What function key will make D2 an absolute reference?

Accepted Answer

A) F2 
B) F4 
C) F6 
D) F1

Question 3

Susan designs a worksheet with the inventory number,description,quantity,unit cost,reorder point and value. To find values in tables of data,and insert them in another location in the worksheet such as cells or in formulas,she will use ________.

Accepted Answer

A) Max function 
B) Lookup function 
C) CountA function 
D) Sum function

Question 4

An error value begins with a pound sign (#)followed by an error name that indicates the type of error._______________

Accepted Answer

A) True 
 B)False

Question 5

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1._________________________

Accepted Answer

A) True 
 B)False

Question 6

The Insert Function dialog box has a(n)____ option.

Accepted Answer

A) search 
B) formatting 
C) find and replace 
D) expand/collapse

Question 7

Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet.She can use  ______.

Accepted Answer

A) Lookup Analysis 
B) What-If Analysis 
C) IF conditions 
D) nested OR conditions

Question 8

The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Accepted Answer

The answer of The ____________________ organizes all of the functions...

Question 9

____ arguments may provide more control over the returned value.

Accepted Answer

A) Relative 
B) Required 
C) Optional 
D) Absolute

Question 10

The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date.

Accepted Answer

A) True 
 B)False

Question 11

The numbers,text,or cell references used by the function to return a value are called ____.

Accepted Answer

A) expressions 
B) arguments 
C) data 
D) values

Question 12

The following mixed reference in the formula,$A5,has an absolute column reference and a relative row reference._________________________

Accepted Answer

A) True 
 B)False

Question 13

Excel functions are organized into ____ categories.

Accepted Answer

A) 8 
B) 10 
C) 11 
D) 13

Question 14

Ellen has entered all of her monthly expenses.She needs to create a formula that will deduct her monthly expenses from her monthly income.Since her monthly income is the same amount each month,she 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

Question 15

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...

Exam 9: Performing Calculations With Formulas and Functions

=ROUND(AVERAGE(A1:A100) ,2) is an example of a(n) ____ function.

Ellen is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year.What function key will make D2 an absolute reference?

Susan designs a worksheet with the inventory number,description,quantity,unit cost,reorder point and value. To find values in tables of data,and insert them in another location in the worksheet such as cells or in formulas,she will use ________.

An error value begins with a pound sign (#)followed by an error name that indicates the type of error._______________

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1._________________________

The Insert Function dialog box has a(n) ____ option.

Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet.She can use ______.

The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

____ arguments may provide more control over the returned value.

The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date.

The numbers,text,or cell references used by the function to return a value are called ____.

The following mixed reference in the formula,$A5,has an absolute column reference and a relative row reference._________________________

Excel functions are organized into ____ categories.

Ellen has entered all of her monthly expenses.She needs to create a formula that will deduct her monthly expenses from her monthly income.Since her monthly income is the same amount each month,she uses a(n) ____ to identify the cell containing the income value.

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