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
Question 1: Discuss the importance of applying the relationship-marketing concept to the marketing activities of Wal-Mart. Question 2: Explain how Wal-mart can monitor

Academicians are constantly pursuing ways for reforming the strategies and systems in education in view to improve its quality as well as its outcome. Developing efficacy to addres

QUESTION Part 1 Company X is evaluating whether each of these items is a financial instrument and whether it should be accounted for under IAS 32 (1) Cash deposited in

As a Sales Manager, prepare a one page report in memo format addressed to the VP Marketing, providing sales updates for a newly launched FMCG product

Question 1 Earlier payroll systems used the systems which were more than process time sheets, print payroll checks and keep total so f annual wages and deductions. Present day sys

An automobile manufacturer observes the demand for its brand increasing as per capita income increases. Sales increases also follow low interest rates, which ease credit conditions

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

Procedure for carrying out location selection and analysis for a new production facility in the United States of America. Chemical plant facility to serve the automotive market of

What changes in the organizing facet of the P-O-L-C framework might you make at Toyota to prevent future mishaps like the massive recalls related to brake and accelerator failures?

QUESTION 1 (a) Businesses are increasingly exposed to scrutiny and criticisms. Discuss four strategies which can be adopted by businesses to respond to these criticisms (b)