ABS and MOD in Excel - Dashboard Guide

Dashboard Mode - ABS and MOD

Dashboard Goal

This dashboard helps you understand how to use the ABS and MOD functions in Excel to analyze numbers. You will see how to get absolute values and find remainders from division, which are useful in many real-life situations like calculating distances or checking if a number is even or odd.

Sample Data

Number	Description
-15	Negative number
22	Positive number
-7	Negative number
0	Zero
13	Positive number
-4	Negative number
8	Positive number

Dashboard Components

• KPI Card: Absolute Values
  Formula: =ABS(A2) copied down for all numbers.
  Shows the positive distance of each number from zero.
  Example: ABS(-15) = 15
• KPI Card: Remainder When Divided by 3
  Formula: =MOD(A2, 3) copied down.
  Shows the remainder after dividing each number by 3.
  Example: MOD(22, 3) = 1
• Table: Combined Results
  Columns: Number, ABS(Number), MOD(Number, 3)
  Formulas:
  ABS in B2: =ABS(A2)
  MOD in C2: =MOD(A2, 3)
  Copy down for all rows.

Dashboard Layout

+----------------------+-------------------------+
|  Absolute Values KPI  |  MOD 3 Remainder KPI    |
|  (Column B)           |  (Column C)             |
+----------------------+-------------------------+
|          Combined Table (Columns A to C)          |
+---------------------------------------------------+

Interactivity

You can filter the numbers to see ABS and MOD results for only positive or negative numbers. When you apply a filter on the Number column, both the Absolute Values and MOD remainder results update automatically to show only the filtered data.

Self Check

Add a filter to show only numbers greater than 0. Which ABS and MOD results remain visible? What are their values?

Key Result

Dashboard showing absolute values and remainders of numbers divided by 3 using ABS and MOD functions.