Module 4 – Spreadsheets

0

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

Leave a Reply

Your email address will not be published. Required fields are marked *

 
United Nations Volunteers Online Volunteering service.

Copyright © 2017 ITdesk.info All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.5, from BuyNowShop.com.