Yr 8.3 Spreadsheet/Excel Models

Which career(s) or places of employment involve the use of a spreadsheet at work?

• Accountant
• Hospital
• All Choices
• Shop Keeper

What is displayed in cell A6?

• Monday
• Tuesday
• Wednesday
• Thursday

What kind of software is Excel?

• Spreadsheet software/google sheet

• Word Processing/google doc

• Drawing/paint

Goal Seek in excel is used for setting LIMITS and TARGETS

• True

• False

What is the name of this cell?

• B10
• 5B
• B5
• A5

an excel file with one or more worksheets

• workbook
• worksheet
• formula
• row

Spreadsheet models can be used to ask ‘What if….’ questions.

They can be used to try out different options by changing figures in the spreadsheet. This will help to predict what will happen and try out different scenarios

• False

• True

Conditional Formatting is used on a spreadsheet.

Allows the format of a cell to change depending upon the condition or value in that cell e.g. change the cell fill to red if it contains a negative number

• True

• False

Which is not data validation?

• The checking of data, on input or by software to make sure that it is sensible.

• The checking of data, on input or by software to make sure that it is reasonable

• A way of checking that something has been entered correctly.

• The process of establishing the truth, accuracy, or validity of something.

What software program is this?

• Power Point
• Excel
• Word
• One Note