a) Implement conditional formatting to show that if the total spent before VAT is £1000 or more, the cell will be highlighted in red to show that discount has been earned.

b) In addition, implement conditional formatting in one more suitable location in your worksheet.

c) Create an Invoice from the data entered onto the Order sheet using cell linking techniques. Then include a button on your Order Sheet to view the invoice and one on the Invoice sheet to print it.

d) The spreadsheet model must now demonstrate professional, formal layout and be user friendly. Ensure it is suitably formatted.

Posted Date: 3/25/2013 1:55:57 AM | Location : United States

Ask an Expert

Related Discussions:- Implement conditional formatting, Assignment Help, Ask Question on Implement conditional formatting, Get Answer, Expert's Help, Implement conditional formatting Discussions

Write discussion on Implement conditional formatting
Your posts are moderated

Write your message here..

Related Questions

Caselet, Mr. Vincent the manager of a large supermarket was taking a manage... Mr. Vincent the manager of a large supermarket was taking a management course in the evening program at the local collage. The professor had given an interesting but Mr. Vincent th

How is line and staff functions affected in organisation, How is the line a... How is the line and staff functions affected in the organisation? Line and Staff functions: every activities of an organization can be categorised in Supporting and Prima

Preparation of a business plan, The ability to recognize the need for a bus... The ability to recognize the need for a business plan is now widely regarded as a sign of both business maturity and the likelihood of survival. (a) Discuss the benefits that ca

Important of maintenance management, Important  of Maintenance Management ... Important  of Maintenance Management 1. Dependability  of Service: it  is one  the performance measures by which  a company  can  distinguish itself from others. To  establis

Manchester united football club, Manchester United Football Club a) By... Manchester United Football Club a) By opting for the AIG sponsorship deal worth £56.5m, MUFC is prior the larger deal of £70m, i.e. the opportunity cost is the extra £13.5m ha

Values and principles on which the code of ethics rests, The Code of ethics... The Code of ethics for Public Officers sets out the standards of correct conduct expected of Public Officers. It emphasizes the importance of a responsible, responsive and caring

OPERATING CYCLE, DISCUSS THE APPLICABILITY OF OPERATING CYCLE IN VEGETABLE ... DISCUSS THE APPLICABILITY OF OPERATING CYCLE IN VEGETABLE GROWING BUSINESS

Why do organizations need a structure, QUESTION 1 (a) The grouping of o... QUESTION 1 (a) The grouping of organizational activities (usually into 'departments' or larger 'divisions') can be done in different ways. Outline 7 criteria which can be used

Modes of strategic management are the approaches adopted, QUESTION 1 Or... QUESTION 1 Organisations resist change for many of the same reasons as individuals do. There are also many forces inside an organization that create resistance to changes initi

Logical analysis of daily business, Jane Parton, the proprietor of Deli Pa... Jane Parton, the proprietor of Deli Parton, sells specialty breads for $3.95 each.  She buys these from a baker-supplier for $2.45 per unit. Since Jane wants to maintain Deli Pa