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

Influence of personal ethics, Explain in relation to the organisation you r...

Explain in relation to the organisation you researched in Section A of this report why managers should use ethics to guide their own and other peoples' behaviour in the workplace.

Importance of communication networks in an organization, QUESTION 1 Dis...

QUESTION 1 Discuss the importance of communication networks in an organization like the fisheries. Draw a diagram of one of the network you usually use and discuss its advantag

Explain approach to business processing re-engineering, Compare and contras...

Compare and contrast the following terms: Process Re-engineering and Continuous Improvement. Discuss the differences between a 'clean slate' and a 'technology enabled' approach to

Describe four types of transaction cost, Many organisations are making deci...

Many organisations are making decisions to outsource some of their activities. Though, when considering the option to outsource, organisations have to consider the transaction cost

Capital expenditure program, Capital Expenditure Program Stanaway had a...

Capital Expenditure Program Stanaway had assumed responsibility for the Glenlines Plant only twelve months previously and undertook a detailed review of the operations and disc

Minority diversity, American Express Company and Merrill Lynch and Company ...

American Express Company and Merrill Lynch and Company use African-American employees to hold workshops and networking receptions in venues such as black museums to attract black i

Write short notes on casual labour, Q. What do you mean by casual labour an...

Q. What do you mean by casual labour and what are the rules for their recruitment and benefits admissible to them after they attain temporary status. Write short notes on casual

Corprate Culture, Why are symbols important to a corporate culture?

Why are symbols important to a corporate culture?

Explain five benefits of delegating effectively, QUESTION 1 (a) Describ...

QUESTION 1 (a) Describe the process that a Procurement and Supply Manager might apply to effectively delegate when managing the Procurement and Supply function (b) Explain f

Define the conceptual skills of a successful manager, Define the conceptual...

Define the conceptual skills of a successful manager. Conceptual skill: Conceptual skill is the capability to see the organization as an entire, to recognize inter-relati

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