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

Business can effectively discharge its social obligations, QUESTION 1 S...

QUESTION 1 Strategic decisions are the essence of strategic management. According to Pears & Robinson, typically, strategic issues have certain dimensions. Write short notes on

Assigment, How will you influence people to strive willingly for group obje...

How will you influence people to strive willingly for group objectives in your organization (target bases industry)? apply your interpesonal influence throught communication proces

Describe the characteristics of an effective team, QUESTION 1 a) Descri...

QUESTION 1 a) Describe the characteristics of an effective team b) Discuss the main features that contribute to the proper functioning and creativity of a team c) Assess

Principles of management, Using illustrations, show how any one dysfunction...

Using illustrations, show how any one dysfunction in the above management functions might affect the effectiveness of an organisation.

Primary elements of zero inventories, Just  in time  production is defined ...

Just  in time  production is defined as philosophy that  focuses attention on eliminating waste by purchasing or manufacturing  just enough of the right items just in  time It i

Working with other cultures, In this assignment, you will consider the pote...

In this assignment, you will consider the potential challenges and solutions that are inherent when working with other cultures. Identify a country and research the communication a

Problem based on vision and mission statements, a) Mission statement refe...

a) Mission statement refers to the avowal of an organisation's overall purpose, such as Nokia's "Connecting people..." It outlines the basis for setting the objectives of a busin

Cultural diversity, (a) Cultural diversity have to be preserved and promote...

(a) Cultural diversity have to be preserved and promoted, as the lack of knowledge, appreciation and understanding of other cultures often cause conflict and hate between people. S

Explain the ethnocentrism, QUESTION 1 We do not understand people from ...

QUESTION 1 We do not understand people from other cultures as readily and intuitively as people from our own culture. But, cross cultural communication management helps organiz

Managerial skills(10), what are some of the main best managerial skills

what are some of the main best managerial skills

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