Question

Describe a job where you would be likely to use spreadsheet software. Explain what you might use it for. (1-3 sentences. 2.5 points)

List at least five pieces of information you would want to keep track of if you were creating a customer database for your own compar
- Explain why you wouldn't want to use the customer first or last name field as the primary key for a table. What problem could this crea

Answer 1

A job where spreadsheet software is commonly used is an accountant. Spreadsheet software is helpful for financial calculations, budgeting, data analysis, and project management. When creating a customer database, it is important to choose a primary key field other than customer names to avoid data inaccuracies.

Step-by-step explanation:

A job where you could use spreadsheet software is an accountant. They can use it for financial calculations, creating budgets, and analyzing data. Spreadsheet software can also be used in project management to track timelines and deadlines.

1. Customer names
2. Phone numbers
3. Email addresses
4. Addresses
5. Purchase history

You wouldn't want to use the customer first or last name field as the primary key for a table because it is possible for two customers to have the same name. This could create a problem when updating or deleting records, resulting in data inaccuracies or loss of information.

Learn more about The use of spreadsheet software in accounting and customer database management