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

Business, Sam bought a leather corner sofa and chair from SCS Edinburgh for...

Sam bought a leather corner sofa and chair from SCS Edinburgh for £5,490 in July 2009. Less than a year later, she noticed that the sofa’s stitching had started to unravel and repo

Explain what you understand by the term internal environment, Question : ...

Question : Many business people tend to forget the importance of the internal environment for the success of their organisation. They rather give more importance to the impact

Prepare an eia for an integrated resort scheme, As an EIA Consultant you ha...

As an EIA Consultant you have been requested by a promoter to prepare an EIA for an Integrated Resort Scheme (IRS) project consisting of 150 Villas, an 18 Hole International Level

Assignment, Dear I have assignment 2100 words I need more 900 words how can...

Dear I have assignment 2100 words I need more 900 words how can I now price

Factors that help to prevent resistance to change, Question 1: (a) Disc...

Question 1: (a) Discuss three different levels of Management. (b) Differentiate between omnipotent and symbolic view of managers. (c) Explain the different functions of M

Discuss the different steps in the process of control, QUESTION 1 (a) W...

QUESTION 1 (a) What is meant by controlling? Why is it needed in organisations? (b) Discuss the different steps in the process of control. What are the essential requirement

Discuss the project management knowledge areas, Question: (a) Project ...

Question: (a) Project Integration Management refers to the integration of the nine Knowledge areas and project phases, coordinating project activities to ensure that the proje

Organization, Organization: Organization is a community unit of nation...

Organization: Organization is a community unit of nation that is incorporated and focussed to gather a need or to practise communal goals in order to create a high-quality ser

Labour in promotion of productivity, What types of quality use for labour i...

What types of quality use for labour in promotion of productivity? Labour in promotion of productivity: a. Enhancement in work methods, via work study techniques b. Pr

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