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

What are the advantages of work study, What are the advantages of work stud...

What are the advantages of work study? Advantages of work study: The given are the advantages of work study: a. Uniform and enhanced production flow, b. Higher prod

Describe the major components of a business plan, Question 1: Before st...

Question 1: Before starting a small business, individuals need to ensure that they have certain essential characteristics. Discuss the personal characteristics that are requi

Discuss in the light of the benefits and costs arising, QUESTION ‘Sever...

QUESTION ‘Several developing countries have joined one regional integration group or another with the hope of addressing common problems in a collective and coordinated manner.

Business research report, You have been hired by Austrade to write a report...

You have been hired by Austrade to write a report advising on the attractiveness of Australia for manufacturing and service operations competitiveness. Your task will be to conduct

What are the benefits of effective business communication, QUESTION 1 a...

QUESTION 1 a) Explain the seven elements involved in a Communication Process b) With reference to the 7C's and 4S's, explain how communication can be improved in a business

Competitive strategies for information system, Q. Competitive strategies fo...

Q. Competitive strategies for Information system? Business is capable to develop competitive strategies to counter the action of the competitive forces they confront the market

Pessimists are more likely than optimists, QUESTION It is widely assume...

QUESTION It is widely assumed that optimists have qualities that pessimists should try to acquire. The importance of "the power of positive thinking" is often being stressed. H

Different types of change that an organization may face, QUESTION (a) O...

QUESTION (a) Organisations are systems that exist in the context of an external environment, an interdependent relationship, interact with it in order to survive and grow. Any

Explain strategic framework for crm, Question 1: Name and explain the ...

Question 1: Name and explain the three types of CRM that you know about? Question 2: a. Name the Seven best practices in making vision and values work. b. Give three e

Organizational diagnosis - organizational structure, Organizational diagnos...

Organizational diagnosis helps to determine the goals as per the performance level in terms of current and past performance. It measures the organizations development to achieve th

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