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 a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2013. She need to keep track of her expenses and income for the year.
-Ellen opens Excel 2013 and enters her monthly income for one year beginning with January.To create a series of months,she can ____.

Accepted Answer

A) Type = Jan-Dec in cell A1 and then press Enter. 
B) Type January in cell A1 and then drag the filll handle. 
C) Type =YEAR in cell A1 and then press Enter. 
D) Type =DATE(Jan, Dec) in cell A1 and then press Enter.

Question 3

A constant is a value in a formula that doesn't change.

Accepted Answer

A) True 
 B)False

Question 4

After you describe a function in the Search for a function box in the Insert Function dialog box,click ____.

Accepted Answer

A) Go 
B) Select 
C) Insert 
D) Next

Question 5

Use ____ references when you want different formulas to refer to the same cell.

Accepted Answer

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

Question 6

Using the AutoFill Options button,the Fill Without Formatting option copies the ____ but not the formatting.

Accepted Answer

A) functions 
B) content 
C) cell references 
D) left-aligns

Question 7

The ____________________ is the middle value from a sample.

Accepted Answer

The answer of The ____________________ is the middle value from...

Question 8

A $\underline {  \text { trial-and-error method }  }$ lets you explore the impact that changing input values has on the
calculated values in the workbook._________________________

Accepted Answer

A) True 
 B)False

Question 9

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the $\underline { \text { current }   }$ cell._________________

Accepted Answer

A) True 
 B)False

Question 10

Which category of Excel functions returns information about the format,location,or contents of worksheet cells? ____

Accepted Answer

A) Location 
B) Information 
C) Reference 
D) Description

Question 11

If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell.

Accepted Answer

A) #VALUE 
B) #N/A 
C) #ERROR 
D) #NULL

Question 12

Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2013. She need to keep track of her expenses and income for the year.
-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 13

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 14

The IF function is a logical function that returns one value if a condition is true,and returns a different value if that condition is false.

Accepted Answer

A) True 
 B)False

Question 15

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2013 Analysis tools.
-Susan needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .

Accepted Answer

A) EXACT 
B) 1 
C) TRUE 
D) FALSE

Question 16

Which of the following is not a date function? ____

Accepted Answer

A) YEAR 
B) NOW 
C) AND 
D) TODAY

Question 17

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 18

The ____ function returns the maximum value in the range.

Accepted Answer

A) TOP 
B) FIRST 
C) MAX 
D) MOST

Question 19

Which of the following is not an Excel function category? ____

Accepted Answer

A) Math & Trig 
B) Algebra 
C) Statistical 
D) Text

Question 20

By default,AutoFill copies only the content not the formatting of the original range to the selected range.

Accepted Answer

A) True 
 B)False

Exam 3: Calculating Data With Formulas and Functions

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

A constant is a value in a formula that doesn't change.

After you describe a function in the Search for a function box in the Insert Function dialog box,click ____.

Use ____ references when you want different formulas to refer to the same cell.

Using the AutoFill Options button,the Fill Without Formatting option copies the ____ but not the formatting.

The ____________________ is the middle value from a sample.

A $\underline { \text { trial-and-error method } }$ lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the $\underline { \text { current } }$ cell._________________

Which category of Excel functions returns information about the format,location,or contents of worksheet cells? ____

If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell.

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

The IF function is a logical function that returns one value if a condition is true,and returns a different value if that condition is false.

Which of the following is not a date function? ____

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

The ____ function returns the maximum value in the range.

Which of the following is not an Excel function category? ____

By default,AutoFill copies only the content not the formatting of the original range to the selected range.

Exam 3: Calculating Data With Formulas and Functions

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

A constant is a value in a formula that doesn't change.

After you describe a function in the Search for a function box in the Insert Function dialog box,click ____.

Use ____ references when you want different formulas to refer to the same cell.

Using the AutoFill Options button,the Fill Without Formatting option copies the ____ but not the formatting.

The ____________________ is the middle value from a sample.

A trial-and-error method ‾\underline { \text { trial-and-error method } } trial-and-error method ​ lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the current ‾\underline { \text { current } } current ​ cell._________________

Which category of Excel functions returns information about the format,location,or contents of worksheet cells? ____

If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell.

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

The IF function is a logical function that returns one value if a condition is true,and returns a different value if that condition is false.

Which of the following is not a date function? ____

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

The ____ function returns the maximum value in the range.

Which of the following is not an Excel function category? ____

By default,AutoFill copies only the content not the formatting of the original range to the selected range.

A $\underline { \text { trial-and-error method } }$ lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the $\underline { \text { current } }$ cell._________________