Save or or taken Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.

focusNode
Didn't know it?
click below

Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
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

# comp 25 excel quiz

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

Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

• SPACEBAR - flip the current card
• LEFT ARROW - move card to the Don't know pile
• RIGHT ARROW - move card to Know pile
• BACKSPACE - undo the previous action

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
 "Know" box contains: Time elapsed: Retries:
restart all cards