Performing Conditional Operations Using Functions

Practice Labs Module
Time
51 minutes
Difficulty
Intermediate

The "Perform Conditional Operations Using Functions" module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises: Perform Logical Operations using IF and SUMIF.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Perform Conditional Operations Using Functions module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises:

  • Perform Logical Operations using IF and SUMIF

Lab time: It will take approximately 1 hour to complete this lab.

Exercise 1 - Perform Logical Operations using IF and SUMIF

Decision-making functions test a logical condition, then return a value or take an action. For example, you might want to know the sales figures that result if a certain condition is true. Excel has many functions, such as IF, AND, and SUMIFS, that evaluate conditions before returning a value.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.