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

Age diversity, Research indicates that older employees are more satisfied w...

Research indicates that older employees are more satisfied with their jobs, are more committed to the organisation and possess more internal work motivation than their younger coho

Total productive maintenance, This is innovative approach of maintenance d...

This is innovative approach of maintenance developed by Japanese manufacturers for their plants and machinery. In this concept the principle of all the above there method

Strategies for successfully using communication technology, QUESTION 1 ...

QUESTION 1 a) What is communication? b) Discuss four common types of communication barriers c) Explain five strategies for overcoming communication barriers and briefly e

Adequate storage facilities, Adequate and well organized warehouse facil...

Adequate and well organized warehouse facilities with went equipped proper handling facilities must be there. It need not necessarily be elaborate and expensive. Such

Explain the difference between social obligation, Question: In Mauritiu...

Question: In Mauritius, the government has reduced the corporate tax and consequently, it expects private sector organizations to spend a percentage of their profits on project

Cash deposited in banks, QUESTION Part 1 Company X is evaluating ...

QUESTION Part 1 Company X is evaluating whether each of these items is a financial instrument and whether it should be accounted for under IAS 32 (1) Cash deposited in

Carrying cost, Also known as the loading cost or the storage cost carryi...

Also known as the loading cost or the storage cost carrying cost represents the cost that is associated with storing an item in inventory. It is proportional to the amoun

Joint ventures may or may not be preferred to wholly owned, QUESTION ‘T...

QUESTION ‘The internalization theory posits that firms would have a strong incentive to avoid joint venture agreements since they are viewed as second best alternatives in allo

What are programme evaluation and review technique, What are Programme Eval...

What are Programme Evaluation and Review Technique? PERT (Programme Evaluation and Review Technique): It is a technique used for controlling and scheduling the projects w

Explain the functions of merchandise manager, Question 1 Explain any five ...

Question 1 Explain any five factors behind the change of Indian retail industry Question 2 Explain meaning of market segmentation along with benefits of segmentation Ques

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