Calculations

Introduction

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

VIDEOS: 

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

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

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

• Basic statistics: Max, Min, Average, StDev, Sum [7:45] - ss (commands)

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

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

(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