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.

XLOOKUP Function has replaced VLOOKUP and HLOOKUP. Do you think XLOOKUP is better or worse than VLOOKUP and HLOOKUP?