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

Illustrate the definition of work measurement, Illustrate the definition of...

Illustrate the definition of work measurement? Definition of work measurement: Work measurement is described as the application of techniques designed to set up the time

Write a press report of reassure the international community, QUESTION 1 ...

QUESTION 1 History is replete with cases where organizations fail as a result of poor or no communication especially in periods of crises. With what you have learnt from the lo

How would you define such type of hazard, A large, 100+ seat inbound call c...

A large, 100+ seat inbound call centre has been getting feedback from the Australian Services Union that their members are dissatisfied with working conditions. The most recent ma

Describe the most common decision making model, Question 1: (a) Describ...

Question 1: (a) Describe the three most common decision making models. (b) Describe the steps which lead to rational decision making. Question 2: (a) Using Herzberg

What are the pitfalls and benefits of planning, Question 1: i) Differen...

Question 1: i) Differentiate between internal and external environment in which an organization operates. ii) How managers will reduce the influence of the external environ

Explain the difference between social obligation, Question: In Mauritiu...

Question: In Mauritius, the government has reduced the corporate tax and consequently, it expects private sector organizations to spend a percentage of their profits on project

Demerits of specialisation include-exquisite flowers, Demerits of specialis...

Demerits of specialisation include: There is superior risk in providing only a restricted range of products or services, i.e. individual traders are not capable to enjoy

Personnel Management Case Study, Personnel Management Case Study "Adobe Co...

Personnel Management Case Study "Adobe Consulting Services (ACS), a provider of HR software application systems, prides itself on the variety of benefits it offers employees. In a

Discuss the key benefits of e-business, Question 1: Name and Discuss th...

Question 1: Name and Discuss the key benefits of E-Business? Question 2: (a) Describe the four activities of a Customer Service Life Cycle. (b) Define the Three (3) B

Business finance, Approaches to short-term financing problem?

Approaches to short-term financing problem?

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