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 non-validated 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. |
|
|
