Advanced Excel

IF Statement can be written to carry out an action

• True

• False

What function will result in the total number of entries in the cell range B5 to B14

• Count

• MAX

• MIN

• SUM

What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail"?

• Count

• CountA

• IF

• SUM

Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array

• CountIF

• NOW

• Lookup

• VLookup

Which function returns the current date?

• Lookup

• VLookup

• CountIF

• NOW

The NOW function calculates the difference in days between two dates.

• True

• False

Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.

• True

• False

An array is a systematic arrangement of similar objects, usually in rows and columns.

• True

• False

Which function is used to return the number of cells in a range that meet a condition set forth in the formula?

• Lookup

• VLookup

• NOW

• CountIF

Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used with only two columns in the array.

• VLookup

• Now

• Lookup

• CountIf