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

Competent motors limited, Rajinder Kumar was a manufacture worker at Compet...

Rajinder Kumar was a manufacture worker at Competent Motors Limited (CML), which made components and accessories for the automotive industry. He had worked at CML for almost seven

Describe the problem in this case study, QUESTION Instruction- Read th...

QUESTION Instruction- Read the following case study and answer the questions below Wesley, a newly appointed room attendant supervisor's, productivity has not been as expe

What is new public management, QUESTION 1 (i) What is New Public Manage...

QUESTION 1 (i) What is New Public Management? (ii) Describe the New Public Management principles which help to transform public sector organisations into entrepreneurial age

Identify five basis functions of the organization, A company Mission statem...

A company Mission statement should determine / identify 5 basis functions of the company, select and discuss 4 elements you have identified in the Airbus Industries mission stateme

Financing, three approaches to the short term financing problem providing r...

three approaches to the short term financing problem providing relevant examples

Estimate the revenue and expenses of equipment, Existing machine Purchas...

Existing machine Purchased 3 years ago Cost=22,000 Installation= 3000 Depreciation=3 years using the MACRS - 5 year Recovery schedule Current market value=10,000

Explain the importance of barriers to entry, QUESTION Explain with exam...

QUESTION Explain with examples where appropriate the major characteristics of cognitive development in early childhood. QUESTION Explain with examples where appropriate

Why is policy advocacy important, QUESTION 1 (a) Distinguish between po...

QUESTION 1 (a) Distinguish between policy analyses and policy advocacy. (b) Why is policy advocacy important? (c) Why is it questionable that policy analysis can ever "so

Structure of a maintenance organization, The maintenance department is pri...

The maintenance department is primarily a service department and as such is a part of the plants staff. Generally the maintenance department is attached to the production func

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