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

Describe carefully the elements which contribute to attitude, QUESTION ...

QUESTION Personal attitudes can have a key bearing on how individuals function within organizations. Attitudes may reflect in either positive or negative behaviours. A number o

Organizations corporate structure, Select an organization of your choice. T...

Select an organization of your choice. The organisation could be one where you work or one where a close family member, or friend, works. It is important that you have access to a

Practices of management.., HOW WILL YOU INFLUENCE PEOPLE TO STRIVE WILLINGL...

HOW WILL YOU INFLUENCE PEOPLE TO STRIVE WILLINGLY FOR GROUP OBJECTIVES IN YOUR ORGANISATION (TARGET BASED INDUSTRY ) APPLY YOUR INTERPERSONAL INFLUENCE THROUGH COMMUNICATION PROCES

Communication, outline with example four main barriers to communication

outline with example four main barriers to communication

Option for organising business, compare the liability of the owners of part...

compare the liability of the owners of partnerships, sole proprietorship and corporations.

Carrying out a training need analysis for an organization, Question 1: ...

Question 1: "Training is usually treated as a cost in many organizations rather than an investment since in difficult times, many organizations cut their training budget first

Dimensions of workforce diversity, The term 'workforce diversity' in its br...

The term 'workforce diversity' in its broadest sense encompasses many dimensions. The researchers have classified such dimensions into many categories. According to the study ( Spo

Main approaches to quality that are available to ld2, The LD2 group has gr...

The LD2 group has grown rapidly over the past five years by acquiring a number of smaller kitchen accessory manufacturers and kitchen suppliers and fitters. As a consequence of thi

Example of tqm in services, Customers are surveyed every three months t...

Customers are surveyed every three months to determine how satisfactory the bank services are to customers. Areas of deficiency are identified policies are reviewed and co

What volume of sales will be essential to cover, What volume of sales will ...

What volume of sales will be essential to cover? The reasonable return of capital utilised to cover the volume of sales as: - Ordinary and preference dividends, and - Res

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