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

Communication conflicts in modern business environment, Question 1: The...

Question 1: There are various communication conflicts in modern business environment. Project conflicts are somehow inevitable. (i) Show some of the possible sources of pr

Models of human resource management, breifly describe the following models ...

breifly describe the following models of human resource management; 1the guest model of hrm 2the michigan matching model of hrm 2the harvard model of hrm 3the john storey model of

How is the lead time determined, How is the lead time determined? Lea...

How is the lead time determined? Lead Time comprises: a. Time to procedure the enquiries and to put the order b. Time to deliver the command to the supplier c. Tim

Plant layout - product oriented vs. process oriented, Plant Layout: Product...

Plant Layout: Product Oriented Vs. Process Oriented The argument is never going to end and we don't claim either to solve the issue. The simplest explanation to choice of layou

Case of flex bump, Case of Flex bump Becker and Fagen are two observer...

Case of Flex bump Becker and Fagen are two observers of organizations. They are attempting to understand organizational dynamics, developments, and strategies in the firm FLEX

Organising behaviour, what could you do to make Rajinder?s transition easie...

what could you do to make Rajinder?s transition easier?

Tax differential theory, Tax differential theory: a method of valuing share...

Tax differential theory: a method of valuing shares with constant growth to DI/P0 Xg An investor is faced with 2 investment choices: First choice of shares with market price(po)=Rp

Elaborate the types of psychographic segmentation, Question 1 Analyse t...

Question 1 Analyse the economic factors that affect the commercial real estate market in USA 2 Elaborate the types of Psychographic Segmentation 3 Explain the concepts 1.

M.COM, What are the rationale of transfer of technology? Describe various n...

What are the rationale of transfer of technology? Describe various non-equity forms of technology transfer by TNCs and Small and Medium Enterprises

Business communication, How communication helps in the operator of business...

How communication helps in the operator of business? I don''t solve the question perfectly please give some solution

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