CLASS OBJECTIVE
Review the topics on Spreadsheets in preparation for the Summative Evaluation of the period.
Summary of Period II
This week you will have to do a review of the topics we've been learning in Period II.
In your notebook you will answer the following questions, using your own words. Logically I suggest you use the class blog to recall all the information.
REVIEW QUESTIONNAIRE- GOOGLE SPREADSHEETS
1.- In your own words, what is an spreadsheet?
2.- What is a cell, a row, a column and a range?
3.- Explain the procedures to select a cell, a row, a column and a range?
4.- Explain the next cell formats using examples
- Font
- Fill color
- Alignment
- Borders
- Number format (Currency, decimal positions)
5.- What are "comments" in a cell?
6.- What is a Data Table?
7.- Using examples, explain how to use the following arithmetic operations
- Addition
- Subtraction
- Multiplication
- Division
8.- What is a Function in a spreadsheet?
9.- What is the "syntax of a function"?
10.- Write a clear example and explain what is the common use fot the next functions:
=COUNT
=COUNTA
=COUNTBLANK
=MINUS
=PRODUCT
=RANDBETWEEN
At the end, show to you teacher your questionnaire for signature.
ACTIVITY 1
Now it's time to carry out a small activity in which you will put into play your skills in handling data in spreadsheets, creating formulas and functions.
