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

Modes of Entry and Internalisation, ‘Although the elegance and comprehensiv...

‘Although the elegance and comprehensiveness of transactions costs reasoning has provided the internalisation approach with a powerful logic (Rugman, 1981, 1985), it is still defic

Explain the stages of the team development process, QUESTION 1 Elaborat...

QUESTION 1 Elaborate on the communication skills that you believe employees should possess in order to ensure that customers are satisfied with the services provided by organis

ERP, Distinguish between business function and business process

Distinguish between business function and business process

Technology used for communication, Question 1 Since 2000, Tizil Company...

Question 1 Since 2000, Tizil Company Ltd manufactures Teddy bears which it exports to European countries. It has several factories located in Mauritius and in Rodrigues. With

Business, Sam bought a leather corner sofa and chair from SCS Edinburgh for...

Sam bought a leather corner sofa and chair from SCS Edinburgh for £5,490 in July 2009. Less than a year later, she noticed that the sofa’s stitching had started to unravel and repo

What is a project, Question 1 What is a project? Briefly explain the ph...

Question 1 What is a project? Briefly explain the phases of a project life cycle Question 2 What are the major challenges of an entrepreneur in project formulation?

What are programme evaluation and review technique, What are Programme Eval...

What are Programme Evaluation and Review Technique? PERT (Programme Evaluation and Review Technique): It is a technique used for controlling and scheduling the projects w

How does a resume affect your employability, Question 1 There are various ...

Question 1 There are various techniques of reading out of which SQ3R is most popular. How will you apply it while reading and research? Question 2 Advertisements are used by

Use of information system in business, Q. Use of Information system in busi...

Q. Use of Information system in business? The utilization of information system has been increasing day by day. It assists to give a competitive advantage over business rivals.

Define the total cost of ownership concept, a). briefly discuss under what ...

a). briefly discuss under what circumstances IS resources might provide the firm with a sustainable competitive advantage. b). Define what is meant by 'IS Evaluation' and explai

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