Excel Exercise - Assignment 9 - Georgia State University

Excel Exercise - Assignment 9

views comments

Assignment 9: COUNTIF Function

Assignment Goal: This exercise is designed for students to learn how to create COUNTIF functions to summarize data.

Weekly Outcomes: At the completion of this week’s assignment, students will have two new cells containing (1) the number of months with a positive trend and (2) the number of months with high volume traded.

Weekly Topics/Tasks: COUNTIF Function

Create a COUNTIF function to determine how many months saw a positive trend (in both years)
Create a COUNTIF function to determine how many months saw a high volume of shares traded (in both years)

Tags