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

What are behavioural barriers to intercultural communication, QUESTION ...

QUESTION "Cultural differences affect intercultural encounters, usually by leading to misunderstanding or conflict, at both the individual and the group level" (a) Explai

Define the conceptual skills of a successful manager, Define the conceptual...

Define the conceptual skills of a successful manager. Conceptual skill: Conceptual skill is the capability to see the organization as an entire, to recognize inter-relati

Explain the purpose and relevance of a business plan, Question 1: (a) E...

Question 1: (a) Explain the purpose and relevance of a business plan within the hospitality sector. (b) Discuss the importance and role of market research within business pl

Layout and design of the food processing plant, Question : KVC is situa...

Question : KVC is situated about 50 km out of Vacoas. It produces organic jams, chutneys, juices, purees etc. and exports to African countries under the label "Legends". It als

Organizing , critically discuss the 5 fundamentals of organizing

critically discuss the 5 fundamentals of organizing

Help, Can I work here as assignment writer?

Can I work here as assignment writer?

Differentiate between tall and flat organizations, QUESTION (a) (i)...

QUESTION (a) (i) What is information overload? Illustrate your answer through a practical example. (ii) How could each of the factors below contribute to information ove

Briefly describe the scope of quality management system, Question 1: Br...

Question 1: Briefly describe the scope of Quality management system. Show the key benefits of all eight principles of Quality management system. Defining Quality Manageme

Adequate storage facilities, Adequate and well organized warehouse facil...

Adequate and well organized warehouse facilities with went equipped proper handling facilities must be there. It need not necessarily be elaborate and expensive. Such

Maintanace, as an enterpreneur ,if given 50000 what business would you do?

as an enterpreneur ,if given 50000 what business would you do?

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