Complex spreadsheet model, Business Management

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.

Posted Date: 3/25/2013 1:55:28 AM | Location : United States







Related Discussions:- Complex spreadsheet model, Assignment Help, Ask Question on Complex spreadsheet model, Get Answer, Expert's Help, Complex spreadsheet model Discussions

Write discussion on Complex spreadsheet model
Your posts are moderated
Related Questions
Indicate how each of the listed variables(GDP, consumption and interest rates change in each of the following separate events. Briefly explain. a. The recent strengthening of t

Organisations tend to organise their working areas by function, e.g. production, warehouse, sales and marketing, etc.  Business processes occur across these functional groups requi

What is oral business communication? Explain its benefits to the organisation and to the individual employee.

how to write a company analysis in light of the Triple triangle Framework?

1. Describe the situation facing Mensa at the time of the case. This should include the major issues facing the company and the decisions that need to be made. You are to spend no

Approaches to short-term financing problem?

QUESTION 1 (a) Explain the various risks faced by an international bank operating in an international market, with emphasis on interest rates and market risks (b) Discuss ho

Illustrate the term accounting? Accounting: It is an art of classifying and recording data. Here, the data considers to transactions consisting of monetary or financial v

Question 1 Discuss the exceptions to the law of demand Question 2 Explain Elasticity of Supply with the help of a diagram and factors affecting elasticity of supply

Hello, I have an assignment I need to complete in the next 6 weeks and want to know how your service works? It is 1 of 2 modules I require to complete my studies. Can you please a