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

P&l for masks r us ltd, P&L for Masks R Us Ltd: a)   ...

P&L for Masks R Us Ltd: a)   $ $ Sales ($8 * 15,000)   120,000 Cost of Goods Sold :

Preventive maintenance, Preventive maintenance consists of routine actio...

Preventive maintenance consists of routine actions taken a planned manner to prevent breakdown and to ensure operational efficiency to the extent it is economically and pra

Explain the functions of the financial services commission, QUESTION (a...

QUESTION (a) Mr. Bob is the director of ABC Co. Ltd, a shoe making company. Mr. Bob wants to change the business activities of the company to carry out leasing activities. He s

Determining various stock levels, Another important decision is maintaini...

Another important decision is maintaining inventory and determining the inventory level. An inventory level is a quantitative limit, which should neither be much higher nor

Managing Knowledge, Discuss what kind of organisational culture promotes or...

Discuss what kind of organisational culture promotes organisational learning.

Intermediaries, the negavtive effect intermediaries has on a business organ...

the negavtive effect intermediaries has on a business organisation

Describe briefly the five stages of group development, QUESTION 1 a) Ho...

QUESTION 1 a) How can an understanding of the team roles as developed by Meredith Belbin help a manager in communicating effectively with his/her team? b) Discuss the major

Explain the concept of commodity market, Questiion 1 Consider yourself as ...

Questiion 1 Consider yourself as a chief financial officer, Discuss the treasury functions that you handle and discuss how you will formulate the treasury policy Questiion 2

BUSI-600, ETHICS OF RESEARCH is my research paper topic of 3000 words

ETHICS OF RESEARCH is my research paper topic of 3000 words

Bma, 5 steps in the process of evaluating the purchasing and suppy

5 steps in the process of evaluating the purchasing and suppy

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