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 scopes of management information system, What are the scopes o...

What are the scopes of Management Information System? Scope of Management Information System is: a. For giving timely, accurate, relevant and whole information. b. For gi

Determine the purpose, Linking Strategic Organizational Initiatives to Purp...

Linking Strategic Organizational Initiatives to Purpose, Mission, and Vision Select an existing business that is entering into a new or emerging market for that company. You may

Just-in-time inventory control system, Plants : Numbers changes occur about...

Plants : Numbers changes occur about the plant which include plant layout multi function workers, demand pull production kanbans self inspection MRP ( material requirements pla

What is breakeven analysis, What is Breakeven Analysis? Breakeven Ana...

What is Breakeven Analysis? Breakeven Analysis: It implies that at several point in the operations, total revenue equivalents total cost. This analysis is concerned along

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

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

Ledership and organization behaviors, what are the challenges of only seein...

what are the challenges of only seeing the behaviors?

Explain the role of communication in conflicting situations, QUESTION 1 ...

QUESTION 1 Explain what you understand by the term "Feedback" and how this can help in improving communication in our work place environment. QUESTION 2 Who are organisati

The skills managers need to carry out the various functions, QUESTION M...

QUESTION Managing is guiding human and physical resources into dynamic organisational units which attain their objectives to the satisfaction of those served and with a high de

Organiation desgin, How could technology help solve the problems at the fro...

How could technology help solve the problems at the front desk? Explain what you propose very specifically and clearly. Please do not give round-about general answers.

Business communication in retail business, This final project is a case stu...

This final project is a case study worth 35% of the final grade for this course. Submission is mandatory, at the end of Module 10. Although this case has been designed to integrate

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