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

Development of an environment management system, Question 1: (a) Briefl...

Question 1: (a) Briefly describe the Environment Impact Assessment Committee and its functions (b) What do you understand by the term 'environmental sustainability' (c) List a

Labor Practices in sweat shops, A clothing company uses sweatshop labor to ...

A clothing company uses sweatshop labor to manufacture clothing products that contribute to low pricing, which is a consumer want. Many companies have engaged in sweatshop labor. D

Describe the role of the secretary, Question 1: As our society becomes ...

Question 1: As our society becomes increasingly diverse, the ability to communicate with members from other cultures becomes a business necessity. Explain four intercultural di

Vertical and horizontal communication channels, QUESTION (a) Communicat...

QUESTION (a) Communication flows up, down and across the chain of command. Explain the major differences between vertical and horizontal communication channels. (b) Identify

Limitations of jit manufacturing, Limitations of JIT JIT manufacturing...

Limitations of JIT JIT manufacturing  requires  considerable  co operation between the management  and workers, it  is commonly believed that JIT production system is very eff

Monthly maintenance programme, Daily maintenance for every facility is n...

Daily maintenance for every facility is not advisable as it would be quite expensive and time consuming. Hence according to the requirements and importance of the machi

Discuss how to analyse problems and their causes, QUESTION 1 Discuss ho...

QUESTION 1 Discuss how to analyse problems and their causes with respect to common problem solving pitfalls QUESTION 2 In planning and managing projects, project manage

Business in post american world, do you believe that adaptive unconscious c...

do you believe that adaptive unconscious creates false memories?

BUSINESS LAW, NAME FOUR CATEGORIES OF ASCERTAINED GOODS

NAME FOUR CATEGORIES OF ASCERTAINED GOODS

Show the cross-functional crm processes, Question: a. Research shows th...

Question: a. Research shows that there are five key cross-functional CRM processes that need to be considered by most organizations. What are they ? b. The emergence of CRM

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