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:

Spreadsheets – Microsoft Excel 2010: Link

Handbook:

Spreadsheets – Microsoft Excel 2010: Link

 

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

Sample exercise and exercise solution:

exercise Spreadsheets >   Link

Spreadsheets – exercise solution  >  view presentation

Quiz:

Spreadsheets – quiz 1  > start the quiz

Spreadsheets – quiz 2  > start the quiz

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

Proofreading: Ana Kedves

ISBN: 978-953-7908-15-7