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

Explains the short note of breaking business barriers, Q. Explains the shor...

Q. Explains the short note of Breaking Business Barriers? The Information Technology smashes traditional barriers to strategic business success. Computer as well as telecommuni

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

Describe the life-cycle stages of organizations, Question 1: (a) Why mu...

Question 1: (a) Why must management delegate some authority and responsibility in large complex organisations? (b) Why, in practice, many managers are reluctant to delegate

Explain the principal-agent problem in the banking business, QUESTION (...

QUESTION (a) Accepting deposits and making loans are the only products offered by a commercial bank. Discuss this statement. (b) Explain how does a commercial bank normally

Importance of effective internal and external communication, Question 1: ...

Question 1: Answer briefly to any three of the following: (a) Explain the importance of effective internal and external communication. (b) Explain how business communicat

Show the main objectives of training, Question 1: (a) What is ‘Trainin...

Question 1: (a) What is ‘Training'? (b) Show the main objectives of ‘Training'. (c) Explain clearly the different stages in a systematic approach to Training as developed

Strategy, Explain strategy as an organizational process?

Explain strategy as an organizational process?

Consumer behaviour when making a purchase, Describe briefly the main stages...

Describe briefly the main stages included in the (rational) process of consumer behaviour when making a purchase.   Problem/Need recognition The purchasing process is a pro

Business plan to start a specialty coffee joint, On an individual basis, fo...

On an individual basis, formulate a business plan to start a specialty coffee joint at an appropriate "chic location" in Singapore. The business plan has to be well written so that

Influence of personal ethics, Explain in relation to the organisation you r...

Explain in relation to the organisation you researched in Section A of this report why managers should use ethics to guide their own and other peoples' behaviour in the workplace.

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