Home 
Miscellaneous

comp 25 excel quiz
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.builtin 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 nonblank, nontext cells 
=COUNTA()  nonblank 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