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

International Business, Based on the article Nearshoring in Latin America,...

Based on the article Nearshoring in Latin America, what are the short- and long-term implications of nearshoring given the current economic conditions?

Risk and Return, In a report not to exceed five double-spaced typewritten p...

In a report not to exceed five double-spaced typewritten pages, analyze the results obtained from the three simulations performed, identify the source of the differences, and selec

Investment strategy, Outline what investment strategy you as the investment...

Outline what investment strategy you as the investment manager might have adopted in a past time period in meeting a principal investors' objectives with an allocated fund of £1,00

Mrp, what are the factors affecting the calculations of material requiremen...

what are the factors affecting the calculations of material requirement planning ?

Characteristics of business process reengineering, The major characteristic...

The major characteristics are: 1. Several jobs are combine into  one. 2. Employees make decisions ( empowerment of  employees.) decision making  becomes  part of  the job.

55 % of communication is depending on non-verbal signals., According to the...

According to the study, 55% of communication is depending on non-verbal signals. This suggests that the body language is critical to good communication skills. This is possibly

Business and cultural, Judge how the business and cultural environments sha...

Judge how the business and cultural environments shape the behaviour of a selected organisation

What do you understand by the term viral marketing, QUESTION a) Top Mob...

QUESTION a) Top Mobile Company ltd deals in mobile phones. For the last two years, the company has been using traditional marketing tools like newspapers, pamphlets and radio t

Explain about the term lead time, Explain about the term Lead Time. L...

Explain about the term Lead Time. Lead Time: It is the time which takes the stock to reach through Re-order point to minimum stock level. This may be also described as th

Assigment, Ask question #MinimObjective Upon successfully completing this ...

Ask question #MinimObjective Upon successfully completing this assignment you will have demonstrated that you can provide clear written advice, and recommendations for change, to

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