Which of the following types of data manipulation functions should a data analyst use to...

Logical functions are used in spreadsheets to create conditions that return YES/NO or TRUE/FALSE results. These functions include IF, AND, OR, NOT, etc., which are specifically designed for decision-making processes in data analysis. For example, the IF function in Excel evaluates a condition and returns one value if TRUE and another if FALSE, perfectly implementing YES/NO logic.

CompTIA Data+ Reference:

CompTIA Data+ Study Guide (Exam DA0-001), Chapter 4: Data Manipulation and Analysis, Section “Data Manipulation Functions – Logical”, Official CompTIA CertMaster Learn for Data+, Module 4.3 “Logical Functions in Spreadsheets”.