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

Function of materials handling, Function  of Materials Handling: The b...

Function  of Materials Handling: The basic  function of materials  handling are to choose most  appropriate material  handling  equipment  which  is safe  and can fulfill mate

Monthly maintenance programme, Daily maintenance for every facility is n...

Daily maintenance for every facility is not advisable as it would be quite expensive and time consuming. Hence according to the requirements and importance of the machi

Limitations of carrying out coherent decision making, Question 1: Being...

Question 1: Being successful in decision making is something that managers obviously desire. Describe the steps which lead to rational decision making and discuss the limitatio

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

Expand the term b2b and b2c, QUESTION a) Expand the term B2B and B2C. G...

QUESTION a) Expand the term B2B and B2C. Give one example of each type of business that each represents. b) Compare traditional commerce with electronic commerce and explain

What are the important objectives of job evaluation, What are the important...

What are the important objectives of job evaluation? Objectives of job evaluation are as given below: 1. Chooses the relative values of various jobs in an organization. 2

Company is paying a dividend, When we refer to profitability, are we referr...

When we refer to profitability, are we referring to more than the fact that the company is paying a dividend? Ans) Yes, absolutely. I focus on the right hand columns of the Stoc

Business Environment, Hello pls how do I send the details of the questions?...

Hello pls how do I send the details of the questions? Because is really long.

Create a histogram of the distribution of total cost values, Synthetic Auto...

Synthetic Auto Insurance is trying to decide how much money to keep in liquid assets to cover insurance claims. In the past, the company held some of the premiums it received in in

Explain about the management information system, Explain about the Manageme...

Explain about the Management Information System. Management Information System: It is defined as like a formal method of making obtainable to management the precise and t

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