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

Primary elements of zero inventories, Just  in time  production is defined ...

Just  in time  production is defined as philosophy that  focuses attention on eliminating waste by purchasing or manufacturing  just enough of the right items just in  time It i

Discuss the limits to rational decision-making, Question 1: (a) ‘Decisi...

Question 1: (a) ‘Decisions should be thought of as a means rather than ends. They are manager's responses to problems and the results of a process of thought and deliberati

What are the functions of the upper middle management, What are the functio...

What are the functions of the upper middle management? Upper middle management: This includes Sales executive (Manager), Finance executive, Production executive and R and

SElling personalized genetics, AskEvaluate the ethics of selling gene tests...

AskEvaluate the ethics of selling gene tests directly to consumers like these companies are doing. What would each of the three theories of a business’s duties to consumers say abo

Controlling environmental causes, Controlling Environmental Causes: All th...

Controlling Environmental Causes: All the  environment  causes have something  to do with  machinery  and equipment  with the  things  one can see and  feel. A  good  layout  and

National industrial relations system, QUESTION You have been asked to a...

QUESTION You have been asked to accept an international assignment that involves working in Nigeria for 2 years. Following the general trend, your employer will not provide a p

Differences between informative and persuasive presentations, QUESTION 1 ...

QUESTION 1 An effective team is one which achieves its tasks and satisfies its members. (a) Show, with examples, the characteristics of an effective team? (b) Describe ho

Analyse the functions of leaders in relation to task needs, QUESTION 1 ...

QUESTION 1 "The process of Communication involves the exchange of ideas, feelings and values to build up mutual understanding and good human relations." Give an account of the

Influence of personal ethics, Explain in relation to the organisation you r...

Explain in relation to the organisation you researched in Section A of this report why managers should use ethics to guide their own and other peoples' behaviour in the workplace.

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