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

Procedure for planned maintenance, maintenance procedure is to prepare the...

maintenance procedure is to prepare the facility register. The facility defines what is to be maintained. It gives the complete details of all the items and facilities whic

Describe the concept of the value chain, Question 1: a) Explain how a b...

Question 1: a) Explain how a business could carry out market research. b) Describe the difference between selling and marketing. c) Describe the 4 main international mark

#SWOT, Rate, from best to worst, each of the sources you indicate in Questi...

Rate, from best to worst, each of the sources you indicate in Question 1 above as being sources you will use in your analysis in terms of its probable reliability. Discuss the ste

How are internet technologies affecting the organizations, How are Internet...

How are Internet technologies affecting the structure and work roles of modern organizations? For example, will middle management wither away? Will companies consist primarily of s

Culture - organizational culture, Culture - Organizational Culture Som...

Culture - Organizational Culture Some people think of culture as the character or personality of an organization. How an organization looks and "feels" when you enter it is a

Institutional requirements for successful privatization, Question 1: Su...

Question 1: Successful privatization rests on government's ability to organize the process of change. Show the institutional requirements for successful privatization and the r

What are the advantages of work study, What are the advantages of work stud...

What are the advantages of work study? Advantages of work study: The given are the advantages of work study: a. Uniform and enhanced production flow, b. Higher prod

Explain sources of manpower recruitment from the company, Explain the sourc...

Explain the sources of manpower recruitment from within the company. Sources of manpower recruitment from the company: Given are the sources of manpower recruitment for any

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

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