Module 4 – Spreadsheets

In this module you can learn how to accomplish 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 cell range, column or row,
• select neighboring or non-neighboring rows or columns
• copy 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 formula for avreage, 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 pane
• insert, move and edit chart
• find and replace content

 

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

.

Notes:

Spreadsheets – Microsoft Excel 2010: Link

.

Sample exercise and exercise solution:

exercise Spreadsheets >   Link

Spreadsheets – exercise solution  >  view presentation

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

.

Quiz:

Spreadsheets > start the quiz

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