IC3/Spreadsheets

A spreadsheet is an interactive computer application program for organization and analysis of data in tabular form.^[1]

This lesson introduces spreadsheets and helps learners prepare for the IC³ Key Applications certification exam.

Objectives and Skills

Objectives and skills for the spreadsheets portion of IC³ certification include:

Objectives^[2]

• Be able to modify worksheet data, structure and formatting
• Be able to sort data, manipulate data using formulas and functions, and create simple charts

Skills^[3]

• Layout: Insert/delete, cell sizes, alignment, navigation, merging cells
• Data Management: Filter and sort, formulas and functions, number format, cell format, charts, graphs

Readings

1. Read Wikipedia: Spreadsheet.

Multimedia

1. Watch YouTube: Microsoft Excel Basics.
2. Watch YouTube: Microsoft Excel: How to Copy, Move and Delete Cells.
3. Watch YouTube: How To Use Microsoft Excel-Help With Forumulas Functions.

Activities

1. Complete one or more of the following tutorials:
   • Google Spreadsheets
   • LibreOffice Calc
   • Microsoft Excel
   • Training courses for Excel 2010
   • Training courses for Excel 2013

See Also

• Spreadsheets
• Introduction to Computers

References

Subject classification: this is an information technology resource .

Resource type: this resource is a lesson.

Completion status: this resource is ~40% complete.