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

Discuss about the policy and operative managerial decisions, Discuss about ...

Discuss about the policy and operative managerial decisions. Policy and Operative decisions: Policy decisions are very significant, they are occupied by top management, a

Social change and development, Question 1 List and discuss the four ass...

Question 1 List and discuss the four assumptions made by modernization theory about the process of social change in the Third World. Give your own examples to illustrate your d

Describe why listening is an important skill for managers, Question 1: ...

Question 1: a) Describe why listening is an important skill for managers. b) Illustrate how positive body language may persuade your interviewer that you are a suitable cand

Explain how effective brand management can assist ib4e''s, Over the past fe...

Over the past few years, the company iB4e has underperformed compared with its competitors which enjoy stronger brand recognition. In addition, lots of experienced staff responsibl

Create a production schedule, 1. Create a Production Schedule for January t...

1. Create a Production Schedule for January to May and identify any issues that may affect achievement of the Schedule. Use the information outlined in the Scenario below in conjun

What is all about sales?, Sales is about generating prospects, evaluating t...

Sales is about generating prospects, evaluating them for business opportunities, getting the requirement from them and giving adequate solutions so that it gets changed into Revenu

Explain reload- types of organisation, Reload a) Banks might be unenth...

Reload a) Banks might be unenthusiastic to lend money to reload (Stock Up) for various reasons, including: Reload being a somewhat unfamiliar business outside of New Zealan

Enhance trading activities between the two countries, QUESTION The Stat...

QUESTION The State Bank of Botswana (SBB) offers banking services on a very large scale in Botswana. International trade between Mauritius and Botswana has gone up in the recen

Performing and adjourning in team development, Question : Psychologist ...

Question : Psychologist Bruce Tuckman first came up with the memorable phrase "forming, storming, norming and performing" back in 1965. He used it to describe the path to high-

Discuss the characteristics of an effective team, QUESTION 1 Write shor...

QUESTION 1 Write short notes on the following- (a) Non-verbal communication (b) Information overload (c) Identify the four categories of cultural differences that need

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