What is one way to determine if a spreadsheet is more appropriate for a task than a database solution would be?
A. use a spreadsheet to blend multiple datasets
B. use a spreadsheet for self-contained datasets
C. use a spreadsheet for input or output data sources with multiple formats
D. use a spreadsheet when you need cross reference
B. use a spreadsheet for self-contained datasets
If the task involves a relatively small amount of data that is self-contained and does not require complex relationships between different datasets, a spreadsheet may be more appropriate than a database solution. Spreadsheets are simpler to use, easier to set up, and require less technical knowledge compared to databases.