Upload File
Q1 Naming cells in spreadsheets (4 marks) See support.office.com/en-us/article/Define-and-use-names-in-formulas-4D0F13AC-53B7-422E-AFD2-ABD7FF379C64 Why replace cell references with names? Create a si
Question Preview:
Q1 Naming cells in spreadsheets (4 marks) See support.office.com/en-us/article/Define-and-use-names-in-formulas-4D0F13AC-53B7-422E-AFD2-ABD7FF379C64 Why replace cell references with names? Create a simple spreadsheet and paste Sales less Expenses = Net Profit. Q2 Negative numbers (3 marks) Why do accountants display negative numbers in brackets? How can negative numbers be displayed in brackets? Paste a simple spreadsheet example. See: support.office.com/en-us/article/change-the-way-negative-numbers-are-displayed-104b47a6-8ae2-471f-8f73-c4b96e7bb146 Q3 Separation of data and report areas...Solution Preview:
Solution to Question 1:
Cell references are replaced with names to make it easy and less cumbersome to be used. Specifically, naming a range of cells in a spreadsheet makes it a lot easy to be
used in formulas and the range of cells need not be defined always. Cell references create simple and plain text name of a range of cells and make it easy to be referred in
the workbook.
This report aimed to develop a critical understating of the various accounting software by evaluating the cloud-based accounting software in regards to businesses and then suggest the most appropriate accounting software to a chosen company such as Woolworth. The findings of the current report reflected that the company has key activities like manage, organize, maintain its store staff, develop various strategies for the business, billing for their products, maintain their transactions, and records them and handle their conflicts, etc. Similarly, its other activities related to revenue and expenditure cycle also includes sales and purchase related practices. Moreover, some internal controls are found weak in Woolworth due to which company has risks like segregation of duties, major frauds, poor corporate governance, improper monitoring of managerial opportunistic behavior.
This report aimed to develop a critical understating of the various accounting software by evaluating the cloud-based accounting software in regards to businesses and then suggest the most appropriate accounting software to a chosen company such as Woolworth. The findings of the current report reflected that the company has key activities like manage, organize, maintain its store staff, develop various strategies for the business, billing for their products, maintain their transactions, and records them and handle their conflicts, etc. Similarly, its other activities related to revenue and expenditure cycle also includes sales and purchase related practices. Moreover, some internal controls are found weak in Woolworth due to which company has risks like segregation of duties, major frauds, poor corporate governance, improper monitoring of managerial opportunistic behavior.
