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

Different types of change that an organization may face, QUESTION (a) O...

QUESTION (a) Organisations are systems that exist in the context of an external environment, an interdependent relationship, interact with it in order to survive and grow. Any

Comprehensive agenda for the participants of the meeting, Imagine that you ...

Imagine that you are the Chairperson of the Board of Studies of the Department of Management & Commerce of Sikkim Manipal University Department of Distance Education.  You have bee

Political pyramid, gaining comparatively at someone else''s expense

gaining comparatively at someone else''s expense

Definition of liquidity problem, An examination of up to three reasons is a...

An examination of up to three reasons is adequate for maximum marks. a)  Cash Flow estimate for Cottam Stationers Aug   Sep Oct Nov

Explain the problem of industrial marketing in india, Explain the problem o...

Explain the problem of industrial marketing in India. Problem of Industrial Marketing in India: Industrial market comprises all individuals and organisations which acquire

Describe organizational development and its process, Question 1 What is cu...

Question 1 What is culture? Explain its characteristics and list out the various types of culture Question 2 What is conflict in an organization? What are the sources and

Describe ebay activities, Question: A firm's connected activities are d...

Question: A firm's connected activities are defined as those activities that the firm must perform in order to deliver its customer value. A firm's strategy is said to be sound

Explain potential conflict between management and company, CRSL has a large...

CRSL has a large auditorium which can cater for 300 people and is ideal for formal balls and functions. The auditorium can also be reconfigured to cater for 100 people. The Seasons

Illustrate the total quality management briefly, Illustrate the Total Quali...

Illustrate the Total Quality Management briefly. Total Quality Management (TQM) is a system approach to quality within all spheres of the organisation. TQM implies meeting the

Explain the importance of good communication, Question 1: (a) Explain t...

Question 1: (a) Explain the importance of good communication in your organisation or in any organisation of your choice. (b) Describe the major barriers to good communicati

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