Excel

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/7

flashcard set

Earn XP

Description and Tags

Formulas for all functions

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

8 Terms

1
New cards

SUM: Adds up a range of cells.

Ex: =SUM(A1:A5)

2
New cards

AVERAGE: Calculates the average of a range of cells.

Ex: =AVERAGE(A5:A10)

3
New cards

COUNT: Counts the number of cells containing numbers.

Ex: =COUNT(A10:A14)

4
New cards

MIN: Finds the smallest value in a range

Ex: = MIN(A15:A18)

5
New cards

MAX: Finds the largest value in a range.

Ex: =MAX(A20:A30)

6
New cards

MOD: Returns the remainder after division.

Ex: =MOD(A14:A19)

7
New cards

ROUND: Rounds a number to a specified number of decimal places.

Ex: =ROUND(A1:A10)

8
New cards