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

Nature of the production systems, It is characterized by the number of m...

It is characterized by the number of manufacturing stages and the inter relationship between various production operations e, g, in product line systems inventory con

Left or right?, whom do you think rajender will eat with ?why?

whom do you think rajender will eat with ?why?

Total quality of services, Many services are intangible and by their ver...

Many services are intangible and by their very nature it is difficult to determine their quality. Take for example, the problem that airlines face when they try to determine

What do you meant by swot analysis, Question: (a) Name clothing Busines...

Question: (a) Name clothing Business terms e.g. ready to Wear and give a brief description of the term. (b) What does merchandising imply in an apparel industry? (c) What a

Describe strategic businesses - it alignment perspective, Briefly describe ...

Briefly describe two strategic businesses- IT alignment perspectives, proposed by Henderson and Venkatraman (1993), where the IT strategy is the "enabler" of business strategy. For

Spreadsheet automation using vba code, Use VBA code that will be triggered ...

Use VBA code that will be triggered on the click of a button on the order sheet, to add the order for each garden to the Sales Database sheet. Produce a written comparison of sp

Explain how the group can make better decisions, QUESTION From the birt...

QUESTION From the birth of a group to the death of the group, groups go through many stages of development. One of the most popular descriptions of group development is Tuckman

Why prevention is better than cure , Discuss the cost of accidents to ...

Discuss the cost of accidents to an employer in from a perspective of why prevention is better than cure - The working surroundings within the organization shou

Performance management systems, QUESTION 1 As the Human Resources manag...

QUESTION 1 As the Human Resources manager of an organization of your choice, discuss how Maslow's theory of human motivation and the goal theory can be applied for managing peo

Forecast the sales of a new product, Question: (i) Give two examples of...

Question: (i) Give two examples of diffusion models that could be used to forecast the sales of a new product. (ii) With reference to common pattern portrayed by the lifecy

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