Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

Normal Size Small Size show me how

# comp 25 excel quiz

Question | Answer |
---|---|

what are the excel cell types | labels(text), values (data), formulas (calculation) |

what do labels do | identifies values, left justified, ex. column headings, row headings, notes |

what are values | numbers, dates, times, can be used for calculations, right justified |

recognized as number if begins with | -, +, =, @, #. $, or any digit |

formulas | specifies calculations to be performed, begins with =, can contain cell references, operators, values and excel built in functions, arithmetic operators add, subtract, multip, div. recalculates with cell reference changes, ex. = A1 + B2, MUST have = sign. |

how to create a formula | need to see lecture on formulas and functions |

algebriac order of operations | 1. parenthesis 2. exponents 3. multiply and divide 4. add and subtract |

symbols for operations | parenthesis () exponents ^ mulitply * divide / add + subtract - |

relative cell | any cell reference that excel will automatically adjust to reflect the new location of the copied formulas containing the relative cell references. |

absolute cell references | when you want a cell reference to remain unchanged no matter where the formula containing it is copied. you placde a $ dollar sign before both the column and row portions of the cell reference. |

changing relative references to absolute references | 1. type formula in with relative addresses (=B4*E5) 2. place cursor at reference you want made absolute 3. press F4: B4 - $B$4 - B$4 - $B4 - B4. |

functions what are they? | 1.built-in ways to manipulate data to get an answer 2.give it numbers(or text) and get an answer 3.values you provide the function are called arguments 4.parentheses enclose the argument list(cells or other expressions needed for calculations) |

MIN Function | =MIN (cell range) - smallest number within the cell range named. It is a stat function that determines the minimum or smallest value of all the cells and values in its argument list. ex finding lowest temp of a long list of temps |

SUM Function | =SUM(cell range) - total of all cells listed as arguments. |

AVG Function | =AVERAGE(cell range) - Total of all the cells divided by the total number of cells listed. A statistical function that determines the average of all the cells. |

MAX Function | =MAX(cell range) - Largest number within cell range named. A statistical function that detemines the largest number. |

=AVERAGE() | Total of all the cells divided by the total number of cells |

=SUM() | total of all cells listed as arguments. |

=MIN() | smallest number within the cell range named. |

=MAX() | Largest number within cell range named. |

=NOW() | return the current date and time, this function takes not arguments and is volatile, which means it recalculates whenever excel calculates |

=TODAY() | return the current date, this function takes not arguments and is volatile, which means it recalculates whenever excel calculates |

=COUNT() | number of non-blank, non-text cells |

=COUNTA() | non-blank cells |

=COUNTBLANK() | counts blank cells |

=COUNTIF | based on criteria |

=ROUND() | rounds a # to a specified # of digits. If # of digits > 0, then # rounded to specified # of decimal places. If # of digits = 0, then # rounded to the nearest integer. If number of digits is < 0, then number is rounded to the left of the decimal point. |

=ROUNDUP() | rounds a # up away from zero. If # of digits is > 0 then # is rounded up to the specified # of decimal places. If # of digits is = 0, then # is rounded up to the nearest integer. If # of digits is < 0, then # rounded up to the left of the decimal pt. |

=ROUNDDOWN() | rounds a # down towards zero.If # of digits > 0 (zero), then number is rounded down to the specified # of decimal places. If # of digits = 0, then # rounded down to the nearest integer. If # of digits < 0, then # rounded down to left of decimal point. |

when to use relative cell vs absolute cell in formulas. | When you want a cell reference to remain unchanged no matter where the formula containing it is moved, then you use an absolute cell reference. You indicate a cell reference is absolute by placing a $ sign ($) before the column & row part of cell ref. |

how absolute cell addresses affect the outcome of a formula | ? could not find answer. |

Created by:
PLJeff