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

Evaluate the companys approach to innovation management, Select a company o...

Select a company of your choice. You are to analyse, evaluate and critique the company's approach to Innovation Management. Identify who the key player/s is/are? Comment on the ty

Explain epayments, Question 1 International banking system enables trading...

Question 1 International banking system enables trading in multiple currencies. Explain the concept and need of international banking Question 2 Define and explain capital a

Leadership and organization, contrast the advantages and disadvantages on j...

contrast the advantages and disadvantages on just-in-learning

Leadership skills in decision making, QUESTION Explain the followings t...

QUESTION Explain the followings terms with examples- a) Crisis Problems, Structured Problems, Unstructured Problems b) Ethics in decision making c) Leadership skills i

Project management skills, You should present a reflective review of the pr...

You should present a reflective review of the project as a whole. You should make specific comments about how the project was managed? What was done well? What could be improved? W

the fundamental considerations, a) Explain leadership styles to fit cultur...

a) Explain leadership styles to fit cultural differences and effectively operate in global markets. b) Explain the principal theories of leadership and motivation, and Explain t

What are the barriers to successful communication, What are the barriers to...

What are the barriers to successful communication? Barriers to Successful Communication: A barrier to successful communication does not allow the transmission of accurate

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

advantages and disadvantange of the line organisation

Account setup - business processes, When a customer wants a prescription fi...

When a customer wants a prescription filled, a sales associate receives the member's card and prescription and logs the request in a prescription log which contains the member's nu

Benefit of product oriented layout, Benefit of Product Oriented Layout ...

Benefit of Product Oriented Layout Why Product Oriented Layout is more efficient than Process Oriented? Though going for a Product or Process oriented layout depends upon

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