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

Categories of ratios for financial position and performance, What are categ...

What are categories of ratios for financial position and performance? Usually, there are four main categories of ratios every attempting to measure the financial position and p

What do you understand by business ethics, QUESTION 1 a) Explain the st...

QUESTION 1 a) Explain the strengths and weaknesses of Corporate Social Responsibility (CSR) b) Discuss the challenges faced by a government in the implementation of CSR poli

Case study, notate commendation to pmc

notate commendation to pmc

What are the advantages of work study, What are the advantages of work stud...

What are the advantages of work study? Advantages of work study: The given are the advantages of work study: a. Uniform and enhanced production flow, b. Higher prod

Briefly describe the main sources of organizational conflict, Question: ...

Question: "Conflict, then can be regarded as a reality of management and organizational behavior and can be related to power and politics... yet conflict is another term which

Disadvantages of breakdown maintenance, a. It results in dislocation of pro...

a. It results in dislocation of production process and causes excessive delays or reduction in output. b. Wages are to be paid for idle time resulting in loss of profits.

Explain what you understand by the term subculture, QUESTION 1 (a) Desc...

QUESTION 1 (a) Describe the theory of Behaviourism and Media effect, using day to day situations as examples. (b) (i) Explain what you understand by the term subculture?

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

Principles of Security, I need 3500 words there is tables. I can provide my...

I need 3500 words there is tables. I can provide my senior samples.. I need it by 15 Nov..

Factors - decision on proposed strategy change, Factors to Consider Before ...

Factors to Consider Before Taking a Decision on the Proposed Strategy Change Although most of the striking and important questions have been considered or highlighted which

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