Complex spreadsheet model, Business Management

Refine your complex spreadsheet model to improve efficiency.

a) The user needs to enter at least one of the following contact details: Home Phone, Mobile or E-mail address. If all of these have been left blank, then the user needs to receive feedback to ensure that they enter one value.

The maximum garden length, width and radius, Gareth can cater for are:

Length 1000m

Width 750m

Radius 200m

Implement validation to ensure that user entry does not exceed these values.

b) Implement password protection into you workbook to ensure that no unauthorised persons can access the data.
P5

c) Add two additional sheets to your workbook - one named Invoice and the other named Menu.

d) Add macro buttons to each of the four worksheets to enable the user to fully navigate around the workbook. Include a Quit button on the menu.

Posted Date: 3/25/2013 1:55:28 AM | Location : United States







Related Discussions:- Complex spreadsheet model, Assignment Help, Ask Question on Complex spreadsheet model, Get Answer, Expert's Help, Complex spreadsheet model Discussions

Write discussion on Complex spreadsheet model
Your posts are moderated
Related Questions
What are the control charts in management? Control Charts: These charts are based upon statistical sampling theory, as per that an enough sized sample drawn, at various f

Demerits of specialisation include: There is superior risk in providing only a restricted range of products or services, i.e. individual traders are not capable to enjoy

QUESTION 1 (a) Explain the following terms as used in E-business: (i) Vortal (ii) Countermediation (iii) e-Auction (iv) Cookie (v) B2B e-business model (b) Wi

QUESTION 1 Describe the relevance of Herzberg theory of motivation in motivating employees in practice QUESTION 2 (a) Why do you think organizations are giving increase

Question 1: According to the instrumentality theory of motivation, money is the main motivating factor at work. This can explain the existence of performance related pay in man

QUESTION Meetings and committees have unfortunately acquired notoriety, being widely regarded as ineffective and wasteful of precious time (i) Give your views on the above

He works at a local coffee shop for wage of $7.50 per hour.  The job is very flexible; he can work there as many hours as he wants. When he's not working at the coffee shop, Bil

QUESTION ‘Several developing countries have joined one regional integration group or another with the hope of addressing common problems in a collective and coordinated manner.

This is the time gap between placement of an order and the time of actual supply. The determination of lead time is a complicated matter. It is of core significance i

Identify and explore NetSuite’s components that relate to your business major