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

Analyze and discuss the suitable resource management, Waste generation is p...

Waste generation is probably the most visible effect that the hotel industry has on the environment. A typical hotel guest is estimated to produce at least 1 kg of waste per day (C

Develop a product based organisational structure, Please refer Keells Food ...

Please refer Keells Food Products PLC overview, electronic annual report for year 2009/2010 and the corporate website before answering the following questions. Keells Food Prod

Vie, QUESTION Look back on the past years and think of someone who did ...

QUESTION Look back on the past years and think of someone who did something to motivate you. Use a concrete example to illustrate your answer (a) Describe how this was done

What is the ath decision, Do you know What is the ATH decision, and what is...

Do you know What is the ATH decision, and what is it used for? Ans) Most of the investment world worships the bottom line market value of portfolios, and like as focus (without

Benefits of e-checks, QUESTION On-line payment providers have started p...

QUESTION On-line payment providers have started playing a big role in today's payment system, particularly, when Internet offers new business opportunities, making Epayment ver

Problem based on vision and mission statements, a) Mission statement refe...

a) Mission statement refers to the avowal of an organisation's overall purpose, such as Nokia's "Connecting people..." It outlines the basis for setting the objectives of a busin

Switchover to product oriented from process oriented layout, Switchover to ...

Switchover to Product Oriented Layout from Process Oriented Layout Advantages offered by Switchover to Product Oriented Layout from Process Oriented Layout: As bein

What do you understand by selection, Question 1: "Training is more an i...

Question 1: "Training is more an investment than cost". Discuss. Question 2: (i) What do you understand by "selection"? (ii) Comment on the effectiveness of inter

Advantages and disadvantages of ib4e, Over the past few years, the company ...

Over the past few years, the company iB4e has underperformed compared with its competitors which enjoy stronger brand recognition. In addition, lots of experienced staff responsibl

Information needs at the top management, QUESTION Mauritius Institute o...

QUESTION Mauritius Institute of Technology (MIT), is a well-established private tertiary education institution located in Moka. The MIT operates two faculties with around ten d

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