Question 1

How many functions does Excel provide?

Accepted Answer

A) Over 40 
B) Over 400 
C) Over 4,000 
D) Unlimited 
A) Over 40 
B) Over 400 
C) Over 4,000 
D) Unlimited

Question 2

The test argument in an IF statement must evaluate to either ________.

Accepted Answer

True or Fa

Question 3

Match between columns
                        Premises: 62.33
6
1
199
31.50

Accepted Answer

The Answer of COUNT and MEDIAN and MAX and AVERAGE is...

Question 4

Using ________ simplifies adding complex mathematical formulas to a cell.

Accepted Answer

functions,

Question 5

Which status bar statistic can you not enable?

Accepted Answer

A) SUM 
B) MIN 
C) Range Name 
D) Page Number 
A) SUM 
B) MIN 
C) Range Name 
D) Page Number

Question 6

What actually changes the value Excel stores to a user determined number of decimal places?

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 7

What error will you get if you type a function name incorrectly?

Accepted Answer

A) #FUNCTION? 
B) #VALUE? 
C) #ERROR? 
D) #NAME? 
A) #FUNCTION? 
B) #VALUE? 
C) #ERROR? 
D) #NAME?

Question 8

Which of the following will not return the system clock's date?

Accepted Answer

A) NOW() 
B) TODAY() 
C) Ctrl+; 
D) DATE() 
A) NOW() 
B) TODAY() 
C) Ctrl+; 
D) DATE()

Question 9

Match between columns
                        Premises: VLOOKUP
Column index number
HLOOKUP
Lookup value
Lookup table

Accepted Answer

The Answer of Cell that contains the value to be is...

Question 10

When you use the VLOOKUP function, the ________ column in the array is used to look up the value.

Accepted Answer

The answer of When you use the VLOOKUP function, the...

Question 11

If a cell contains =$N$21 and two new columns are inserted in front of column N and three rows are inserted above row 21, what happens to the =$N$21?

Accepted Answer

A) It becomes =$P$24 
B) It remains =$N$21 
C) It becomes =$L$18 
D) It becomes =$Q$23 
A) It becomes =$P$24 
B) It remains =$N$21 
C) It becomes =$L$18 
D) It becomes =$Q$23

Question 12

The COUNTBLANK function will count cells that contain formulas that compute to a value of zero (0).

Accepted Answer

A) True 
 B)False

Question 13

Match between columns
                        Premises: TODAY()
PMT
RATE
NOW()
PV

Accepted Answer

The Answer of Current amount of a loan and Returns is...

Question 14

The ________ function finds the largest value in a range.

Accepted Answer

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

Question 15

In the HLOOKUP function, the third argument is the column index number.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Average
Median
Table array
Sum
Breakpoint

Accepted Answer

The Answer of Range used for looking up values and is...

Question 17

When entering functions, the square brackets, [], indicate required values.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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 20

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

How many functions does Excel provide?

The test argument in an IF statement must evaluate to either ________.

Using ________ simplifies adding complex mathematical formulas to a cell.

Which status bar statistic can you not enable?

What actually changes the value Excel stores to a user determined number of decimal places?

What error will you get if you type a function name incorrectly?

Which of the following will not return the system clock's date?

When you use the VLOOKUP function, the ________ column in the array is used to look up the value.

If a cell contains =$N$21 and two new columns are inserted in front of column N and three rows are inserted above row 21, what happens to the =$N$21?

The COUNTBLANK function will count cells that contain formulas that compute to a value of zero (0).

The ________ function finds the largest value in a range.

In the HLOOKUP function, the third argument is the column index number.

When entering functions, the square brackets, [], indicate required values.

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

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

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

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

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

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 2: Formulas and Functions

How many functions does Excel provide?

The test argument in an IF statement must evaluate to either ________.

Using ________ simplifies adding complex mathematical formulas to a cell.

Which status bar statistic can you not enable?

What actually changes the value Excel stores to a user determined number of decimal places?

What error will you get if you type a function name incorrectly?

Which of the following will not return the system clock's date?

When you use the VLOOKUP function, the ________ column in the array is used to look up the value.

If a cell contains =$N$21 and two new columns are inserted in front of column N and three rows are inserted above row 21, what happens to the =$N$21?

The COUNTBLANK function will count cells that contain formulas that compute to a value of zero (0).

The ________ function finds the largest value in a range.

In the HLOOKUP function, the third argument is the column index number.

When entering functions, the square brackets, [], indicate required values.

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

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

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

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

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

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters