MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide

Chapter 4Performing Operations by Using Formulas and Functions

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Perform operations by using formulas and functions
  • Insert references
    • Insert relative, absolute, and mixed references
    • Reference named ranges and named tables in formulas
  • Calculate and transform datas
    • Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
    • Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
    • Perform conditional operations by using the IF() function
  • Format and modify text
    • Format text by using RIGHT(), LEFT(), and MID() functions
    • Format text by using UPPER(), LOWER(), and LEN() functions
    • Format text by using the CONCAT() and TEXTJOIN() functions

When you type a formula ...