Excel Professional – Acceptance Tests

An acceptance test is a specification of a Result made prior to embarking on production.

Here is an example: We are building a spredasheet to deliver a quotation for a group of travelers going on a tour.

We have been working out the values by hand (or on a clumsy workbook), and so we have a good grasp of the business.

However we would be hard pressed to deliver an accurate figure out of our heads – that is why we are building a spreadshete calculator.

Therefore we might state that a 7-day tour by 6 people will cost around $20,000 before taxes.

Before we start buil

Next Step: