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

Discuss the limitations to rational decision making, Question 1: (i) A...

Question 1: (i) An organisation evolves in a specific and general environment. Discuss, using examples, the components of each environment. (ii) ‘Ethical workplace behavi

What is the prime aim of a good inventory control, What is the prime aim of...

What is the prime aim of a good inventory control? A good inventory control will aim to: 1. Procure material of good quality within time 2. It doesn’t to face shortage of

What is breakeven analysis, What is Breakeven Analysis? Breakeven Ana...

What is Breakeven Analysis? Breakeven Analysis: It implies that at several point in the operations, total revenue equivalents total cost. This analysis is concerned along

Explain what you understand by the term internal environment, Question : ...

Question : Many business people tend to forget the importance of the internal environment for the success of their organisation. They rather give more importance to the impact

The Marketing Environment : Consumers Confound Marketers, Identify all envi...

Identify all environmental factors that can affect the demand for consumers durables and assess the magnitude and direction of there impact.

Importance of culture - organizational culture, Importance of Culture - Org...

Importance of Culture - Organizational Culture When people are successful at what they undertake, the ideas and values that led to that success become institutionalized as par

Describe the food chain approach to food safety, Problem : a) Describe ...

Problem : a) Describe the food chain approach to food safety. b) ‘The Food Law Code of Practice sets out the way local authorities should apply food law, and how they would

Quality management system, Briefly introduce the subject and describe its k...

Briefly introduce the subject and describe its key business or operations. Appraise how it plans and manages quality. Analyse how quality can be used to support the strategies o

Improve business processes, Discuss why has direct marketing continued to g...

Discuss why has direct marketing continued to grow? Using Internet technology to improve business processes • Discuss how this technology can unlock new business opportunities •

Cultural context, Problem 1 a) What do you meant by cultural context? ...

Problem 1 a) What do you meant by cultural context? b) Differentiate between low-context cultures and high-context cultures. c) How will we improve intercultural commu

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