Excel
0.0(0)
Studied by 1 person
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt PlayCard Sorting
1/7
Earn XP
Description and Tags
Formulas for all functions
Last updated 8:09 AM on 5/28/25
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
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
Note 
Flashcards (44)