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

Explain the communication cycle, QUESTION (a) What do you understand by...

QUESTION (a) What do you understand by ‘Communication' and ‘Organisational Communication'? (b) Work requires communication. Why do workers communicate? (c) Describe the v

An important role of management in promotion of productivity, How can manag...

How can management play an important role in promotion of productivity? Productivity means that more number of goods or output through the same amount resources or input. Manag

Describe the organizations culture, Think of an organization with which you...

Think of an organization with which you are familiar, perhaps one you have worked for or where you were a member. Then answer the following questions. 1) Using the jobs characte

Differentiate between the terms stakeholder and shareholder, In the contemp...

In the contemporary era, the board of directors has to shoulder larger responsibilities so as to meet the increasing demands of the market place. Running a corporation only to earn

#a review of two articles, prepare review of articles on the role/impact/co...

prepare review of articles on the role/impact/contribution of information system in business

Drawbacks of business-to-business (b2b) e-commerce, QUESTION a) Identif...

QUESTION a) Identify and describe the cultural and social factors that can influence buyers' decisions b) In a buying center purchasing process which buying center participa

EU, Provide a historical perspective of the EU by discussing how it started...

Provide a historical perspective of the EU by discussing how it started and where it is today. In addition, research the Christian Democratic Union (CDU) which is a Christian-based

Internal culture of the organisation , Describe how you, the manager of the...

Describe how you, the manager of the business, would use two (2) different forms of visible organisationl culture to encourage staff to learn to be "innovative" and expect, and cop

COMMERCIAL LAW, 10. State Z’s automobile manufacturing industry is one of t...

10. State Z’s automobile manufacturing industry is one of the largest and most highly regarded in the world. The industry is concerned that it may lose some of its domestic market

Sale management, state the reasons why you choose marketing as a profession...

state the reasons why you choose marketing as a profession

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