Q2-1 Naming cells in spreadsheets
In a spreadsheet cell references can be replaced with names. Then the formula can use the names rather that cell references. Paste an example, using simple numbers, of Sales revenue less Expenses = Net Income.
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 replication
How can spreadsheets be designed so as to save effort with using the same spreadsheet month after month? Give a simple spreadsheet example.
Q2-4 IF functions
Find and briefly describe a youtube that explains the 'IF' statement (function).
Q2-5 Spreadsheet apps
Microsoft Excel is an example of spreadsheet software. List five further examples of spreadsheet software.
This group of questions above can be answered from any source including internet resources.
Q2-6 Perpetual versus Periodic systems
Watch the 3 videos on Inventory in Interact2 Resources. Explain the essential differences between perpetual and periodic inventory systems. Give examples of products/situations suited to each.
Q2-7 Journal entries
Watch the 3 videos on Inventory in Interact2 Resources. Show the journal entries for perpetual inventory and periodic inventory systems for the purchase, sale of inventory 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 solution showing the data entry area, the worksheet and the financial reports.
B. Create a new set of data and reports. Change every number and enhance/improve the example to prepare 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.
C. Write a business report pointing out that corporate spreadsheets sometimes contain errors. Use resources on the Internet to enhance your report.