Extreme Sports Homework Quiz 2

Which of the following is the best definition of REVENUE?

• The total amount of income a business makes from selling products or services
• The amount of money a business has LEFT over after paying for their costs.
• The total amount of money a business spends.
• The amount of money a business loses every month.

Which of the following is the best definition of PROFIT?

• The total amount of income a business makes from selling products or services
• The amount of money a business has left over after paying for their costs.
• The total amount of money a business spends.

Which of the following is the best definition of COSTS?

• The total amount of income a business makes from selling products or services
• The amount of money a business has left over after paying for materials.
• The total amount of money a business spends.

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 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

In a spreadsheet what formula do you use to work out the Total Profit for the movie "BFG" that's been sold?

• =SUM(7.01*5)

• =MULTIPLY(E4:F4)

• =SUM(E4*F4)

• =MULTIPLY(7.01:5)

In a spreadsheet. Looking at the Sum in the picture above.

What formula is used to divide the two numbers together.

In a spreadsheet. Looking at the Sum in the picture above.

What formula is used to multiply the two numbers together.

In a spreadsheet. Looking at the Sum in the picture above.

What formula is used to take away the two numbers together.

• =MINUS(76032:32098)

• =SUM(C3-C4)

• =SUM(76032:32098)

• =MINUS(C3-C4)