Calculations
Note: This is an asyncrhonous session. You can complete it at any time prior to the next regularly scheduled session.
Introduction
File: Spreadsheet commands - copy this file and study the associated videos
VIDEOS:
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