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

Benefits, inportant banafits of business communission

inportant banafits of business communission

Explain the individual and group managerial decisions, Explain the individu...

Explain the individual and group managerial decisions. Individual and Group decisions: Individual decisions are considered by a single individual into context of routine

Three approaches to short-tem financing problem, What are the three approac...

What are the three approaches to short-term financing problem?

Agency law, Aagency lawsk question #Minimum 100 words accepted#

Aagency lawsk question #Minimum 100 words accepted#

Explain updating and improving current product line, Explain about the cont...

Explain about the continually updating and improving the current product line. Creating a Constant Flow of New Products or Continually Updating & Improving the Current Product

What is the ath decision, Do you know What is the ATH decision, and what is...

Do you know What is the ATH decision, and what is it used for? Ans) Most of the investment world worships the bottom line market value of portfolios, and like as focus (without

What do you mean by morale, What do you mean by morale? Morale: T...

What do you mean by morale? Morale: The word morale usually has an implication of group reactions which is what motivation does to the particular; it does to the work gro

Advantages of functional structure, Organisations tend to organise their wo...

Organisations tend to organise their working areas by function, e.g. production, warehouse, sales and marketing, etc.  Business processes occur across these functional groups requi

Termination, how can a owner cancel the contract

how can a owner cancel the contract

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