ICT: EXCEL FORMULAS

0.0(0)
studied byStudied by 0 people
0.0(0)
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/6

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

7 Terms

1
New cards

SUM()

=SUM(sum_range)

2
New cards

SUMIF()

=SUMIF(range, criteria, sum_range)

3
New cards

AVERAGE()

=AVERAGE(range to be averaged)

4
New cards

COUNT()

=COUNT(rage to be counted)

5
New cards

IF()

=IF(condition, result if true, result if false)

6
New cards

VLOOKUP()

=VLOOKUP (lookup_value, table_range, column index number, range lookup)

7
New cards

CONCATENATE()

=CONCATENATE(text 1, text 2, text 3)