Year 9 - Quiz Spreadsheets Recall

Microsoft Excel is ...

• Software

• Hardware

• Utility

• Operating System

Microsoft Excel is used to ...

• Model Financial Scenarios

• Model Games

• Model Images and Text

• Write reports

Which of the following is considered a cell reference?

• C3

• =

• *

• +

What formula should be placed in cell D2?

• =C2-B2

• =F2-B2

• =A2-B2

• =C2

What formula should be placed in cell D6?

• =SUM(D2:D5)

• =SUM(F2:F5)

• =SUM(All)

• =C2-D3

How many products are in this spreadsheet?

• 4

• 2

• 1

• 16

What is used to add the £ signs to the cells.

• Formatting borders

• Formatting Currency

• Formatting fill colours

• formatting text in bold.

(Don't press Enter, until you are finished typing)

What 3 things could you do to improve this financial model? What might you add to it?

Which formula might be most suitable to work out how to calculate a profit?

• =number_sold*sale_price

• =number_sold-sale_price

• =number_sold/sale_price

• =number_sold%sale_price

Which of these makes the most sense to do in Excel?

• Don't add the pound sign yourself. Choose currency from the format type.

• Do add the pound sign yourself. Choose currency from the format type.

• Don't make numbers currency.

• Don't keep everything in neat columns