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

Public systems management, luther gulick and lyndall uruick identified seve...

luther gulick and lyndall uruick identified seven management functions coined POSDCORB,explain the role of the model in converting a given policy into useful outcomes

MEQA501, Today is your first day working for MarmaMed, a firm that produces...

Today is your first day working for MarmaMed, a firm that produces and sells a small range of medical diagnostic products. MarmaMed’s main product is the DiagnoKit™, a simple-to-us

What caused the great depression, The business boom of the 1920s made peopl...

The business boom of the 1920s made people overly confident thus; they invested their money in risky stocks and deals. In addition, banks made careless loans and soon failed when p

The world economy is globalizing at an accelerating pace, Question 1 Th...

Question 1 The world economy is globalizing at an accelerating pace. What do you mean by globalization? Describe the merits and demerits of Globalization Question 2 The

Electronic purchase orders, QUESTION 1 (a) Requirements engineering is ...

QUESTION 1 (a) Requirements engineering is the process of discovering, documenting and maintaining a set of requirements for a computer - based system. What are requirements?

Planning process control network, The process controls mainly pertain to t...

The process controls mainly pertain to the activities which are required to be carried out at any particular stage of the process. Often the final product will comprise of a

How important is the concept of motivation, Question 1: Define Communic...

Question 1: Define Communication and account for the dominant role which it plays in the function of Organisations. Question 2: Describe Planning and give an account of

What are the major services of management information system, What are the ...

What are the major services of Management Information System? The MIS (Management Information System) provides information onto the past, present and projected future and on as

E-commerce, can you guys make e-com website for project ?

can you guys make e-com website for project ?

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