How can negative numbers be displayed in brackets

Task Q1 Naming cells in spreadsheets (4 marks) Why replace cell references with names? Create a simple spreadsheet and paste Owners Equity plus Liabilities = Assets. Q2 Negative numbers (3 marks) How can negative numbers be displayed in brackets? Why do accountants display negative numbers in brackets? Paste a simple spreadsheet example. See: Q3 Separation of data and report areas (5 marks) Explain why an accountant should design spreadsheets with a completely separate data entry area and a separate report area? Paste a simple spreadsheet example. Show normal and normal views. Q4 IF functions (5 marks) Find a relevant Youtube and explain the 'IF' statement (function)? Provide a simple spreadsheeted accounting example for a trial balance. Show normal and normal views. Q5 Periodic systems (5 marks) Explain periodic inventory systems. Give examples. (Watch the 3 videos on Inventory in Interact2 Resources). Q6 Worksheet and financial reports (12 marks) Watch the Foot Worksheet movie in Interact2 resources. Download the relevant word file also on Interact2 resources. This Word file has a template. A. Create a handwritten solution showing the worksheet and the financial reports. Paste images of your handwritten report in your assignment. If using a smart phone, consider using a free scanning app such as Camscanner, Office Lens, Google Drive or search for an app. Let us know which app you chose. B. Create a spreadsheet solution following all the usual spreadsheet requirements. Follow all the spreadsheet requirements including a separate data entry and report area and implement IF functions wherever appropriate. As usual, paste the normal view and the formula view. C. Write a business report evaluating spreadsheets as a tool for accounting. You may wish to search the Internet with terms such as “advantages of spreadsheets”. Use Internet resources to help you prepare and format your business report: