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

Potential impacts of an agricultural project, (a)(i) State the major advant...

(a)(i) State the major advantages of using matrices for conducting EIAs.   (ii) Explain how overlays are essential tools for assessing potential impacts of an agricultural proje

Sks7000 marketing flyer, How can your answer be free of plagiarism what ass...

How can your answer be free of plagiarism what assurance will you give me that another person from the same school will not order for the same material

logistics, whats the economic justification for rapid growth of preminum p...

whats the economic justification for rapid growth of preminum package serivices

Measures of a web site''s performance, QUESTION (a) Briefly describe th...

QUESTION (a) Briefly describe three sticky features that Web sites use to attract and keep visitors. (b) Provide a detailed discussion on cookies, by giving two advantages a

What are relationships, Question 1 What are relationships? Explain the rel...

Question 1 What are relationships? Explain the relationship types Question 2 Explain Second Normal and Third Normal Form. Explanation of second normal form Question 3 Explain

What is the business process outsourcing, Problem 1: (a) What is the de...

Problem 1: (a) What is the definition of Business Process Outsourcing according to Gartner Dataquest? (b) BPO deals mainly with non-core processes of an organisation. Descri

Conduct a force-field analysis, Enacting change is difficult. The forces th...

Enacting change is difficult. The forces that create the need for change often bump up against equally powerful forces of resistance. Think of an organization with which you are fa

Identify any one Charismatic leader in an organization, Use the features of...

Use the features of Charismatic Leadership to analyse the man or woman.

Organisations and behaviour, discuss the impact that different leadership s...

discuss the impact that different leadership styles may have on motivation in orhanisations

Describe the importance of planning in an organisation, Question 1: PAR...

Question 1: PART 1 Planning is one of the primary functions of management. (a) Describe the importance of planning in an organisation. (b) How will managers develop

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