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

Explain the various types of networks, Question 1 Explain the various fact...

Question 1 Explain the various factors affecting the use of IT applications in the retail industry? Question 2 What is the impact of e-retailing in the travel and tourism

#title: Sole proprietorship, What are the features, advantages and disadvan...

What are the features, advantages and disadvantages of sole proprietorship

Write individual reflections after observing, Write individual reflections ...

Write individual reflections after observing three hours of instruction and analyzing three instructional tools (assessments or project assignments).  Requirements: For ea

Total productive maintenance, Total Production Maintenance is to achieve...

Total Production Maintenance is to achieve maximum profit all employee to minimize maintenance costs. a facility can be kept in good condition only by autonomous action and th

Advantages and disadvantange of the line organisation, advantages and disad...

advantages and disadvantange of the line organisation

Define business process benchmarking, Question 1: (a) Define Business ...

Question 1: (a) Define Business Process Benchmarking and explain why it is used in a company. (b) Describe four types or forms of Benchmarking methods. Give one a

Explain Relationship-marketing concept, Question 1: Discuss the importa...

Question 1: Discuss the importance of applying the relationship-marketing concept to the marketing activities of Wal-Mart. Question 2: Explain how Wal-mart can monitor

Caselet, What should Mr. Sharma have done to avoid the misunderstanding?

What should Mr. Sharma have done to avoid the misunderstanding?

Impacting upon intercultural communication, QUESTION 1 Distinguish betw...

QUESTION 1 Distinguish between the three broad theoretical frameworks that attempt to provide an explanation and understanding of communication and culture. QUESTION 2

Provide an outline of the balanced scorecard method, A) The future usefulne...

A) The future usefulness of any Performance Management initiative in an organization is underpinned by the determination of Key Performance Indicators (KPI). Provide a brief outlin

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