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

Bureaucratic management, nestle is an orgnization wether bureacratic approa...

nestle is an orgnization wether bureacratic approach approperiate for the organizational performance or not?

Manchester united football club, Manchester United Football Club a) By...

Manchester United Football Club a) By opting for the AIG sponsorship deal worth £56.5m, MUFC is prior the larger deal of £70m, i.e. the opportunity cost is the extra £13.5m ha

What is the grievances handling, What is the Grievances Handling? Gri...

What is the Grievances Handling? Grievances Handling: Individual workers usually have several complaints called grievances in opposition to the working rules of the busin

Describe theory of maslow, Describe Theory of Maslow Outline the meani...

Describe Theory of Maslow Outline the meaning of Motivation as it applies in the work place.  Give a framework (a map) of the various relevant theories. Individual Componen

Executive safety committee, Executive Safety Committee: The  executive  sa...

Executive Safety Committee: The  executive  safety committee consist of presidents  representative the general manager the  plant  superintendent  and the  sales manager. The chie

Explain any five qualities of an outsourcing project leader, Briefly explai...

Briefly explain any five qualities of an outsourcing project leader. 1. Ability to embrace and support change. 2. Earned credibility across the organization. 3. A desire

Innovation in business management, I have an assignment as a report writing...

I have an assignment as a report writing and ppt in which I need to present new idea and write report on same. Can you make that assignment for me ? you need to develop a new busin

CON216 - Legal Consideration in Contracting, An inventor developed a new tu...

An inventor developed a new turbofan blade for jet engines. He obtains a patent for the new design and sells all his patent rights to the design to Acme Jet Engine Company. Acme th

Explain the term internal environment of an organisation, QUESTION Many...

QUESTION Many business people tend to forget the importance of the internal environment for the success of their organisation. They rather give more importance to the impact of

Strategic direction perspective, The IMP focuses on the analysis of the cur...

The IMP focuses on the analysis of the current position of an organisation with which you are familiar and the valuation of managerial alternatives (decisions) for maximising its v

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