UNR IS 101 Final Terms (Reed) UPDATED ACTUAL Questions And Correct
Answers
Terms in this set (97)
Name Box The easiest way to determine the address of a cell
Formula Bar Where you can look to determine if a cell is a value or a calculation
Active Cell The cell that is highlighted in green
Number Formats Only changes the format of a cell (the way it looks), ex. number, accounting,
currency, percent
Equal Sign How to signify to excel that you're beginning a formula or function
Formula vs. Function A formula is an expression which calculates the value of a cell. Functions are
predefined formulas and are already available in Excel.
Order of Operations Dictates the way in which a formula will be solved
Relative References When a formula is changed by dragging cells
Absolute References Keeps the column or row from changing when dragging a function or formula that
has that cell reference, (ex. $A$5)
Mixed References A mixed reference is a reference that refer to a specific row or column. For
example, $A1 or A$1.
F4 Button used to change between referencing types. Adds dollar sign ($) before
column or row of cell reference or both.
Know what the dollar sign does ($) Locks the column or row from changing when dragging the formula or function to
other cells
Methods of inserting a function in a cell 1. Insert Function Button
2. Formula Tab > Choose Function Category > Choose Function
3. Home Tab > Editing > Choose Function
4. Type "=", Name of Function, Arguments
Proper Syntax of a Function The basic syntax for a function is the equals sign (=), the function name (SUM, for
example), and one or more arguments.
MIN Finds the smallest value
MAX Finds the largest value
SUM Totals one or more values in a range of cells
, AVERAGE Averages one or more values in a range of cells
LARGE Used to return the largest value in a range of cells
SMALL Used to return the smallest value in a range of cells
TODAY Returns the current system date
NOW A built-in function in Excel that is categorized as a Date/Time Function
PMT Helps to determine the payment on a loan
VLOOKUP Is an Excel function to lookup and retrieve data from a specific column in table
IF Evaluates a logical expression and returns one value if true & another value if false
= Equal To
> Greater Than
>= Greater Than or Equal To
< Less Than
<= Less Than or Equal To
<> Not Equal To
Arguments in functions Are separated by commas (,)
An argument is optional if it is shown in square brackets [] or if it's bolded in your insert function dialog
box
A nested function is a function that resides as an argument inside of another function (ex.
=IF(AND(B7<300,B18>700)
A cell range looks like A4:C20 and references every cell from the first cell (A4) through the last
cell (C20) and every cell inbetween
Colon (:) Separates the cell references in a range
Range Name When assigning a name like "expenses" to a range
4 Most Common Chart Types 1. Column
2. Bar
3. Line
4. Pie
Answers
Terms in this set (97)
Name Box The easiest way to determine the address of a cell
Formula Bar Where you can look to determine if a cell is a value or a calculation
Active Cell The cell that is highlighted in green
Number Formats Only changes the format of a cell (the way it looks), ex. number, accounting,
currency, percent
Equal Sign How to signify to excel that you're beginning a formula or function
Formula vs. Function A formula is an expression which calculates the value of a cell. Functions are
predefined formulas and are already available in Excel.
Order of Operations Dictates the way in which a formula will be solved
Relative References When a formula is changed by dragging cells
Absolute References Keeps the column or row from changing when dragging a function or formula that
has that cell reference, (ex. $A$5)
Mixed References A mixed reference is a reference that refer to a specific row or column. For
example, $A1 or A$1.
F4 Button used to change between referencing types. Adds dollar sign ($) before
column or row of cell reference or both.
Know what the dollar sign does ($) Locks the column or row from changing when dragging the formula or function to
other cells
Methods of inserting a function in a cell 1. Insert Function Button
2. Formula Tab > Choose Function Category > Choose Function
3. Home Tab > Editing > Choose Function
4. Type "=", Name of Function, Arguments
Proper Syntax of a Function The basic syntax for a function is the equals sign (=), the function name (SUM, for
example), and one or more arguments.
MIN Finds the smallest value
MAX Finds the largest value
SUM Totals one or more values in a range of cells
, AVERAGE Averages one or more values in a range of cells
LARGE Used to return the largest value in a range of cells
SMALL Used to return the smallest value in a range of cells
TODAY Returns the current system date
NOW A built-in function in Excel that is categorized as a Date/Time Function
PMT Helps to determine the payment on a loan
VLOOKUP Is an Excel function to lookup and retrieve data from a specific column in table
IF Evaluates a logical expression and returns one value if true & another value if false
= Equal To
> Greater Than
>= Greater Than or Equal To
< Less Than
<= Less Than or Equal To
<> Not Equal To
Arguments in functions Are separated by commas (,)
An argument is optional if it is shown in square brackets [] or if it's bolded in your insert function dialog
box
A nested function is a function that resides as an argument inside of another function (ex.
=IF(AND(B7<300,B18>700)
A cell range looks like A4:C20 and references every cell from the first cell (A4) through the last
cell (C20) and every cell inbetween
Colon (:) Separates the cell references in a range
Range Name When assigning a name like "expenses" to a range
4 Most Common Chart Types 1. Column
2. Bar
3. Line
4. Pie
