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

Effective use of interpersonal communication skills, QUESTION "There is...

QUESTION "There is a growing emphasis on the importance of interpersonal communication. This arises from the realization that the greatest challenges to management are not prob

#title., What kinds of problems can emerge if a firm doesn’t communicate wi...

What kinds of problems can emerge if a firm doesn’t communicate with environmentalists, the news media, and the local community? Why? Do you know of any firms that aren’t responsiv

Total operations orientation, Attend to machines predominantly only when t...

Attend to machines predominantly only when the machines breakdown ( breakdown maintenance or BM) Breakdown maintenance = BM

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

Stages in organizational development, Organizational development is a proce...

Organizational development is a process a workplace a group of people and their growth and development. Not only one's growth will matter but both the organization as well as the p

What are the features of an intelligent agent, QUESTION (a) Distinguish...

QUESTION (a) Distinguish between an Internet Incubator and Venture capitalists. (b) Describe the components of a supply chain management? (c) What is included in the deve

OPERATING CYCLE, DISCUSS THE APPLICABILITY OF OPERATING CYCLE IN VEGETABLE ...

DISCUSS THE APPLICABILITY OF OPERATING CYCLE IN VEGETABLE GROWING BUSINESS

Political environment analysis of car industry, Analyse the political Envir...

Analyse the political Environment of car distribution industry.

Different stages of team development, QUESTION (a) What are the differe...

QUESTION (a) What are the different stages of team development and elaborate on each of them and explain the importance of each of these stages. (b) The ‘reflective thinking

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