Think about the use of database functions. Name two to three situations where database functions would be useful. For each example above, name a…

  1. Think about the use of database functions. Name two to three situations where database functions would be useful. For each example above, name a database function and explain what it would return.
  2. Consider the performance of database functions in Excel and their counterpart (e.g., COUNT vs. DCOUNT.) Pick one and explain the difference.
  3. Do you think having these functions in a spreadsheet program complicates the application? Explain why.
  4. Consider the MATCH and INDEX functions and compare them to the VLOOKUP or HLOOKUP functions. Which set provides greater flexibility? Explain your answer.