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 is matrix organisation, What is Matrix Organisation? Matri...

What is Matrix Organisation? Matrix Organisation: This organization is used while an organization has to handle several of projects, ranging through small to huge.

Explain five benefits of delegating effectively, QUESTION 1 (a) Describ...

QUESTION 1 (a) Describe the process that a Procurement and Supply Manager might apply to effectively delegate when managing the Procurement and Supply function (b) Explain f

Methods of work force in the training and education, What are the methods o...

What are the methods of work force in the training and education? Work Force: At this level the workers are to be familiarised with the job, with the organisation and are

Organizational climate and organizational culture, QUESTION 1 a) Differ...

QUESTION 1 a) Differentiate clearly the concepts "Organizational Climate" and "Organizational Culture". b) Organizations make use of two different approaches for managing or

Benefits of holding inventories, There are three main purposes or motive...

There are three main purposes or motives of holing inventories: a. The transaction Motive : Which facilitates continuous production and timely execution of sales orders

Describe breaking geographic business barriers, Q. Describe Breaking Geogra...

Q. Describe Breaking Geographic Business Barriers? Several companies today operate from several locations and have customers or suppliers at distant locations and do business i

Transactional leadership, Transactional leadership: The transactional ...

Transactional leadership: The transactional leadership is one more category of leadership style at which point the leader accepts certain tasks to perform and provide rewards

Explain effective decision making, Question 1: (a) List three types of ...

Question 1: (a) List three types of supervision styles. (b) Describe each of them, stressing upon their importance to you as supervisors. (c) Write short notes on two maj

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