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
Why is it important for a leader to be able to manage across cultures? Communicate your thoughts on the following statement: “Leaders who cannot understand cultural differences in

define organisational behaviour and explain how organisational and the managers job are related?

gaining comparatively at someone else''s expense

QUESTION Answer in brief to the following (a) Discuss how effective business communication is linked to personal career success. (b) Describe the value of non-verbal

Question 1: Being successful in decision making is something that managers obviously desire. Describe the steps which lead to rational decision making and discuss the limitatio

what are the fundamental principles of business ethics?

QUESTION The term ‘globalisation' means integration of economies and societies through cross country flows of information, ideas, technologies, goods, services, capital, financ

Evaluate factors which could influence organisational ethics.

With the best of process planning and control certain defect may still be revealed during assembly or in final inspection. In that situation proper investigation must be

Explain the Vision of an Entrepreneur. Vision: An entrepreneur has visualizes the methods and means to get dream. In doing the same he visualizes, that: Market Demands, Soic