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

Determine the aims and objectives of the business, What would be the aims a...

What would be the aims and objectives of the business Luke is planning to implement after graduation? His Business deals with people that are unaware of the modern world of tech

Contribution of education to the social structure, "Society can survive onl...

"Society can survive only if there exists among its members a sufficient degree of homogeneity; education perpetuates and reinforces this homogeneity by fixing in the child from th

Cross-communication is more effective through technology, QUESTION 1 Di...

QUESTION 1 Discuss the importance of communicative behaviour observed in class rooms. QUESTION 2 Music is a powerful means of communication among children. How far do y

Implement performance management system in organization, Question 1: (a...

Question 1: (a) Describe the process through which you would proceed to implement a Performance Management System in your organization. (b) What are the main problems that y

Definition of 5s, 55 is a participative programme. It is a effective appro...

55 is a participative programme. It is a effective approach of improving the work environment and total quality. It become a base for continuous improvement in the organizatio

Fully operational computer system, Explain the reasons why a department of ...

Explain the reasons why a department of an organisation might continue to use manual records rather than a new, recently installed and fully operational computer system. Severa

Explain the principle of employee involvement, QUESTION 1 (a) Deming st...

QUESTION 1 (a) Deming stated that management need to adopt the 14 points philosophy. You are required to identify and explain these 14 points. QUESTION 2 Identify and e

Organizational behaviour, using as exsiting company write on how organizati...

using as exsiting company write on how organizational behaviour can play a major role in the company''s organizational development enhancing organizational performence as well as i

What is the meaning of term entrepreneurship, What is the meaning of term E...

What is the meaning of term Entrepreneurship? Meaning of Entrepreneurship: Entrepreneurship refers to a process of action an entrepreneur undertakes to establish h

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