US93997-E116940 Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem (N3,Cr8,M8)

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

Course Content

Expand All

Module 1: Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem 22 Lessons

Expand

Module Content

0% Complete 0/22 Steps

1.1. Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem

1.2. Work with MS Excel

1.3. Perform all elements within the laws of the country

1.4. Health and safety

1.5. Ethical codes of relevant professional bodies

1.6. Use MS Excel to adjust settings to customise the view and preferences to suit the solution created for the given problem

1.7. Enlarge and make the view of the spreadsheet smaller

1.8. Freeze cells to prevent scrolling

1.9. Change the default file location

1.10. Use MS Excel to work with multiple worksheets to suit the solution to the given problem

1.11. Rename worksheets in terms of their purpose within the solution to the given problem

1.12. Use MS Excel to apply formulae to provide alternative solutions to the given problem

1.13. Demonstrate the difference between relative and absolute cell addressing by using it in a formula

1.14. Create scenarios that demonstrate different possible outcomes

1.15. Use MS Excel to apply simple built-in functions to the given problem

1.16. Explain functions in terms of their purpose, use and construct

1.17. Apply simple mathematical functions to the given problem

1.18. Use MS Excel to apply formatting and special effects applicable to the given problem

1.19. Explain methods of automatically formatting a spreadsheet

1.20. Create a spreadsheet using a template

1 of 2