# Shared Flashcard Set

## Details

Formulas that are used in spreadsheets.
28
Computer Science
11/16/2010

Term
 What is a formula?
Definition
 Words and numbers that tells the software to perform calculations.
Term
 How would you write a formula for adding the numbers in row 3, columns A, C and D?
Definition
 =A3+C3+D3
Term
 What is a function?
Definition
 A shortcut to a formula.
Term
 What are two way that you could add the numbers from B1 to B7?
Definition
 =B1+B2+B3+B4+B5+B6+B7 OR =SUM(B1:B7)
Term
 What are the four operators that are used in formulas?
Definition
 + (Plus: used in addition) - (Minus: used in subtraction) * (Asterisk: used in multiplication) / (Slash: used in division)
Term
 If a cell value has a \$ symbol in its name, what does that mean?
Definition
 It is an absolute cell reference.
Term
Definition
 =SUM(A3:A6)
Term
 What is the average function?
Definition
 =AVERAGE(A2:A9)
Term
 What is the maximum function?
Definition
 =MAX(C4:C18)
Term
 What is the minimum function?
Definition
 =MIN(C4:18)
Term
 What does the maximum function do?
Definition
 Finds the largest number in a range.
Term
 What does the minimum function do?
Definition
 Finds the lowest nunmber in a range.
Term
 What does the addition function do?
Definition
Term
 What does the average function do?
Definition
 Averages the numbers in a range.
Term
 What does an IF function do?
Definition
 Results are ruturned if specified data in an equation meets certain conditions in the formula.
Term
 How is an IF statement written?
Definition
 =IF(statement,"statement true","statement false"") EX: =IF(A1>5,"Yes","No")
Term
 What is the NOW function used for?
Definition
 To tell the current date and time.
Term
 How is the NOW function written?
Definition
 =NOW()
Term
 What is DAYS360?
Definition
 A function that calculates the difference between two dates.
Term
 What is the LOOKUP function?
Definition
 Used to compare cell values to an array of cells and return a value.
Term
 What is the VLOOKUP function?
Definition
 The LOOKUP function with more than two columns in the array.
Term
 What can the LIST function be used for?
Definition
 To control the size of entries or filter for specific content within a list.
Term
 What is a validated list?
Definition
 Limits data entries to specific choices programmed into the function.
Term
 What is a non-validated list?
Definition
Term
 What is the COUNT function?
Definition
 Counts the number of cells in a range.
Term
 What is the function COUNT do?
Definition
 Counts the number of cells in a range with numbers.
Term
 What does the function COUNTA do?
Definition
 The number of cells in a range that contain a value or letter.
Term
 What does the COUNTIF function do?
Definition
 Cekks that meet certain conditions in the formula.
Supporting users have an ad free experience!