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

#n4, Seal and ali want to for a loan from fnb bank to help the grow thir bu...

Seal and ali want to for a loan from fnb bank to help the grow thir business. They have come to you to assist them to draw up a business plan. They have asked you to be their busin

Discuss the exceptions to the law of demand, Question 1 Discuss the except...

Question 1 Discuss the exceptions to the law of demand Question 2 Explain Elasticity of Supply with the help of a diagram and factors affecting elasticity of supply

Determine the average waiting time, Build a simulation model using the dist...

Build a simulation model using the distributions you get in part A to verify whether the claim by trucking associations that the average time it takes a truck to cross the border h

Effective oral communication, QUESTION 1 (a) Explain the term "Team". ...

QUESTION 1 (a) Explain the term "Team". (b) Elaborate on the characteristics of effective teams. (c) Discuss the benefits of effective teams to an organisation. QUEST

What are the important provisions for employee health, What are the importa...

What are the important provisions for employee health? Important provisions of Factory Act, 1948 about health: The given are the significant provisions for employee

BUSINESS EVIRONMENT, Ask question #MinYou are required to investigate and e...

Ask question #MinYou are required to investigate and explain the key factors that drive globalisation as well as the key challenges this creates when operating globally. This will

Business-to-consumer trading through online trading, Technology has transfo...

Technology has transformed organisations, industries and ways of doing business.  Explain the reasons for the growth of business-to-consumer (B2C) trading through onlin

Communication, outline with example four main barriers to communication

outline with example four main barriers to communication

GE matrix, What are the characteristics of each component of the GE matrix...

What are the characteristics of each component of the GE matrix?

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