Spreadsheets

Question 1

What is a #DIV/0! error?

Answer 1

A formula is trying to divide a value in a cell by 0 or an empty cell

Question 2

What is the #ERROR! (Google Sheets only) error?

Answer 2

A formula can’t be interpreted as input (also known as a parsing error)

Question 3

What is the #N/A error?

Answer 3

Data in a formula can’t be found by the spreadsheet

Question 4

What is the #NAME? error?

Answer 4

A formula or function name isn’t understood

Question 5

What is a #NUM! error?

Answer 5

A formula or function calculation can’t be performed as specified

Question 6

What is a spreadsheet formula?

Answer 6

A set of instructions used to perform a calculation using the data in a spreadsheet

Question 7

What is a spreadsheet function?

Answer 7

A preset command that automatically performs a specific process or task using the data in a spreadsheet

Question 8

What is the ‘problem domain’?

Answer 8

The specific area of analysis that encompasses every activity affecting or affected by the problem

Question 9

What is structured thinking?

Answer 9

The process of recognising the current problem or situation, organising available information, revealing gaps and opportunities, and identifying the options

Question 10

What is a ‘scope of work (SOW)’?

Answer 10

An agreed-upon outline of the work you’re going to perform on a project

Question 11

What is a ‘statement of work (SOW)’?

Answer 11

A document that clearly identifies the products and services a vendor or contractor will provide to an organisation. It includes objectives, guidelines, deliverables, schedule and costs