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

What are the various stages of the decision making process, What are the va...

What are the various stages of the decision making process? Decision Making Process: A good decision can merely be made as a result of a rational decision making process.

Define the terms globalization and informatisation, QUESTION 1 (a) Defi...

QUESTION 1 (a) Define the terms globalization and informatisation. (b) Critically discuss how is globalization and informatisation impacting upon intercultural communication

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

How is the consideration of objectives affected, How is the consideration o...

How is the consideration of objectives affected? Consideration of objectives: As the objectives have a significant bearing onto the organization structure, merely those o

Characteristics of business process reengineering, The major characteristic...

The major characteristics are: 1. Several jobs are combine into  one. 2. Employees make decisions ( empowerment of  employees.) decision making  becomes  part of  the job.

What is persuasive communication, QUESTION 1 Explain the importance of ...

QUESTION 1 Explain the importance of the i) Perceptual, ii) Behavioural and iii) Relational consequences of communication. QUESTION 2 Using a concrete example

Impact of climate change on the automobile industry, Question 1: (a) E...

Question 1: (a) Explain the impact of climate change on the automobile industry. (b) The reliance on emerging technologies in the age of information is undeniable. Using e

Briefly discuss how management theory evolved, QUESTION Great feats of ...

QUESTION Great feats of human achievement such as the Egyptian pyramids, the Great Wall of China, the Colosseum in Rome and the Taj Mahal in India all bear testimony to skilled

Principles and practices of management, #what are the drawbacks in classica...

#what are the drawbacks in classical and neo classical theories of management

Proposal arguments, the strategies that are used to strengthen a proposal a...

the strategies that are used to strengthen a proposal argument and examples of each.

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