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
Define the term marketing concept in briefly. The marketing concept is a management orientation which holds that the key task of the organisation is to find out the needs, want

Why are symbols important to a corporate culture?

QUESTION The Sengapa Garments Ltd (SG Ltd) is a company engaged in the manufacture of T-Shirt and allied textile products for the local market and for exports. SG Ltd is still

QUESTION 1 (a) What can be done at management level to establish and improve an organisation's ethical culture? (b) What are the individual and situational factors that infl

QUESTION Every big, medium or even small company networks should pay the highest attention to the development of their company networks (intranets and extranets connected to th

Section - Introduction An introduction to either   An industry or   A profession or   A particular business or   A iwi/hapu group Give an introduction t

What is the Always Better Control Analysis of Inventory Control? ABC Analysis of Inventory Control: Always Better Control Analysis of Inventory Control analysis is the ex

QUESTION 1 History is replete with cases where organizations fail as a result of poor or no communication especially in periods of crises. With what you have learnt from the lo

"It's a cross functional business process designed to optimize development activities and customizes to fit business needs. It captures and shares what has worked well in the past

The case study which follows is based on an Environmental Management System (EMS). Read it carefully and then answer the short structured questions that follow: Vondax Manufactu