Spreadsheet apps Microsoft Excel is an example of spreadsheet software. List 4 further examples

Task 2 covers study schedule weeks 5-12 inclusive

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.