Advance Functions

This function find information in a LARGE table (more than one column) and returns a value.

• LookUp
• Now
• VLoookUp

The number of hours worked is recorded in cell D7, Hourly rate is recorded in Cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which function correctly determines how many overtime hours have occurred

• =IF(D7>40,D7-40)
• =MAX(D1:D7)*1.5
• =OVERTIME(D7*E7)

Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received?

• Now
• Count
• Days360

Which type of list allows additional entries other than those provided in the drop-down menu?

• Validated
• Non-validated
• LookUp

Which function will automatically add the total value in a range of cells?

• SUM
• RANGE
• COUNT

If you wanted to consistently display rows 1-7 in a spreadsheet which feature should be used?

• Fill series
• Link
• Freeze pane

In a  spreadsheet, which function will result in total number of entries in a cell range?

• CountIf
• Count
• CountA

A spreadsheet is created with drop down items that a user can select from. This is an example of which function?

• LookUp
• Fill Series
• List

Which function is used to determine the highest value?

• Max
• Min
• Sum

This function allows the computer to insert dates according to your instructions.

• Now
• Date
• Days360