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

Define the scope of total quality management in brief, Define the scope of ...

Define the scope of total quality management in brief. Scope of TQM: Total Quality Management is a system approach to quality within all spheres of organisation. It impli

Feasibility of solar power plant, Solar Power Plant: Nowadays, renewab...

Solar Power Plant: Nowadays, renewable energy sector is growing rapidly as demand of the renewable energy services are increasing rapidly that refers the growth in this sector

Project, critical evaluation of CSR activities of Oracle?

critical evaluation of CSR activities of Oracle?

Innovation and entreprenuership, Discuss De-cruitment in the context of the...

Discuss De-cruitment in the context of the Break-Even model

logistics, whats the economic justification for rapid growth of preminum p...

whats the economic justification for rapid growth of preminum package serivices

E-commerce cost benefit analysis, Sun Gas wants to move its sales order sys...

Sun Gas wants to move its sales order system to the Web. Under the proposed system, gas stations and other merchants will use a Web browser and, after typing in a password for the

What is performance management and what are its aims, QUESTION 1 What a...

QUESTION 1 What are the main steps involved in the process of recruitment and selection? QUESTION 2 (a) What is performance management and what are its aims? (b) Dis

The world economy is globalizing at an accelerating pace, Question 1 Th...

Question 1 The world economy is globalizing at an accelerating pace. What do you mean by globalization? Describe the merits and demerits of Globalization Question 2 The

Organization behavior, Describe the three stages of change. Why is it criti...

Describe the three stages of change. Why is it critical that each stage be fully implemented before moving to the next? Provide concrete, detailed examples and explain how each fit

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