Adds together a range of numbers., =SUM(range), Finds the mean average of a range of numbers., =AVERAGE(range), Tests a condition and returns one value if true and another if false., =IF(condition, value_if_true, value_if_false), Looks for a value in the first column of a table and returns information from another column in the same row., =VLOOKUP(lookup_value, table_range, column_number, exact/approx), Finds the largest number in a range., =MAX(range), Finds the smallest number in a range., =MIN(range), Counts how many cells in a range contain numbers., =COUNT(range), Counts how many cells in a range are not empty., =COUNTA(range), Counts how many cells in a range meet a condition., =COUNTIF(range, condition), Counts the number of characters in a cell, including letters, numbers, spaces and punctuation., =LEN(cell), Multiplies numbers together., =PRODUCT(range).
0%
Excel Functions
Share
Share
Share
by
Jmorris42
Y10
ICT
Edit Content
Print
Embed
More
Assignments
Leaderboard
Show more
Show less
This leaderboard is currently private. Click
Share
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
Revert Options
Match up
is an open-ended template. It does not generate scores for a leaderboard.
Log in required
Visual style
Fonts
Subscription required
Options
Switch template
Show all
More formats will appear as you play the activity.
)
Open results
Copy link
QR code
Delete
Continue editing:
?
