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

Problem based on bags r us ltd, Bags R Us Ltd P&L Account for Bags R Us...

Bags R Us Ltd P&L Account for Bags R Us, year ended 31 st March 2008.   $ $ Sales ($35 * 3,000)   105,000

Define the concept and goal of the extraction, (a) Define the concept and g...

(a) Define the concept and goal of the Extraction, Transformation, and Loading (ETL) functionality in relation to the Data Warehouse (DW) solution.  As part of your answer, briefl

Define organization behaviour, Question 1: (a) (i) Define organization...

Question 1: (a) (i) Define organization behaviour. (ii) Describe the various fields of organizational behaviour and explain their contributions to Organisational Behaviour

Describe how an organization can assess its service quality, Question 1: ...

Question 1: (a) Total Quality Management (TQM) is an approach to improving the effectiveness and flexibility of a business as a whole (Oakland, 1989). Discuss three of the co

Define the major classes of risk an organization, What are the four major c...

What are the four major classes of risk an organization evaluates while outsourcing? Explain them. 1. Strategic risks. 2. Operational risks. 3. Result risks. 4. Transac

How is grievance defined, How is Grievance defined? A Grievance may be ...

How is Grievance defined? A Grievance may be described as any feeling of dissatisfaction or discontent, whether expressed or not expressed and whether is valid or not, occur ou

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

Explain common types of organizational change, Q. Explain Common types of o...

Q. Explain Common types of organizational change? Organizational change holds risks and rewards. The main common types of organizational change are automation and rationalizati

Global trading, how would you incorporate political risk into the capital b...

how would you incorporate political risk into the capital budgeting process of foreign investments specifically in the philippines

Quality audit, Quality audit is an appraisal of the whole quality control....

Quality audit is an appraisal of the whole quality control. It is not so much concerned with the quality of the product as with the quality of the product as with the adequa

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