Complex spreadsheet model, Business Management

Assignment Help:

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.


Related Discussions:- Complex spreadsheet model

Distinguish between business function and business process, QUESTION 1 ...

QUESTION 1 Enterprise Resource Planning (ERP) programs are software used by companies to manage information in every area of the business. ERP programs help manage company-wide

Develop a spreadsheet solution for project, Start a new workbook and develo...

Start a new workbook and develop a spreadsheet solution for Gareth's Gardens in order for him to efficiently record his garden orders and produce his customer invoices. The soluti

Business commuication, What six stages should you go through in preparing a...

What six stages should you go through in preparing an effective outline for a presentation?

Why is policy advocacy important, QUESTION 1 (a) Distinguish between po...

QUESTION 1 (a) Distinguish between policy analyses and policy advocacy. (b) Why is policy advocacy important? (c) Why is it questionable that policy analysis can ever "so

Characteristics of performance, Marketing is responsible for determining ...

Marketing is responsible for determining the key characteristics which determine the quality of the product or service in the eyes of the customers. This may involve use of

What is line balancing, What is Line Balancing? Explain briefly. Line...

What is Line Balancing? Explain briefly. Line Balancing: It means balancing the line among the product lines or assembly lines. This aims at grouping facilities and work

Explain the task of research and development wing, Q. Discuss the main task...

Q. Discuss the main task of Research and Development (R & D) wing in the context of development of modern society? Ans. THE MAIN TASK OF RESEARCH AND DEVELOPMENT In the l

Effects of accidents, Effects  of Accidents The  accidents are  always ...

Effects  of Accidents The  accidents are  always undesirable.  They result in  loss of life  and property. They  produce evil effects  on workers, families employers and on the

Using examples explain why people need to communicate, QUESTION 1 (a) ...

QUESTION 1 (a) Using examples explain why people need to communicate in business. (b) Briefly outline the five main attributes of a successful business communicator. (c)

What do you mean by morale, What do you mean by morale? Morale: T...

What do you mean by morale? Morale: The word morale usually has an implication of group reactions which is what motivation does to the particular; it does to the work gro

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd