Excel Quiz

Front

Excel Functions

Back

SUM, AVERAGE, COUNT, etc.

Front

Pivot Tables

Back

Summarize data, drag and drop fields

Front

Excel Dashboards

Back

Visual data representation, interactive charts

Front

IF Functions

Back

Conditional logic, IF(condition, true, false)

Front

Lookups

Back

VLOOKUP, HLOOKUP, search data

Front

Graphs

Back

Bar, line, pie charts

Front

Data Cleaning

Back

Remove duplicates, trim spaces

Front

Conditional Formatting

Back

Highlight cells, color scales

Front

Data Validation

Back

Restrict input, dropdown lists

Front

Date Functions

Back

TODAY, NOW, DATE, YEAR