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

Time management wizard, Problem Organisations and individuals could der...

Problem Organisations and individuals could derive great benefits from an all-in-one Time Management Wizard. Although there exist various tools such as Calendars and Timesheets

Write a note on classification of business objectives, Q. Write a note on c...

Q. Write a note on classification of business objectives? 1) Economic Objectives - Functions of customer Segment - Innovations - Optimum use of resources 2) Social Objectives -

introduction to business, The Four Seasons Corporation The Four Seasons ...

The Four Seasons Corporation The Four Seasons Corporation is a new firm to the market that is established recently. Since the garment industry is growing in a pace rate worldwide

Describe the banking structure in the united kingdom, QUESTION Outline ...

QUESTION Outline five (5) different principal risks that banks normally face in their day to day business and explain the different Risk Management techniques used by them to m

Departmental, Define the departmental, long-term and non-economic manageria...

Define the departmental, long-term and non-economic managerial decisions. Departmental, Long-term and Non-Economic decisions: In long term decisions, there time period en

Perform the transformation, The activities of this last phase are: 1. D...

The activities of this last phase are: 1. Develop a migration strategy, 2. Create a migration action plan, 3. Develop metric for measuring performance during implement

What pricing strategies would you recommend, Question: Price is the onl...

Question: Price is the only element of the marketing mix which generates revenue, the other elements being all associated with costs. Hence its determination is crucial for any

What do you meant by the term an organization, Question 1: It has been ...

Question 1: It has been stated in the case that the new ‘Human Resource Manager was failing to recruit the right kind of people ... and new recruits were unenthusiastic about a

M.COM, What are the rationale of transfer of technology? Describe various n...

What are the rationale of transfer of technology? Describe various non-equity forms of technology transfer by TNCs and Small and Medium Enterprises

E commerce, explain the generic framework of ecommerce with diagram

explain the generic framework of ecommerce with diagram

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