LoslegenKostenlos loslegen

Write your own criteria

In this exercise we will complete the Criteria Table ourselves, based on the requirements.

As a reminder, below we display the syntax of one of these database functions, DCOUNT( ) and a brief recap on Criteria Table:

Syntax of Excel DCOUNT () function and criteria table explained

Our criteria for this exercise: Order Item IDs with Sales > $1000 in California.

Diese Übung ist Teil des Kurses

Advanced Excel Functions

Kurs anzeigen

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten