Question 1

What two functions compute the central tendency of values?

Accepted Answer

A)  AVERAGE and MODE 
B)  AVERAGE and MEDIAN 
C)  MIN and MAX 
D)  AVERAGE and CENTER 
A)  AVERAGE and MODE 
B)  AVERAGE and MEDIAN 
C)  MIN and MAX 
D)  AVERAGE and CENTER B

Question 2

What is the default method of referencing cells in formulas?

Accepted Answer

A)  Absolute 
B)  Relative 
C)  Mixed 
D)  Default 
A)  Absolute 
B)  Relative 
C)  Mixed 
D)  Default B

Question 3

Match the following terms with their description:
i. Median
II. Average
III. Sum
IV. Table array
v. Breakpoint

Accepted Answer

A)  Total 
B)  Lowest value in a series 
C)  Midpoint value 
D)  Range used for looking up values 
E)  Arithmetic mean 
A)  Total 
B)  Lowest value in a series 
C)  Midpoint value 
D)  Range used for looking up values 
E)  Arithmetic mean C, E, A, D, B

Question 4

Which function would you use if you wanted to count the number of values, but ignore cells that have text or are empty?

Accepted Answer

A)  COUNT 
B)  COUNTA 
C)  COUNTBLANK 
D)  COUNTVALUES 
A)  COUNT 
B)  COUNTA 
C)  COUNTBLANK 
D)  COUNTVALUES

Question 5

It is very important to sort the first column in a table lookup array in descending order.

Accepted Answer

A) True 
 B)False

Question 6

What term refers to the necessity of following the rules when it comes to using functions?

Accepted Answer

A)  syntax 
B)  formula 
C)  arguments 
D)  function logic 
A)  syntax 
B)  formula 
C)  arguments 
D)  function logic

Question 7

What do you use to separate arguments in a function?

Accepted Answer

A)  Period (.) 
B)  Semi-colon (;) 
C)  Comma (,) 
D)  Colon (:) 
A)  Period (.) 
B)  Semi-colon (;) 
C)  Comma (,) 
D)  Colon (:)

Question 8

Which of the following is not a valid logical test?

Accepted Answer

A)  => 
B)   
D)  >= 
A)  => 
B)   
D)  >=

Question 9

In the PMT function, the PV argument refers to the ________ of the loan.

Accepted Answer

The answer of In the PMT function, the PV argument...

Question 10

Match the following terms with their description:
i. COUNT
II. COUNTA
III. COUNTBLANK
IV. IF
v. NPER

Accepted Answer

A)  Only uses calculable values 
B)  Evaluates true and false statements 
C)  Includes text, but not blank cells 
D)  Length of time you will be paying on a loan 
E)  Only includes empty cells 
A)  Only uses calculable values 
B)  Evaluates true and false statements 
C)  Includes text, but not blank cells 
D)  Length of time you will be paying on a loan 
E)  Only includes empty cells

Question 11

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

Accepted Answer

A)  =IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) 
B)  =IF(A720,"Much Greater","Not Greater than 20")) 
C)  =IF(A720,"Much Greater","Not Greater than 20")) 
D)  =IF(A720,"Much Greater","Not Greater than 20") 
A)  =IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) 
B)  =IF(A720,"Much Greater","Not Greater than 20")) 
C)  =IF(A720,"Much Greater","Not Greater than 20")) 
D)  =IF(A720,"Much Greater","Not Greater than 20")

Question 12

Excel assigns date number 1 to January 1, 1900.

Accepted Answer

A) True 
 B)False

Question 13

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

Accepted Answer

A) True 
 B)False

Question 14

What is the term for the inputs required in a function?

Accepted Answer

A)  formulas 
B)  syntax 
C)  arguments 
D)  terms 
A)  formulas 
B)  syntax 
C)  arguments 
D)  terms

Question 15

The range that contains the lookup table is called the ________.

Accepted Answer

The answer of The range that contains the lookup table...

Question 16

Match the example with the function or feature:
i. =A54
II. =$A54
III. =$A$54
IV. =SUM(A54:B97)
v. "Ohio"

Accepted Answer

A)  Function 
B)  Relative reference 
C)  Ensures text entry 
D)  Mixed reference 
E)  Absolute reference 
A)  Function 
B)  Relative reference 
C)  Ensures text entry 
D)  Mixed reference 
E)  Absolute reference

Question 17

What action changes the actual number of decimal places Excel stores instead of just changing what is displayed?

Accepted Answer

A)  Decrease decimal setting 
B)  Increase decimal setting 
C)  ROUND function 
D)  DECIMAL function 
A)  Decrease decimal setting 
B)  Increase decimal setting 
C)  ROUND function 
D)  DECIMAL function

Question 18

The ________ function finds the smallest value in a range.

Accepted Answer

The answer of The ________ function finds the smallest value...

Question 19

The inputs in a function are specified by its ________.

Accepted Answer

The answer of The inputs in a function are specified...

Question 20

Which of the following does not comply with the preferred way of using the SUM function?

Accepted Answer

A)  =SUM(A4:A11) 
B)  =SUM(A4:A11, B9:E11) 
C)  =SUM(A4, B8, D14) 
D)  =SUM(A4 / A11) 
A)  =SUM(A4:A11) 
B)  =SUM(A4:A11, B9:E11) 
C)  =SUM(A4, B8, D14) 
D)  =SUM(A4 / A11)

What two functions compute the central tendency of values?

What is the default method of referencing cells in formulas?

Match the following terms with their description: i. Median II. Average III. Sum IV. Table array v. Breakpoint

Which function would you use if you wanted to count the number of values, but ignore cells that have text or are empty?

It is very important to sort the first column in a table lookup array in descending order.

What term refers to the necessity of following the rules when it comes to using functions?

What do you use to separate arguments in a function?

Which of the following is not a valid logical test?

In the PMT function, the PV argument refers to the ________ of the loan.

Match the following terms with their description: i. COUNT II. COUNTA III. COUNTBLANK IV. IF v. NPER

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

Excel assigns date number 1 to January 1, 1900.

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

What is the term for the inputs required in a function?

The range that contains the lookup table is called the ________.

Match the example with the function or feature: i. =A54 II. =$A54 III. =$A$54 IV. =SUM(A54:B97) v. "Ohio"

What action changes the actual number of decimal places Excel stores instead of just changing what is displayed?

The ________ function finds the smallest value in a range.

The inputs in a function are specified by its ________.

Which of the following does not comply with the preferred way of using the SUM function?

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters

Exam 7: Excell: Formulas and Functions

What two functions compute the central tendency of values?

What is the default method of referencing cells in formulas?

Match the following terms with their description: i. Median II. Average III. Sum IV. Table array v. Breakpoint

Which function would you use if you wanted to count the number of values, but ignore cells that have text or are empty?

It is very important to sort the first column in a table lookup array in descending order.

What term refers to the necessity of following the rules when it comes to using functions?

What do you use to separate arguments in a function?

Which of the following is not a valid logical test?

In the PMT function, the PV argument refers to the ________ of the loan.

Match the following terms with their description: i. COUNT II. COUNTA III. COUNTBLANK IV. IF v. NPER

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

Excel assigns date number 1 to January 1, 1900.

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

What is the term for the inputs required in a function?

The range that contains the lookup table is called the ________.

Match the example with the function or feature: i. =A54 II. =$A54 III. =$A$54 IV. =SUM(A54:B97) v. "Ohio"

What action changes the actual number of decimal places Excel stores instead of just changing what is displayed?

The ________ function finds the smallest value in a range.

The inputs in a function are specified by its ________.

Which of the following does not comply with the preferred way of using the SUM function?

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters