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

Why reputation management is important for your organisation, QUESTION ...

QUESTION You have freshly been appointed as the Quality Manager in your organisation following the completion of your studies. (a) Explain why reputation management is impor

Development of an environmental management system, Question: (a) Brief...

Question: (a) Briefly describe the five steps in the development of an environmental management system. (b) The environmental policy instruments have so far focused on t

Engineering Risk Management, Total Marks – 15 ( 1-2 pages answers) Large d...

Total Marks – 15 ( 1-2 pages answers) Large department stores are several storeys high and carry a wide range of products. In many of the departments, there are significant quanti

Prepare an eia for an integrated resort scheme, As an EIA Consultant you ha...

As an EIA Consultant you have been requested by a promoter to prepare an EIA for an Integrated Resort Scheme (IRS) project consisting of 150 Villas, an 18 Hole International Level

How are the internal pressures causes of organisational, How are the intern...

How are the internal pressures causes of organisational? Internal pressure: (a) Changes into the Managerial Personnel: It is one of the most frequent purposes for main

Effectiveness of modern organizations, Question 1: "Managing innovation...

Question 1: "Managing innovation is a challenge to management...." Peter Drucker How can management effectively manage innovation? Question 2: "Without exception, the d

Describe business process re-engineering, QUESTION a) What do you under...

QUESTION a) What do you understand by the term "Web Hosting"? Briefly describe two advantages and two disadvantages of having an independent Internet Service Provider to host y

How do you and your organization define system, Problem 1. How do you a...

Problem 1. How do you and your organization define system? Mention the systems that require engineering. Defining system Mentioning the systems that require engineerin

Analyze a work activity for organization, Analyze a work activity in your s...

Analyze a work activity in your selected organization using appropriate objective setting techniques. What are the management and leadership style used in your selected organiz

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