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

Analyse the business and information management issues , You have been appo...

You have been appointed as part of a consultancy team that has been commissioned to assess the management issues concerned with the delivery of an online system for the submission

Explain adaptive-response-rate single exponential smoothing, Question: ...

Question: (a) State and explain the conditions under which the following exponential smoothing techniques will be chosen: (i) Winters' exponential smoothing. (ii) Holt's ex

Discuss how can workplace violence be prevented, Question 1: (a) Explai...

Question 1: (a) Explain what is a chemical hazard and under what circumstances do chemical substances become hazardous. (b) How do chemical hazards affect the body and what

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

What is an e-marketing, QUESTION Marketing has been practiced ever sinc...

QUESTION Marketing has been practiced ever since humans engaged with trade and has evolved in line with changes in technology. (a) What is an e-marketing? (b) Explain 10

Systems orientation, PM alone cannot eliminate or drastically reduce break...

PM alone cannot eliminate or drastically reduce breakdowns. Supporting it there should be various steps taken in design development and engineering such that maintenance itself

Problem based on exquisite flowers, Normal 0 false false fa...

Normal 0 false false false EN-US X-NONE X-NONE a) The benefits to Natalie in operating as a soli

Why do organizations need a structure, QUESTION 1 (a) The grouping of o...

QUESTION 1 (a) The grouping of organizational activities (usually into 'departments' or larger 'divisions') can be done in different ways. Outline 7 criteria which can be used

Managing operations, The assignment has been designed to marry the theoreti...

The assignment has been designed to marry the theoretical analysis and practical application of the concepts of 'Managing Operations'. This assignment will therefore require studen

DORIC CONVERSION TECHNOLOGIES, Explain the ethical issues from Peter Johns...

Explain the ethical issues from Peter Johnson''s point of view.

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