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.

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
if you were one of the other foremen, what could you do to make rajinder?s transition easier?

Existing machine Purchased 3 years ago Cost=22,000 Installation= 3000 Depreciation=3 years using the MACRS - 5 year Recovery schedule Current market value=10,000

Economic order size is that size of the order which gives maximum economy in purchasing any item of material. The other terms used for economic order size are economic

Characteristics of  JIT Management JIT  management   has high  degree of several Japanese cultural aspects in  its development. The  characteristics of JIT  management can  be

QUESTION (1) The project lifecycle refers to a logical sequence of activities to accomplish the project's goals and objectives. Elaborate on these basic phases using and exampl

QUESTION Instruction- Read the following case study and answer the questions below On a Saturday night at one in the morning Mr and Mrs Samuel, repeated guests of Marriott

What is product development? Product Development: Product Development is an activity that comprises design and its redesign and fabrication of modified or new product and

QUESTION 1 Communication constitutes the exchange of information and the transmission of meaning. As such it is the lifeblood of an organisation." Discuss. QUESTION 2 D

This semester-long project provides an opportunity to demonstrate your business research skills, your financial acumen, and your understanding of how different business models, str

QUESTION 1 Mr. Ignorant wishes to open a company. He has already chosen the name ‘Xmas Mauritius Ltd' for the company. Since he is ignorant about the procedures, he seeks your