Information Technology And Its Application In Business Assignment

Assignment Task

Assignment-I

2. Fill in the Month series down column A.

3. Calculate the total for Bell’s shares.

4. Calculate totals for all other shares and save the file as Shares.

5. Format all numerical entries to currency and two decimal places.

6. Calculate the average price of Bell’s shares (i.e. Total/Number of months).

7. Work out all other averages and format the Average row as currency and one decimal point.

8. Format the title to bold and the column headings to bold and italic.

9. Centre the column headings.

10. Save the changes.

11. Now make the following changes: Harry’s share price in April was 640 and Sam’s share price in January was 24. The name Bell should be changed to Bill.

12. Insert top and double bottom borders for the Total row cells.

13. Insert a blank row between the Total row and the Average row.

14. Calculate the Min and Max amount of shares for each person. Format as currency and one decimal point.

15. Calculate the Min and Max amount of shares for each month. Add column headings, respectively for each new column. Format as currency and one decimal point.

16. Change the borderline color for the Total row to red.

17. Increase the font size for the heading ‘Shares’ to 20 points and select a new font type of your choosing. Resize the column width to accommodate the new data style.

18. Add a thick box border around the outside of the data set.

19. Save the changes.

Assignment-II

Type the following paragraphs into the word processing sheet:

Auditor’s risk and its components

Auditor’s risk is the risk that the auditor expresses an inappropriate audit opinion when the financial statements are materially misstated.

Auditor’s risk is a function of two main components being; the risks of material misstatement and detectionrisk.

Detection is the risk that the procedures performed by the auditor to reduce the auditor’s risk to an acceptable level will not detect a misstatement that exists and which could be material, either individually or when aggregated with other misstatements. Detection risk is affected by sampling and non-sampling risk.

The risk of material misstatement is made up of two components; inherent risk and control risk.

Inherent risk is the susceptibility of an assertion about a class of transaction, account balance or disclosure to a misstatement that could be material, either individually or when aggregated with other misstatements, before consideration of any related controls.

Control risk is the risk that a misstatement that could occur in an assertion about a class of transaction, account balance or disclosure and which could be material, either individually or when aggregated with other misstatements, will not be prevented, or detected and corrected, on a timely basis by the entity’s internal control.

This Accounting and Finance has been solved by our PhD Experts at My Uni Paper. Our Assignment Writing Experts are efficient in providing a fresh solution to this question. We are serving more than 10000+ Students in Australia, the UK, and the US by helping them to score HD in their academics. Our Experts are well-trained to follow all marking rubrics and referencing styles.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.