Assignment title: Information


Task 2 covers study schedule weeks 5-12 inclusiveQ2-1 Naming cells in spreadsheetsIn 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 numbersCreate 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 replicationHow 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 functionsFind and briefly describe a youtube that explains the 'IF' statement (function).Q2-5 Spreadsheet appsMicrosoft 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 systemsWatch 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 entriesWatch 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 reportsWatch 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