# Excel Practice Online: 95 Exercises with Answers
> Excel practice online with 95 interactive exercises and answers. Type real formulas into a live grid and get instant feedback. Start free, no download.

- Web page: https://logicexcel.com/practice/excel-exercises
- Language: en
- Also in: [Deutsch](https://logicexcel.com/de/practice/excel-exercises.md), [Español](https://logicexcel.com/es/practice/excel-exercises.md), [Français](https://logicexcel.com/fr/practice/excel-exercises.md)
- 95 Lessons

## SUM Functions

- [SUM Function](https://logicexcel.com/practice/1.md)
- [SUMIF Function](https://logicexcel.com/practice/29.md)
- [SUMIFS Function](https://logicexcel.com/practice/30.md)
- [SUM Functions Skill Summary](https://logicexcel.com/practice/32.md)
- [SUM Function](https://logicexcel.com/practice/55.md)
- [SUMIF Practice](https://logicexcel.com/practice/60.md)
- [SUMIFS Practice](https://logicexcel.com/practice/61.md)
- [Debugging SUM Functions](https://logicexcel.com/practice/84.md)

## Intro to Shortcuts

- [Intro to Shortcuts](https://logicexcel.com/practice/2.md)
- [Text Formatting Shortcuts](https://logicexcel.com/practice/3.md)
- [SUM, Ribbon and Formatting Shortcuts Practice](https://logicexcel.com/practice/4.md)
- [Data Shortcuts](https://logicexcel.com/practice/10.md)
- [Cut, Copy, Paste](https://logicexcel.com/practice/76.md)
- [Number Formatting Shortcuts](https://logicexcel.com/practice/77.md)
- [Fill Right & Fill Down](https://logicexcel.com/practice/81.md)

## Cell Selection Shortcuts

- [Cell Selection Shortcuts](https://logicexcel.com/practice/5.md)
- [Larger Cell Selections](https://logicexcel.com/practice/6.md)
- [Row and Column Selections](https://logicexcel.com/practice/7.md)
- [Cell Selection Skill Summary](https://logicexcel.com/practice/8.md)
- [Cell Selection Shortcuts 2](https://logicexcel.com/practice/74.md)
- [Larger Cell Selections 2](https://logicexcel.com/practice/75.md)
- [Arrow Keys](https://logicexcel.com/practice/78.md)

## Logical Functions

- [IF Function](https://logicexcel.com/practice/9.md)
- [IF, VLOOKUP and Data Shortcuts Practice](https://logicexcel.com/practice/12.md)
- [AND, OR, XOR Functions](https://logicexcel.com/practice/17.md)
- [AND, OR, XOR, TEXTJOIN, LARGE and SMALL Practice](https://logicexcel.com/practice/20.md)
- [IS Functions](https://logicexcel.com/practice/41.md)
- [IS, ODD, EVEN, YEAR and TODAY Practice](https://logicexcel.com/practice/44.md)
- [True & False](https://logicexcel.com/practice/48.md)
- [IFS Function](https://logicexcel.com/practice/64.md)
- [SWITCH Function](https://logicexcel.com/practice/65.md)
- [IF Combinations](https://logicexcel.com/practice/82.md)
- [Operators](https://logicexcel.com/practice/93.md)

## Lookup Functions

- [VLOOKUP Function](https://logicexcel.com/practice/11.md)
- [HLOOKUP Function](https://logicexcel.com/practice/49.md)
- [VLOOKUP Practice](https://logicexcel.com/practice/58.md)
- [XLOOKUP Function](https://logicexcel.com/practice/63.md)
- [VLOOKUP Function 2](https://logicexcel.com/practice/71.md)
- [HLOOKUP Function 2](https://logicexcel.com/practice/72.md)
- [XLOOKUP Function 2](https://logicexcel.com/practice/73.md)
- [More VLOOKUP Practice](https://logicexcel.com/practice/79.md)
- [VLOOKUP Approximate Match](https://logicexcel.com/practice/80.md)
- [XLOOKUP](https://logicexcel.com/practice/85.md)
- [Dependent Drop-Down Lists](https://logicexcel.com/practice/86.md)
- [FILTER Function](https://logicexcel.com/practice/88.md)
- [VLOOKUP with Multiple Criteria](https://logicexcel.com/practice/95.md)

## Text Search Functions

- [LEN, LEFT, and RIGHT Functions](https://logicexcel.com/practice/13.md)
- [LEFT, RIGHT, LEN and INDEX Practice](https://logicexcel.com/practice/16.md)
- [FIND Function](https://logicexcel.com/practice/35.md)
- [MID Function](https://logicexcel.com/practice/50.md)
- [LEN, LEFT, RIGHT, MID Practice](https://logicexcel.com/practice/62.md)
- [Wildcard Characters](https://logicexcel.com/practice/67.md)
- [SEARCH Function](https://logicexcel.com/practice/70.md)

## Index Match Lookup

- [INDEX Function](https://logicexcel.com/practice/14.md)
- [MATCH Function](https://logicexcel.com/practice/21.md)
- [INDEX Function Practice](https://logicexcel.com/practice/22.md)
- [INDEX MATCH Lookup](https://logicexcel.com/practice/23.md)
- [Index Match Skill Summary](https://logicexcel.com/practice/24.md)
- [INDEX MATCH Practice](https://logicexcel.com/practice/59.md)
- [MATCH Practice](https://logicexcel.com/practice/83.md)
- [Two-Way Lookup](https://logicexcel.com/practice/94.md)

## Text Manipulation Functions

- [CONCAT Function](https://logicexcel.com/practice/15.md)
- [TEXTJOIN Function](https://logicexcel.com/practice/18.md)
- [SUBSTITUTE Function](https://logicexcel.com/practice/34.md)
- [UPPER, LOWER, and PROPER Functions](https://logicexcel.com/practice/47.md)
- [TRIM Function](https://logicexcel.com/practice/89.md)

## Statistical Functions

- [MIN, MAX, LARGE, SMALL Functions](https://logicexcel.com/practice/19.md)
- [AVERAGE Function](https://logicexcel.com/practice/31.md)
- [FLOOR & CEILING Functions](https://logicexcel.com/practice/33.md)
- [FLOOR, CEILING, SUBSTITUTE and FIND Practice](https://logicexcel.com/practice/36.md)
- [ODD and EVEN Functions](https://logicexcel.com/practice/42.md)
- [MIN, MAX, LARGE, SMALL Practice](https://logicexcel.com/practice/57.md)
- [MEDIAN Function](https://logicexcel.com/practice/66.md)
- [MODE Function](https://logicexcel.com/practice/68.md)
- [Standard Deviation](https://logicexcel.com/practice/90.md)

## COUNT Functions

- [COUNT Function](https://logicexcel.com/practice/25.md)
- [COUNTIF Function](https://logicexcel.com/practice/26.md)
- [COUNTIFS Function](https://logicexcel.com/practice/27.md)
- [COUNT Skill Summary](https://logicexcel.com/practice/28.md)
- [COUNT Practice](https://logicexcel.com/practice/56.md)

## Tables

- [Pivot Tables 1](https://logicexcel.com/practice/37.md)
- [Pivot Tables 2](https://logicexcel.com/practice/38.md)
- [Table Filters](https://logicexcel.com/practice/39.md)
- [Tables Skill Summary](https://logicexcel.com/practice/40.md)

## Date Functions

- [TODAY Function](https://logicexcel.com/practice/43.md)
- [DATEDIF Function](https://logicexcel.com/practice/51.md)
- [DATE Function](https://logicexcel.com/practice/52.md)
- [DATE Functions Skill Summary](https://logicexcel.com/practice/53.md)
- [DAYS Function](https://logicexcel.com/practice/69.md)
- [TIME Functions](https://logicexcel.com/practice/92.md)

## Other Excel Skills

- [Worksheets](https://logicexcel.com/practice/45.md)
- [Conditional Formatting](https://logicexcel.com/practice/46.md)
- [Find Duplicates](https://logicexcel.com/practice/87.md)
- [SORT Function](https://logicexcel.com/practice/91.md)

## Wine Dashboard Project

- [Wine Dashboard Lesson](https://logicexcel.com/practice/54.md)
