Term

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


Term

Definition


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
What is the addition function? 

Definition


Term
What is the average function? 

Definition


Term
What is the maximum function? 

Definition


Term
What is the minimum function? 

Definition


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


Term

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 nonvalidated list? 

Definition
Allows additional entries other than those provided in the dropdown menu. 


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. 

