Module 4 – Spreadsheets

In this module you can learn how to accomplish the tasks associated with developing, formatting, modifying and using applications Microsoft Excel 2010 and OpenOffice.org Calc.

<<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>

Materials on basic computer e-education
published on ITdesk.info

<<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>

Video materials:

1. presentation on Spreadsheets – OpenOffice Calc   > view presentation

1. presentation on Spreadsheets – Microsoft Excel 2010   > view presentation

In these presentations you can see how to:

• select the cell range, column or row,
• select neighboring or non-neighboring rows or columns
• copy the cell content, use AutoFill
• format cells, insert column, enter formula, rename sheet

2. presentation on Spreadsheets – OpenOffice Calc    > view presentation

2. presentation on Spreadsheets – Microsoft Excel 2010   > view presentation

In these presentations you can see how to:

• insert date and time, header, footer, page number
• enter the formula for average, maximum, minimum
• use absolute addresses; use AutoFill feature

3. presentation on Spreadsheets – OpenOffice Calc    > view presentation

3. presentation on Spreadsheets – Microsoft Excel 2010   > view presentation

In these presentations you can see how to:

• use if function
• use AutoFill feature
• freeze the pane
• insert, move and edit charts
• find and replace the content

 <<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>

Notes:

Module 4 – Spreadsheets – Microsoft Excel 2010: link

Handbook:

Module 4 – Spreadsheets – Microsoft Excel 2010: link

Module 4 – Spreadsheets – LibreOffice Calc: link

Advanced spreadsheets – Microsoft Excel 2010: link

Advanced spreadsheets – LibreOffice Calc: link

 

<<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>

Sample exercise and exercise solution:

exercise Spreadsheets  > Link

Spreadsheets – exercise solution  > view presentation

Quiz:

Module 4 – Spreadsheets – quiz 1   > start the quiz

Module 4 – Spreadsheets – quiz 2   > start the quiz

 

Quizzes that cover advanced knowledge of the module:

Advanced spreadsheets: analysis and special tools – quiz

Advanced spreadsheets: usage of functions – quiz

Advanced spreadsheets: protection, sorting and queries – quiz

Advanced spreadsheets: naming cell ranges – advanced formatting – quiz

Advanced spreadsheets: handling data – connecting templates and charts – quiz

Advanced spreadsheets: editing data and display – quiz

 

<<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>

Proofreading: Ana Kedves

ISBN: 978-953-7908-15-7