Processing Data

Which would you use to calculate the total price of all goods shown on an invoice?

• Spreadsheet

• Database

What would you use to store the details of all members of a golf club?

• Spreadsheet

• Database

What would you use to work out the monthly wages, with deductions for income tax and National Insurance, for the staff of an estate agency?

• Spreadsheet

• Database

What would you use to store details of houses for sale so they can be sorted into price order?

• Spreadsheet

• Database

Which of these are advantages of Spreadsheets?

• Formulas can be used to calculate totals

• Data can be sorted on a specific field

• Validation can be set on fields to minimise input errors

• Worksheets can be used to separate different sets of data in a workbook

Which are these are advantages of Databases?

• Data can be filtered or queried to find relevant results

• Reports can be generated to show the results of queries

• What-if investigations can be carried out

• Columns and rows can be locked to maintain data integrity

Which tool can be used to send personalised letters by using mail merge?

• Spreadsheets

• Databases

Which tool can show a business's accounts over a year with each month in a different worksheet?

• Spreadsheets

• Databases

Which of these tools has the feature to be able to display results visually in a graph or chart?

• Spreadsheets

• Databases

Which of these tools has the feature of formulas and functions?

• Spreadsheets

• Databases