Course 2: Week 3 - The Amazing spreadsheet

Question 1

Operator

Answer 1

A symbol that name the type of operation or calculation to be performed.
- e.g. + is an operator

Question 2

Formula

Answer 2

a formula is a set of instructions that does a specific calculation using the data in a spreadsheet.

Question 3

ERROR!

Answer 3

• A formula cannot be interpreted as input
• Happens when you enter a formula into a cell, and the spreadsheet software cannot understand what you want it to do.

Question 4

N/A

Answer 4

• Data in formula cannot be found in spreadsheet.

Question 5

NAME?

Answer 5

formula’s name isn’t recognized or understood.

Question 6

NUM!

Answer 6

A function or formula cannot be performed
- caused by inconsistent or wrong data

Question 7

VALUE!

Answer 7

A general error which could indicate a problem with formula or referenced cells

Question 8

REF!

Answer 8

A formula is referencing a cell that is no longer valid or has been deleted

Question 9

Problem Domain

Answer 9

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

Question 10

Scope of work

Answer 10

Is an agreed- upon outline of the work you’re going to perform on a project.
- deliverables
- timeline
- milestones
- reports