Complex spreadsheet model, Business Management

Assignment Help:

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.


Related Discussions:- Complex spreadsheet model

Managerail economics, Using the case study approach,discuss the significanc...

Using the case study approach,discuss the significance of managerial economics in regard to business strategies employed by business entities currently operating in the global econ

Explain relationship development theories, Question: i) Recall a time w...

Question: i) Recall a time when you have been the target of rumours or gossip. How might these influence the development of a friendship (whether the gossip is spread by the pe

Quantitative Applications in Management & Research, Ques.1 Comment on “Quan...

Ques.1 Comment on “Quantitative Techniques is a scientific and for enhancing creative and judicious capabilities of a decision maker”, also state the different elements of Decision

Evaluate the case made in the article for ‘the third leg in , Evaluate the ...

Evaluate the case made in the article for ‘the third leg in the strategy “tripod”’, with particular reference to the effectiveness of the four cases offered in supporting the centr

Describe carefully the decision making process, QUESTION 1 According to...

QUESTION 1 According to the systems approach, organizations are open systems today since they must interact with internal and external outside the organizations in order to sur

Explain a maslows theory of motivation, "No organisation can succeed witho...

"No organisation can succeed without a certain level of commitment and effort from its members. For that reason .... cholars have always formed theories about Motivation." (a)

Economise of maintenance, Maintenance is a costly activity. It is one of th...

Maintenance is a costly activity. It is one of the sizeable indirect costs that enter in to manufacturing and hence it should be given considerable attention by the operations

Where are the training and education different, Where are the training and ...

Where are the training and education different? The training and education are different from that of given level within content and method. 1. Work Force. 2. Middle Leve

What is corporate social responsibility, QUESTION Corporate Social Resp...

QUESTION Corporate Social Responsibility (CSR) is generally used to describe business's efforts to achieve sustainable outcomes by committing to good business practices and sta

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd