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
Today is your first day working for MarmaMed, a firm that produces and sells a small range of medical diagnostic products. MarmaMed’s main product is the DiagnoKit™, a simple-to-us

Using the diagram below, describe how legacy systems have contributed to the emergence of information islands within large organisations. What are the information flow pr

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

Question: (a) You have been appointed as the Human Resource Manager of BPO Ltd and the Chief Executive Officer has requested you to propose measures to improve industrial relat

QUESTION Answer in brief to the following (a) Discuss how effective business communication is linked to personal career success. (b) Describe the value of non-verbal

Over the past few years, the company iB4e has underperformed compared with its competitors which enjoy stronger brand recognition. In addition, lots of experienced staff responsibl

calculate point elasticity of demand for demand functionq=10-2p for decrease in price from rs 3 to 2

It goes by many terms - information overload, analysis paralysis, data dumping, and so on. You know what we''re talking about. It is indeed greater to live in the information age w

Work Breakdown Structures (WBS) - explain the value, role and use of the WBS methodology in project management. Planning within organizations takes place at strategic, tactical

Illustrates the thoughts of Douglas McGregor about management? Accroding to Douglas McGregor: Theory ‘X’ and ‘Y’, are theories put forward through Douglas McGregor. The th