Shared Flashcard Set

Details

Mathematical spreadsheet functions
Mathematical spreadsheet functions
16
Computer Science
10th Grade
12/08/2012

Additional Computer Science Flashcards

 


 

Cards

Term
SUM({cell range})
Definition
Find the sum of all the numbers in the cell range.
Term
SUMIF({cell range}, {condition}, {sum range})
Definition
Find the sum of all the numbers in the cell range whose corresponding sum range number satisfies the condition.
Term
SUMPRODUCT({cell range 1}, {cell range 2}, ... {cell range n})
Definition
Find the sum of the products of the corresponding items in each of the cell ranges.
Term
SUMSQ(number 1, number 2, ... number n)
SUMSQ({cell range})
Definition
Find the sum of the squares of the numbers.
Term
ROUND (number, decimal places)
Definition
Round a number off to a number of decimal places.
Term
ROUNDDOWN(number, decimal places)
Definition
Round a number down a number of decimal places (if the number is positive) or round a number up a number of decimal places (if the number is negative).
Term
ROUNDUP(number, decimal places)
Definition
Round a number up a number of decimal places (if the number is positive) or round a number down a number of decimal places (if the number is negative).
Term
INT(number)
Definition
Round a number down to the nearest integer.
Term
TRUNC(number, decimal places)
[-1 decimal places will truncate it to the tens digit, etc.]
Definition
Truncate a number to a number of decimal places.
Term
QUOTIENT (dividend, divisor)
Definition
Find the integer portion of the quotient of a division operation.
Term
MOD(dividend, divisor)
Definition
Find the remainder of a division operation.
Term
POWER(number, power)
Definition
Find a power of a number.
Term
SQRT(number)
Definition
Find the square root of a number.
Term
RAND()
Definition
Get a random number smaller than one but larger than or equal to zero.
Term
ABS(number)
Definition
Get the absolute value of a number.
Term
FREQUENCY({cell range}, {range range})
[Array function.]
Definition
Create a frequency distribution table using the data in a cell range and the ranges in a range range.
Supporting users have an ad free experience!