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

Assignment, Dear I have assignment 2100 words I need more 900 words how can...

Dear I have assignment 2100 words I need more 900 words how can I now price

Importance of aligning projects with business strategy, Question: (a) T...

Question: (a) Today, project management is a standard way of doing business and has been widely adopted by many organizations. The key to success and productivity is often link

QUESTION, Differentiate between OLTP and OLPP

Differentiate between OLTP and OLPP

Explain effective decision making, Question 1: (a) List three types of ...

Question 1: (a) List three types of supervision styles. (b) Describe each of them, stressing upon their importance to you as supervisors. (c) Write short notes on two maj

Why prevention is better than cure , Discuss the cost of accidents to ...

Discuss the cost of accidents to an employer in from a perspective of why prevention is better than cure - The working surroundings within the organization shou

Explain the elements of the negotiation process, Question 1: Explain br...

Question 1: Explain briefly the seven elements of the negotiation process known as the Seven Pillars of the Negotiational Wisdom which need to be considered before and durin

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 quality measures and quality costs, Take examples of some common ser...

Take examples of some common service-oriented industries. For example, consider a commercial airline company and a company in the hotel business. For both these companies: De

Analyse the functions of leaders in relation to task needs, QUESTION 1 ...

QUESTION 1 "The process of Communication involves the exchange of ideas, feelings and values to build up mutual understanding and good human relations." Give an account of the

How do small companies compare to the major competitor, Question:  How do s...

Question:  How do small companies compare to the major competitor? The trade association magazine published a report that this company’s major competitor accounts for about 60%

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