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

Efficient communication-ocr’s examination blunders, efficient communication...

efficient communication (unlike the OCR's examination blunders) is fundamental to an organisation such as the OCR exam board because it helps to: Keeps schools (the custome

Farm planning, iimportance of farm planning to the farmer

iimportance of farm planning to the farmer

Describe the stages of group formation, Question: XYZ is a small organi...

Question: XYZ is a small organization producing. canned Tuna fish.Work is allocated into teams of 6 to 8 people. Some groups specialize in canning, some in design, some in mar

Option for organising business, compare the liability of the owners of part...

compare the liability of the owners of partnerships, sole proprietorship and corporations.

Written messages must be as readable as possible, Question 1 Communication...

Question 1 Communication skills are of utmost importance in managing information and technology in any organization. List the characteristics of communication and discuss the seve

The Management process (Information & decision Making), Q.1. Discuss how in...

Q.1. Discuss how information technology affects and change organizations. Q.2. How do managers use information to make decisions?

Diversity management, Diversity management may be understood as the systema...

Diversity management may be understood as the systematic and planned commitment by organisations to recruit, retain, reward, and promote a heterogeneous mix of employees (Thomas, 1

Operation of online analytical processing, Compare and contrast the goal, r...

Compare and contrast the goal, role, and operation of Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) tools in the context of Business Intelligence ini

Discuss the different forms of communication existing, QUESTION 1 a) Il...

QUESTION 1 a) Illustrate the different processes of effective communication. b) Discuss the different forms of communication existing. QUESTION 2 a) Define the conce

Difference between storefront model and the auction model, Question 1: ...

Question 1: (a) Explain the difference between the storefront model and the auction model in e-commerce. (b) A company would like to extend its business over the Internet.

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