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)

Excel Functions

oleh
Cetakan
Benamkan

Papan mata

Gaya visual

Pilihan

Lebih tepat seperti ini

Match the Sum
Match the Sum
oleh
Kapal terbang
EXCEL numbers
EXCEL numbers
oleh
Roda rawak
Sums 1-10
Sums 1-10
oleh
Kuiz
Do sums (10-100)
Do sums (10-100)
oleh
Padankan
Zahlen 1-20 (Summen)
Zahlen 1-20 (Summen)
oleh
Pecahkan belon
Spreadsheet Functions
Spreadsheet Functions
oleh
Padankan
MS Excel - General
MS Excel - General
oleh
Silang kata
Spreadsheet Formulae and Formatting
Spreadsheet Formulae and Formatting
oleh
Kuiz

Tukar templat

Pulihkan autosimpan: ?