Edit Game
Excel Functions - One
 Delete

Use commas to add multiple tags

 Private  Unlisted  Public



 Save

Delimiter between question and answer:

Tips:

  • No column headers.
  • Each line maps to a question.
  • If the delimiter is used in a question, the question should be surrounded by double quotes: "My, question","My, answer"
  • The first answer in the multiple choice question must be the correct answer.

 Import questions





 Save   23  Close
What kind of chart is this?
Line chart
What kind of chart is this?
Scatterplot
What kind of graph is this?
Pie graph
What kind of graph is this?
Bar graph
What does =TODAY() do?
Provides today's date
What does =SUMIFS do?
Gives the sum of a range with multiple matching criteria
What does =SUMIF do?
Gives the sum of a range with one matching criteria
What does =SUM do?
Gives the sum of a range.
What does =NPV do?
Uses a percentage reference to return a net total.
What does =XOR do?
Returns false if only one condition is true.
What does =MODE do?
Find the mode of a range (the number that appears the most.)
What does =OR do?
Checks a range to see if EITHER condition is true or false
What does =RAND do?
Generate a random number.
What does =MIN do?
Find the lowest number in a range.
What does =MEDIAN do?
Find the median (middle) number.
What does the =MAX function do?
Returns the highest value in a range
What does the =IF function do?
Returns values based on a TRUE or FALSE condition
What does the =COUNTIFS function do?
Counts cells in a range based on one or more TRUE or FALSE condition
What does the =COUNTIF function do?
Counts cells as specified
What does the =COUNTA function do?
Counts all cells in a range that has values, both numbers and letters
What does the =COUNT function do?
Counts cells with numbers in a range
What does the =CONCAT function do?
Links together the content of multiple cells
What does the =AVERAGE function do?
Calculates the average (arithmetic mean)
What does the =AND function do?
Returns TRUE or FALSE based on two or more conditions
Your experience on this site will be improved by allowing cookies.