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

Describe the most common decision making model, Question 1: (a) Describ...

Question 1: (a) Describe the three most common decision making models. (b) Describe the steps which lead to rational decision making. Question 2: (a) Using Herzberg

Define scope and functions of public relations, Define Scope and Functions ...

Define Scope and Functions of Public Relations? Scope a)    Receive information from public b)    Advise management of attitudes and response c)    Set policies and

Benefits from preventive maintenance, a. Reduction of the total time an...

a. Reduction of the total time and consequent reduction in production losses. b. Reduction nin the number or major repairs and consequently reduced maintenance expens

What are the middle management functions, What are the middle management fu...

What are the middle management functions? Middle Management: This includes Superintendents, General Managers and Branch managers. Middle management Functions are: 1

The main objectives of the public procurement act 2006?, QUESTION 1 (i)...

QUESTION 1 (i) Explain in detail the typical stages of the procurement cycle (ii) Describe briefly the relationships between the finance and the procurement functions within

Business plan to start a specialty coffee joint, On an individual basis, fo...

On an individual basis, formulate a business plan to start a specialty coffee joint at an appropriate "chic location" in Singapore. The business plan has to be well written so that

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

[email protected], #questionHow will you influence people to strive will...

#questionHow will you influence people to strive willingly for group objectives in your organization (target based industry)? Apply your interpersonal influence through communicati

Major types of information systems, QUESTION The Swoosh Ltd (SW Ltd) is...

QUESTION The Swoosh Ltd (SW Ltd) is a company engaged in the manufacture of t-shirts for the local market and for exports. SG Ltd is still using manual procedures across all it

ABC LIMITED, List some scientific decision aids that you may prescribe to i...

List some scientific decision aids that you may prescribe to improve the situation.

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