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

Benefits of having and environment management system, Question 1: (a) W...

Question 1: (a) What is the purpose of the EIA process (b) Differentiate between the terms environment impact and environmental aspect (c) Do you think public participati

Describe the key steps conducting an effective presentation, QUESTION 1 ...

QUESTION 1 Being able to deliver a stunning presentation has become increasingly important in the development of a successful managerial career. Based on your own experience

Short-term finance, discuss three approaches to the short-term finance prob...

discuss three approaches to the short-term finance problem and provide relevant examples for each

Please write a management report, Please write a Management Report consider...

Please write a Management Report considering your own organisation or department. Critically evaluate the ‘best practice' strategic Human Resource Management and Development proce

Towards effectiveness and efficiency in an organization, QUESTION Meeti...

QUESTION Meetings and committees have unfortunately acquired notoriety, being widely regarded as ineffective and wasteful of precious time (i) Give your views on the above

Strategic operations, Integrate operations management analysis into general...

Integrate operations management analysis into general business management planning and decision making

Show the cross-functional crm processes, Question: a. Research shows th...

Question: a. Research shows that there are five key cross-functional CRM processes that need to be considered by most organizations. What are they ? b. The emergence of CRM

What are the objectives of the trade unions, What are the objectives of the...

What are the objectives of the trade unions? The Objectives of trade unions are illustrated below: a. To take labour out of the competitive procedure; because when a number

What are types of entrepreneur on the basis of ownership, What are types of...

What are types of Entrepreneur on the basis of ownership? Classification on the Basis of Ownership: a. Founder or "Pure Entrepreneurs": Such individuals who are the f

How managers manage their specific environment, Question 1: All organiz...

Question 1: All organizations are being impacted by changes in both the internal and external business environment. In order to reduce the negative impact of these changes on t

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