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

Question, What role should external factors of demand play in successful bu...

What role should external factors of demand play in successful business models?

Two bin techniques, Two Bin Techniques : One of the oldest systems of i...

Two Bin Techniques : One of the oldest systems of inventory control is the two bin system, which is mainly adopted to control C group inventories. In the two bin system

Innovation and entreprenuership, Discuss De-cruitment in the context of the...

Discuss De-cruitment in the context of the Break-Even model

Manage finance, strategic oppurtunity for new product

strategic oppurtunity for new product

Evaluate the business objectives, On 15 January 2010, a German bank, Schwar...

On 15 January 2010, a German bank, Schwarzböse, will complete the acquisition of a UK financial services provider, Klesvask, that offers pensions, insurance and investments. Klesva

How is line and staff functions affected in organisation, How is the line a...

How is the line and staff functions affected in the organisation? Line and Staff functions: every activities of an organization can be categorised in Supporting and Prima

Write short notes on partnering, Problem Write short notes on partnerin...

Problem Write short notes on partnering? a) Three broad categories of relationships(Adversarial, Barometric, Complementary) b) Goals of partnership(Reduction in waste , S

Modes of Entry and Internalisation, ‘Although the elegance and comprehensiv...

‘Although the elegance and comprehensiveness of transactions costs reasoning has provided the internalisation approach with a powerful logic (Rugman, 1981, 1985), it is still defic

Explain how good people management can help an organization, QUESTION T...

QUESTION The Euro crisis will have a major impact on the Mauritian economy. Many businesses in Mauritius depend on European countries for the exportation of their products and

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