Calculations

Watch these videos before proceeding

• VIDEO:  Spreadsheet math - + - / = ^ * [16:57] - ss (commands)

• VIDEO:  Count, CountA, CountBlank, CountIfs [9:16] - ss (commands)

• VIDEO:  Count, CountA, CountIF, CountIFS, CountBlank [8:10] ss- (SoCal birds)

• VIDEO:  Basic statistics: Max, Min, Average, [6:06] - ss (commands)

• VIDEO:  Logic Statements: Now, If, And [3:26] - ss (commands)

• VIDEO:  Sorting on a calculated column [3:38] - ss (forests)

• File: Spreadsheet commands - copy this file and study the associated videos

(1)  Calculations-1

Examine the formulas embedded in the locked sheets.  Once you understand them, input the necessary formulas in the quiz sheet to auto-generate the correct answers. 

• Task: Calculations-1 quiz

(2)  Calculations-2

Examine the formulas embedded in the locked sheets.  Once you understand them, input the necessary formulas in the quiz sheet to auto-generate the correct answers. 

• Task: Calculations -2 quiz

(3) Calculations-3

Examine the formulas embedded in the locked sheets.  Once you understand them, input the necessary formulas in the quiz sheet to auto-generate the correct answers. 

• Task: Calculations-3 quiz

(4) Calculations - 4

Create equations with appropriate reference cells for each of the equations in this spreadsheet

• Task: Calculations-4 quiz