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

Question 2

Match between columns
                        Premises: Return 30 from the list: 29, 47, 21, 52, 1
1,2,3,4,5
Return 29 from the list: 29, 47, 21, 52, 1
Winona Lake, Winchester, Perrysburg, Clear Spring
Return 52 from the list: 29, 47, 21, 52, 1

Accepted Answer

The Answer of Sort descending and Sort ascending and MAX is...

Question 3

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)

Question 4

A function's ________ defines the rules by which the function operates.

Accepted Answer

The answer of A function's ________ defines the rules by...

Question 5

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

Question 6

Match between columns
                        Premises: Relative cell references
Mixed cell references
Absolute cell references
Function
Argument

Accepted Answer

The Answer of Simplifies complex calculations and Does not change is...

Question 7

All IF functions have three arguments.

Accepted Answer

A) True 
 B)False

Question 8

The ________ function is similar to the TODAY()function,except that it also returns the system time.

Accepted Answer

The answer of The ________ function is similar to the...

Question 9

The VLOOKUP function has four required arguments.

Accepted Answer

A) True 
 B)False

Question 10

What function computes the value in which one-half of the data is above and one-half is below.

Accepted Answer

A) MIDDLE 
B) MODE 
C) AVERAGE 
D) MEDIAN 
A) MIDDLE 
B) MODE 
C) AVERAGE 
D) MEDIAN

Question 11

The ________ function counts the number of calculable values,but ignores cells that have text or are empty.

Accepted Answer

The answer of The ________ function counts the number of...

Question 12

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 13

________ is a set of analytical tools that appears when you select a range.

Accepted Answer

The answer of ________ is a set of analytical tools...

Question 14

Excel assigns date number 1 to January 1,1900.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is not a valid =IF statement?

Accepted Answer

A) =IF(A5>19,"Greater","Not Greater") 
B) =IF(A5>19,b7,b9) 
C) =IF(A5>19,1,9) 
D) =IF(A5>19,Greater,Not Greater) 
A) =IF(A5>19,"Greater","Not Greater") 
B) =IF(A5>19,b7,b9) 
C) =IF(A5>19,1,9) 
D) =IF(A5>19,Greater,Not Greater)

Question 16

To look up an exact match,what should you enter in the range_lookup argument?

Accepted Answer

A) FALSE 
B) TRUE 
C) EXACT 
D) Leave it blank 
A) FALSE 
B) TRUE 
C) EXACT 
D) Leave it blank

Question 17

Which of the following is not a valid test in an =IF statement?

Accepted Answer

A) A4-B4 B) A4A4 D) B4<=B4 A) A4-B4 B) A4A4 D) B4<=B4

Question 18

If you wanted to count the number of entries in a list that contained numbers,text,and blank cells,but ignore the text and blank cells,which function would you use?

Accepted Answer

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

Question 19

After you type a function and its opening parenthesis "(" the ________ appears and displays the function's arguments.

Accepted Answer

function screen-tip,

Question 20

What is not a direct option on the AutoSum drop down menu?

Accepted Answer

A) Median 
B) Sum 
C) Count numbers 
D) Max 
A) Median 
B) Sum 
C) Count numbers 
D) Max

What two functions compute the central tendency of values?

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

A function's ________ defines the rules by which the function operates.

What is the default method of referencing cells in formulas?

All IF functions have three arguments.

The ________ function is similar to the TODAY()function,except that it also returns the system time.

The VLOOKUP function has four required arguments.

What function computes the value in which one-half of the data is above and one-half is below.

The ________ function counts the number of calculable values,but ignores cells that have text or are empty.

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

________ is a set of analytical tools that appears when you select a range.

Excel assigns date number 1 to January 1,1900.

Which of the following is not a valid =IF statement?

To look up an exact match,what should you enter in the range_lookup argument?

Which of the following is not a valid test in an =IF statement?

If you wanted to count the number of entries in a list that contained numbers,text,and blank cells,but ignore the text and blank cells,which function would you use?

After you type a function and its opening parenthesis "(" the ________ appears and displays the function's arguments.

What is not a direct option on the AutoSum drop down menu?

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 2: Formulas and Functions

What two functions compute the central tendency of values?

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

A function's ________ defines the rules by which the function operates.

What is the default method of referencing cells in formulas?

All IF functions have three arguments.

The ________ function is similar to the TODAY()function,except that it also returns the system time.

The VLOOKUP function has four required arguments.

What function computes the value in which one-half of the data is above and one-half is below.

The ________ function counts the number of calculable values,but ignores cells that have text or are empty.

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

________ is a set of analytical tools that appears when you select a range.

Excel assigns date number 1 to January 1,1900.

Which of the following is not a valid =IF statement?

To look up an exact match,what should you enter in the range_lookup argument?

Which of the following is not a valid test in an =IF statement?

If you wanted to count the number of entries in a list that contained numbers,text,and blank cells,but ignore the text and blank cells,which function would you use?

After you type a function and its opening parenthesis "(" the ________ appears and displays the function's arguments.

What is not a direct option on the AutoSum drop down menu?

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters