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

Reducing balance method and straight line method, Satine Enterprise Ltd. ...

Satine Enterprise Ltd. a) Reducing balance method: Year Depreciation Net Book Value 0 0 $25,000

Organisational behavioure , For an organisation that you know well (e.g., t...

For an organisation that you know well (e.g., the organisation, where you are currently employed or for which you worked in the past), using the relevant concepts, theories and mod

Organization, Organization: Organization is a community unit of nation...

Organization: Organization is a community unit of nation that is incorporated and focussed to gather a need or to practise communal goals in order to create a high-quality ser

Describe internet banking, Question 1 Cross selling is an act of selling a...

Question 1 Cross selling is an act of selling a range of additional products to a customer who has already availed of a particular product or service from the seller or the servic

Drawbacks of business-to-business (b2b) e-commerce, QUESTION a) Identif...

QUESTION a) Identify and describe the cultural and social factors that can influence buyers' decisions b) In a buying center purchasing process which buying center participa

Farm planning, iimportance of farm planning to the farmer

iimportance of farm planning to the farmer

Technology used for communication, Question 1 Since 2000, Tizil Company...

Question 1 Since 2000, Tizil Company Ltd manufactures Teddy bears which it exports to European countries. It has several factories located in Mauritius and in Rodrigues. With

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