AKSNOVAEDUTECH

ONE FORMULA A DAY

Daily Excel Challenge

A small sheet, one question, one formula. Any formula that gives the right answer counts. Come back tomorrow for the next one.

Today's challenge · 2 NovemberEasy

New today

Join the names

For row 2, join the First name and Last name with a space between: "sneha PATIL".

ABC
1
2
3
4

Tap a cell to put its name in your formula.

WHAT THE CHALLENGES TEACH

What the challenges teach

32 challenges rotate through the functions and ideas every office uses:

  • SUM
  • AVERAGE
  • MAX
  • COUNTIF
  • SUMIF
  • COUNTIF with >
  • IF
  • COUNTIF with >=
  • ROUND
  • LARGE
  • RANK
  • Multiplication
  • SUMPRODUCT
  • VLOOKUP
  • INDEX and MATCH
  • COUNTA
  • Division
  • Percentage
  • INDEX and MATCH with MIN
  • COUNTIF with COUNTA
  • IF with COUNTIF
  • & (join text)
  • PROPER
  • LEFT with FIND
  • LEN
  • Percentage change
  • SUM in a comparison
  • IF with comparison
  • AVERAGEIF
  • SUMPRODUCT with a comparison

Want the whole toolbox?

Data Analytics takes you from SUM to pivot tables, SQL and Power BI dashboards, hands-on. Free career counselling before you pay.

See the Data Analytics course

GOOD TO KNOW

Excel Challenge Questions

How does the daily Excel challenge work?
Every day there is a small sheet and one question. Type a formula like you would in Excel (starting with =) and check it. Any formula that gives the right answer counts, hints are there if you are stuck, and there is a fresh challenge every day. Nothing is saved: the website keeps no record of your answers.
What is the difference between COUNT and COUNTA?
COUNT counts cells that hold numbers. COUNTA counts every cell that is not empty, text included. COUNTBLANK counts the empty ones.
What does VLOOKUP do?
VLOOKUP looks for a value in the first column of a table and returns a value from the same row in another column: VLOOKUP(what to find, table, column number, FALSE). FALSE asks for an exact match; without it Excel assumes the first column is sorted and may return the wrong row.
Why does Excel say #NAME?, #VALUE! or #DIV/0!?
#NAME? means a function or range is misspelt. #VALUE! means a value has the wrong type, usually text where a number is needed. #DIV/0! means the formula divides by zero or an empty cell. #N/A means a lookup did not find its value.