Q2-1 Naming cells in spreadsheets
Critically evaluate a YouTube video on naming cells in spreadsheets. What are the advantages of naming cells in formulas Paste an example, using simple numbers.
Q2-2 Negative numbers
Create a simple spreadsheet example of Sales revenue less Expenses to give Net income where Expenses are greater than Sales revenue. Display the negative result in brackets. Also incorporate an IF function.
Q2-3 Spreadsheet structures.
Why should spreadsheets be designed with separate data and report areas and with the report area containing only formulas? Create and paste a simple spreadsheet example.
Q2-4 IF functions
Find and briefly describe a YouTube video that explains the 'IF' statement (function). Create and paste a simple example.
Q2-5 Spreadsheet apps
Microsoft Excel is an example of spreadsheet software. List four further examples of spreadsheet software.
Q2-6 Perpetual versus Periodic systems
Review your text chapter 5 including appendix 5A and watch the 3 videos on Inventory in Interact2 Resources. Create a table to explain the essential differences between perpetual and periodic inventory systems. Give examples of products/situations suited to each.
Q2-7 Journal entries
Review your text chapter 5 including appendix 5A and watch the 3 videos on Inventory in Interact2 Resources. Show the journal entries for perpetual inventory and periodic inventory systems for the purchase of inventory, sales returns and end of period stocktake.
Q2-8 Worksheet and financial reports
Watch the Foot Worksheet video in Interact2 resources. Download the relevant doc file also in Interact2 resources. This doc file has a template of the example below.
A. Create a spreadsheet report showing the data entry area, the worksheet and the financial reports. Paste the normal view.
B. Paste a complete formula view.
C. Create a new set of data and reports. Change six data numbers and create a ten column spreadsheeted worksheet and the Financial Reports. Do not create journal entries or ledger accounts. Ensure your trial balance still balances after your data changes.
Follow the spreadsheet requirements including a separate data entry and report area and implement IF functions wherever appropriate. Paste two normal views and one formula view.
D. Write a business report as if for senior management pointing out that corporate spreadsheets sometimes contain errors. Use resources on the Internet to enhance your report (about 300 words).
Use the following resources to help you prepare and format your report:
http://bit.ly/FoBAcademic-Writing-Skills
unilearning.uow.edu.au/report/rep_business.html