IF, AND, OR, COUNTIF, SUMIFS: decide and total by condition.
16 esercizi a correzione automatica su 3 argomenti, circa 96 minuti in tutto. Ognuno apre un vero foglio di calcolo con dati realistici, controlla il risultato e la formula e ti dice cosa correggere. Gratis, senza registrazione.
IF, COUNTIF and SUMIF appear in candidate reports of the legacy Indeed test and in bank interview reports; COUNTIFS, SUMIFS and nested IF or IFS fill intermediate screenings, employer workbook tests and the MOS Expert outline.
Pass/fail flags, eligibility rules and tiered commissions on real-size datasets.
Count orders by status, by region and month, between two dates and with wildcards.
Totals by region, by product, above a threshold — the way reports are actually built.
8 esercizi di questo percorso
Day 1: the free timed test at your level. Days 2–6: three graded exercises a day. Day 7: retake it and compare.
7 esercizi di questo percorso
For analyst work and the Level 3 project test: summary grids, cleanup, expert lookups and pivot-style reports.
6 esercizi di questo percorso
For office and admin work: tidy exports, counts, IF rules, lookups, due dates and a tracker that rejects bad input.
8 esercizi di questo percorso
For sales and marketing ops: totals by region and rep, commission tiers, lookups, clean customer lists and live reports.
7 esercizi di questo percorso
For AP/AR, bookkeeping and month-end work: tax lines, due dates, overdue invoices, SUMIFS by month and lookups.
9 esercizi di questo percorso
For complete beginners: from the first SUM to lookups, IF rules and a tidy tracker, in 14 short days of graded practice.
15 esercizi, circa 67 min
SUM to sort and filter: the formulas and sheet skills every job expects on day one.
11 esercizi, circa 77 min
VLOOKUP, XLOOKUP, INDEX and MATCH: pull values from other tables and sheets.
9 esercizi, circa 59 min
Split, clean and join text; count days, deadlines and working days.
7 esercizi, circa 56 min
UNIQUE, FILTER, SORTBY, conditional formatting and data validation.
11 esercizi, circa 91 min
Pivot-style summaries with SUMIFS and GROUPBY, PivotTable screens, and picking, reading and fixing charts.
Gratis, senza account e senza installare nulla.
Excel è un marchio del gruppo di società Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria e gli altri marchi appartengono ai rispettivi proprietari. GridBelt è indipendente: non è affiliato a nessuno di loro, né approvato o sponsorizzato da alcuno di essi.