Skip to content
- 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.
- Consider the performance of database functions in Excel and their counterpart (e.g., COUNT vs. DCOUNT.) Pick one and explain the difference.
- Do you think having these functions in a spreadsheet program complicates the application? Explain why.
- Consider the MATCH and INDEX functions and compare them to the VLOOKUP or HLOOKUP functions. Which set provides greater flexibility? Explain your answer.